Another vote for the T-SQL Recipes book. That one is pretty cool.

I would not do it because of the consistency issues in the backup scripts. However, should work perfectly fine when go to restore.

In addition to looking at the execution plans, use extended events to capture the wait statistics for each query. Understand what is making one slower than the other. It's likely...

Insurance company I used to work for LOVED geospatial data. "Now where is...

What version and service pack of SQL Server? I ask because CXPACKET waits have changed. They used to be noise. Now they're not. Here's an article from the...

Really? I'll check in with my guys. I might have some suggestions then.

My point still stands though. I know I'm dependent on SQL Prompt because I remember less...

Everything xsevensinzx says...

However, if you get stuck to where you can't do both, the newer versions of SQL Server offer a bit of an out. With the ability...

Changes made to data in tables or changes made to the tables themselves? If the latter, get your database into source control and deploy changes from there. That will be...

I'd suggest using source control on all the database to track changes. That way, any change made to the extended properties goes through source control, you have versions. That's going...

I'm biased because they're my employer, but I heartily recommend Redgate SQL Monitor. One thing that you might really appreciate about it is that we have lots of...