How are you measuring the Buffer Cache Hit Ratio on a per database basis? It's a server level metric. It's also pretty useless as a metric. Same thing goes for...

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...