August, 2011

Introduction : In this blog we will see how to add a stopword in a stoplist and also look at one of the common scenario which DBA face when they upgrade from SQL 2000\2005 to 2008 keeping compatibility level 80. So to introduce the topic lets know few...

Problem Description: Indexes gets fragmented soon after rebuilding index Detailed description You have a table with  index created on it.  Logical Fragmentation for the index comes to 99 %. You did re-indexing of the index with Rebuild option...

Let’s say you have an environment which implements DNS forwarding. In such a setup, the client uses a different name (or FQDN) while connecting to SQL Server than the actual SQL Server name (or FQDN). The connection request is forwarded to actual SQL...

Recently, I worked on a case with one of my clients wherein SQL Server was encountering several deadlocks when they were running Stress Tests from application. They had tried several techniques to resolve this issue including forcing an index on the query...

SCENARIO: 1)You have an MDF file from a database which has grown up to a size that has almost exhausted the disk space. 2)You now want to keep the MDF from growing further. 3)You also want to transfer the data from the MDF file to the NDF file...