Heres the DDL for the DB, you will probably have to lower the size of filegroup_1 as it is huge to hold that 80M row table.

CREATE DATABASE [prod_data] ON...

I agree with you 100%. I am currently working on a project where they have made all objects owned by user "rms" and they have turned on Case Sensitivity,...

This may be of interest to you -

there is a free utility in the SQL Server Resource Kit that allows you to automatically compile all of the files in...

Also, I like to have all my packages owned by the same owner. This is especially good if you are developing a system you are going to be selling. If...

Thank you simonsabin,

I am going to have to make some time to look into this stuff further.

You have been very helpful!

Mindy

simonsabin -

I have not had the opportunity yet to use any of the .net programming "stuff" that you are talking about. Sounds very interesting? Would you email me a screen...

Dave -

It is very hard to argue with an application that users are satisfied with and that "works". If you are able to maintain it and everyone is...

Yes, it can be tedious during development, and I see your point. However, (especially in larger teams) I would predict that most of the time the .refresh method would not...

Simon, it is interesting that (I must admit) I did not even know about sp_executesql until a few days after I finished writing this article. I was in a class...