I agree with Matt...if you have the option of configuring a separate LUN/drive for the file storage, you might as well use the hardware you have. File transfers are low...

I am coming into this conversation late..but..if the intent is to establish a unique, increasing, ID for every row in the database, or at least global to specific tables, you...

Would you please tell us what you intend to do with the 'scripted db'..what the end goal is? Is this for source control, the creation of an empty DB, are...

You could also use the Datepart function...returns an integer representation of the year.

WHERE Datepart(yyyy,DateEnd) = 2009

Maybe this is outside of your control...but..from a data normalization standpoint..particularly with text data types which typically consume considerable space...why are you writing the data in two places? That is...

I had a giant problem with dropped packets if a NIC was running over 70% capacity...was resolved by disabling this feature. This only happened on a particular type of server...

You have not made it clear why you need to empty the second data file..or maybe I missed it. If you simply want to move the data off of the...