-
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…
-
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…
-
Drop all indexes in Sql Server 2005
Here is a script I wrote to generate a script to drop all indexes that are not primary keys. This works for Sql Server 2005. The main thing it uses is sp_MSForEachTable, an undocumented stored procedure. Run the generated script, and you will be good to go. This is especially useful before a bulk load…
-
Katmai installation notes
I downloaded and installed Katmai, code name for Sql Server 2008, a few weeks ago. My friend Scott Whigham has a great post on it. Here are some of my own observations: 1. The installation process is very similar to that of Sql Server 2005. Here is one screen shot of feature selections: 2. If…
-
Problems with Oracle Migration Workbench
Database vendors like to bash each other, sponsoring dubious “objective industry studies” to “prove” they are better than others. All of them do it. In my opinion, Oracle is particularly bad in this regard, compared against IBM DB2 or Microsoft Sql Server. Talking about “unbreakable Oracle” and software full of bugs, and in many cases…