The DMOs related to query performance are basically, what is absolutely executing right now, sys.dm_exec_requests, or, an aggregate of queries that have executed for the queries currently in cache, sys.dm_exec_query_stats...

Test all three and see which one does what you want in the most efficient manner.

Probably, I'd look at #3 first, but it really depends on what the execution plan...

Devesh_Srivastava (7/19/2012)

---

Hi,

If the size of databases are very large and you are using backup compression technique then you should not include the Verify Backup option in the Backup job as...

Query Tuning

Execution Plans

Backups

Monitoring

Development & Deployment processes

Deadlocks

Parameter sniffing

Rinse and repeat

Ah, I don't think it displays status for that recovery process. I think you'll have to wait. Sorry.

I have several different versions of this type of query in this article[/url]. Take a look. I think you'll find something to help.

I would get a full understanding of the state of the backups. In addition, what are the maintenance routines currently in place. After that, I'd want to work on establishing...

You can take a look at the DMO sys.dm_exec_requests. For a backup or restore it will show a percentage complete. It's not a perfectly accurate measure, but it will be...

You can get that right out of the Dynamic Management Objects (DMO). This will get that piece of data:

SELECT deqs.creation_time FROM sys.dm_exec_query_stats AS deqs;

In general, to coordinate databases with code, the best approach I've found over the years is to get your database into source control. That used to be quite difficult, but...

Disregarding the size of the databases, how many user connections does each have? What are the transaction rates? If there is more activity on one than the other, then you're...

You can change the alert to capture 1222. Or you can add 1205 traceflag so you get both, but that makes for very messy error logs.

And you're only ever taking the tail log backup in an emergency recovery situation anyway. Just take the backup and then use it as part of the recovery (if needed)....

The only way you can have foreign key constraints in place and still have orphaned records is for the foreign keys to have been added using the NOCHECK option after...

rodjkidd (7/17/2012)

---

Grant,

Good to see you are still communicating fairly normally! I guess 6 sessions in two at SQL in the City just wasn't enough to push you over the edge....