microsoft sql

ssis

SQL301-ETL With SSIS, Part 4

We're back to our ETL with SSIS project, and today we're going to pick up with transforming the data from our raw format to the final destination for our

dev

SQL 102 – UNIQUE INDEX

Ok, you understand how to create an INDEX. You understand the differences in CLUSTERED and NONCLUSTERED indexes. Did you know you could index a view? You can.

ssis

SQL 301-ETL With SSIS, Part 3

Ok, so in our SSIS package we currently have all our variables set up, we have a for each loop that will look in a certain folder for all files matching a

t-sql

Code to Write Code

I've read "When you start writing code that writes code for you, you've moved up from a beginner to a professional." Today I'd like to walk you through an

t-sql

Get Rid of the Duplicate Records

Time after time I'll get a table that has duplicates in it and I have to clear out all the duplicate entries while leaving a distinct set of records. There's a

ssis

SQL 301 – ETL With SSIS, Part 2

In my last post on SSIS, I started you into developing an ETL solution with SSIS. I walked you through setting up your solution, renaming the package, and

t-sql

SQL 102 – CLUSTERED vs. NONCLUSTERED Indexes

Previously, I covered the basics of creating an index using CREATE INDEX. Today, I'm going to dig a little deeper. I'd like to teach you the difference in an

microsoft sql

70-433:Good, Better, Best Index Selection

With SQL Server 2008, you've got some additional tricks you can pull off with indexes. With 2005 you could INCLUDE columns in your index, now with 2008 you can

ssis

SQL 301 – ETL With SSIS, Part 1

I’ve discussed SSIS on this site before, but I’ve heard the feedback, you want real world examples. So, I decided to use the business case I address most often

t-sql

SQL 301 – Views

At this point I'm sure you know how to CREATE and ALTER a VIEW. But today I'd like to go into a little more detail on views. I'd like to cover updatable views,

t-sql

Find Tables Containing a Certain Column

Today I had to find all the tables that contained a certain column. I was going to rename the column, so it made more sense when you see it in my tables. In

microsoft sql

sp_executesql

I'm pretty sure this is the first time I've brought up dynamically generated SQL statements. But it's time you learn about them. There are times where you'll