-
Rebuild master database
Recently, the default instance of Sql Server 2005 on my laptop refused to start. Here is the message in the Windows event log: The SQL Server (MSSQLSERVER) service terminated with service-specific error 3417 (0xD59). Here is the message in the Sql Server error log: The log scan number (253:272:1) passed to log scan in database…
-
Looking for unused indexes and checking index fragmentation in Sql Server 2005
Here is a script to check unused indexes in your Sql Server 2005 databases. Once one particular index has been used, the dm_db_index_usage_stats will be updated. All this information will be lost every time Sql Server instance is cycled. Therefore, you should run it after Sql Server has been running for a while, as it…
-
More book giveaway
The first book I co-wrote, on Sql Server Integration Service, has been translated to Chinese. I have about 10 copies to give away. The second book I co-wrote, on Sql Server 2005 administration, has been translated to Italian. I have 2 copies to give away. Last time I gave my books away, I took care…
-
Sql Server 2005 AWE on Windows 2003 32-bit
Here are steps to enable AWE so that Sql Server 2005 can use additional memory, if your physical memory is more than 4 GB on 32-bit Windows 2003 box. 1. Add /pae at the end of last line inside c:\boot.ini 2. Run gpedit.msc. On the left hand pane, expand Computer Configuration, expand Windows Settings, expand…