I would go for breaking down all the objects into the individual create scripts necessary to maintain them.

We use Microsofts Visual Studio Team System Database Edition. It can do full...

Which functions as a very good advertising tool for...

I agree with using views for security purposes, but, as Jeff noted, you shouldn't ever go more than a layer deep on views because you will run into performance issues....

In addition to setting up backups (4 months?), you should put all your data structures and code into source control.

I agree. It makes sense to offer the columns rather than trying to guess if you're excluding them.

I've found intellisense to work pretty well so far. I'm still more in...

Late to the game...

Great comments Steve. I agree 100%. I remember a dot com emergency where I spent almost three days with little sleep and I was messing up at...

I would to research it to verify for sure, but I think you can simply point a monitor at a rule and respond to the data collected there. No extra...

Then what's on page 2?

Regardless, Page 2 needs some help.

I'd still like to see the code.

The painful plan is very large and difficult to read. The one thing that stands out is that it looks like you're performing the same joins over and over again...

Zip the file.

You might also try taking the NOT EXISTS sub-query and making it into a LEFT JOIN and looking for a NULL return. You'd need to test it, but in the...

Pages is literally the number of pages that make up the index. Smaller numbers just mean fewer pages. If your index is seriously fragmented, that number may be a lot...

You're comparing apples to oranges. Spotlight is for spot checking performance and Idera's tool is for collecting data long term AND spot checking performance. If you really want to compare...

Yes, the answer is No.

Can you post the execution plan?