SQL 2000 OnlyThis script will create a stored procedure and a table in the master database. Simply run the stored procedure and supply a database name as a parameter. It will do the following:1. Gather/Log DBCC SHOWCONTIG statistics (pre defrag)2. Defragment all user indexes in the database3. Gather/Log DBCC SHOWCONTIG statistics (post defrag)4. DBCC DBREINDEX […]
2010-04-19 (first published: 2003-03-19)
2,201 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I love database audits. They are simple, easy to use, effective, not overly resource...
By Steve Jones
SQL Monitor has improved a lot over the last couple of years. We have...
Comments posted to this topic are about the item Returning To An Employer
Comments posted to this topic are about the item SQL Server Collation
Hello All, It's been a while. See the DDL/DML. I have a multiplier field...
Ask SSC