Nice little bit of Code, Thanks!

You are right, update stats is a left over from old shotgun solutions which in this case is redundant.

Shrink file has the advantage of reducing the size...

One More SSIS CBT site

Thanks crever at Sql Server Central

http://MidnightDBA.ITBookworm.com

JumpStartTV has the largest selection I have found and I owe Brian Knight for this.

Here are a couple CBT

http://www.microsoft.com/downloads/details.aspx?FamilyId=308C5631-F196-4B00-9320-DEC1FDA8BB0C&displaylang=en

http://www.microsoft.com/downloads/details.aspx?FamilyId=C09E251F-F8DF-46F0-B4AC-FBE567277722&displaylang=en

and another good site

http://www.codeproject.com/info/search.aspx?artkw=SSIS

Cheers

From a maintenance standpoint please add a column (auto increment) and clustered index. Even if you never use the column in queries it will give you maintenance and optimization options...

Yes I loved CTRL+B as much as Win+E for explorer

Sql2005 had provided Ctrl+R to raise and lower the result pane.

Good luck and have a great time.

dmb

I concur with RGR,us.  That is what they are and they are handy for hints on where to add indexes.