Thank you for the script. It's a really quick way to look at a table. Sometime, unfortunately, I am tuning "on the fly" and this will help.

Thanks again.

No sure if I am too late for this, but this happened to me two weeks ago. After checking all the usually suspects, I ran Adam Machanic's sp_whoisactive. ...

Very useful. Thank you.

You may already be doing this, but if you set an alert to email you anytime there is an auto-growth, you may have a better shot at catching the offending...

Thank you for the script. Very useful for us small shops on a Budget.

I also recommend the free tool, but if for some reason you cannot, this link from SQL Soldier is worth looking at.

http://www.sqlsoldier.com/wp/sqlserver/transferring-logins-to-a-database-mirror

The easiest way is to manual run the copy job and then manual run the restore jobs to get things back in sync. I have had this happen to...

Here is a great tool from Brent Ozar. He presented on it at PASS and the name of his session was "Why is my server slow, right now?

Jason,

I am not sure if you got a complete answer yet, but I had the same issue last year. The auditors required that the SQL logins have an expiration...

I did this on one of our servers last year. Everything came back except the SQL Server Agent would not start. I had to change the path in...

This is laughable. The speaker I am looking forward to the most at pass is a women. An I am sure other feel the same way. Real...

I use sp_whoisactive; it has saved my life, but I also you the two scripts below when I need a little different info. You can comment out the where...

As always, it is not advisable o shrink a database unless it is an extreme circumstance, like you are running out of disk space, but it can be done. ...

Here is a great article from SQL Diaries that shows the steps to clean up your maintenance plan.

http://www.sqldbadiaries.com/2011/03/16/clean-up-maintenance-plan-history/

It might be helpful to clear your wait statistics, and start to monitor again. I agree with Gail, in that after a couple of months, it is difficult to...