Viewing 9 posts - 1 through 9 (of 9 total)
Thank you for your reply. I have a fairly good understanding the process of switching in and switching out. I agree that partitioning would be useful for switching out...
October 28, 2013 at 8:38 pm
This is great - especially the idea of baselining your configuration data!
On a related note, I log and analyze my performance counters through Performance Monitor, mainly because it's...
November 27, 2012 at 7:40 pm
Thank you Lowell. This saved a lot of time!
June 11, 2012 at 8:17 am
I had the same problem. One thing I noticed was that SELECT * FROM INFORMATION_SCHEMA.TABLES executed in about 100 mS, while EXEC SP_TABLES was averaging about 3 seconds.. ...
May 14, 2012 at 9:58 am
Here are two useful reference URLs for trace flag 610:
June 3, 2010 at 2:44 pm
If you can perform the move during a time that the databases are static, perhaps on the weekend, you can temporarily shut down the SQL Server Agent service(s) that are...
July 21, 2009 at 12:52 pm
Here's a simple script for getting volume capacity and free space info when you have mount points. It uses a combination of WMI, ADO, and VBSCript. You...
June 25, 2009 at 12:22 pm
This article will give you some insight into why shrinking is often a bad idea: http://www.karaszi.com/SQLServer/info_dont_shrink.asp
November 20, 2008 at 2:53 pm
Excellent! Worked for me as well.
October 10, 2008 at 8:16 am