microsoft sql

SQL301

SQL 301–FOR XML PATH

OK, I've covered FOR XML RAW for simple quick XML outputs. Then I covered FOR XML AUTO, while it automatically handles simple hierarchical data, it's still

SQL301

SQL 301-FOR XML EXPLICIT

OK, so far I've covered FOR XML RAW. It's a pretty simple way to crank out some XML when you need to. FOR XML AUTO has better support for hierarchies, but it

SQL301

SQL 301-FOR XML AUTO

In my previous XML article, I covered FOR XML RAW. It's useful, if limited. This time I'd like to cover XML AUTO. It's still limited, but if you're looking to

SQL301

SQL 301-FOR XML RAW

OK, I need to study my XML queries, so I'm going to write them up as I go. That way you can learn along with me. In a normal query we return the results in

etl

SQL 301-BIDS, The First time around

In my last post, we used the Import and Export wizard to create a simple Load process. We loaded names.csv into a simple table. Let's open Visual Studio 2008

SQL301

SQL 301 — SSIS Import And Export Wizard

OK, let's dive right into the Import and Export Wizard. If you're on Vista or Windows 7, hit start, then begin typing "Import and Export Data" It should find

SQL301

SQL 301 – Introduction to SSIS

I've been getting requests to cover SSIS, so here we go. Over the next few months I'm going to give you a course that will help you go from knowing what SSIS

sql202

SQL 202-Locking and Blocking

At a recent Charlotte SQL Server Users Group meeting, one member asked what's the difference between locking and blocking. I figured I'd cover that today.

sql202

SQL 202-Interpreting your Execution Plan

OK, I've explained how you can see the execution plan for your query (either the actual or the estimated). So now you can see your plan...Now what? What do you

sql202

SQL 202-Indexes with WHERE clauses

So I have this table in my new database that is used as the base table for more than 50% of the queries that are run on my server. It's our product table. Along

sql202

SQL 202-Covered Indexes

By this point you should feel pretty comfortable with what an INDEX is and what it does for your queries. Basically it provides the server to find your data

sql202

SQL 202-Theoretical Exection Orders

When you send a query to the server, there's an order to the steps the server will take to retrieve the data you're looking for. It's important to have an