Remove duplicate indexes in SQL Server 2000
With permission from Kimberly Tripp, the creator of the fantastic duplicate index finder for SQL Server 2005 and 2008, I have ported this duplicate index finder to SQL Server 2000. I am fortunate in many…
My brain hurts
Kimberly Tripp has a very neat series of stored procedures on her blog which are rewrites of sp_helpindex. Unfortunately for those of us with customers still using SQL Server 2000, these scripts are useless, because…
Increasing the number of SQL Server Error Logs
Via Tim Radney, here’s a quick and easy way to increase the number of error logs from the default of six. The blog post also has a walkthrough in SQL Server Management Studio if you…
Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000
For those of you battling with a 64-bit SQL 2005 Server linking to 32-bit SQL 2000 Servers, here’s a handy solution. This problem has been plaguing us for a while now, and today I made…
- « Previous
- 1
- …
- 4
- 5
- 6