Dinesh's Blog :::: Being Compiled ::::

Everyone knows that SQL Server creates a Clustered Index  when we add a Primary Key  if there is no Clustered Index  already exist in the ...

I have written few posts on Index Fragmentation and how they can be checked. External Fragmentation occurs as a result of Page-Split  and ...

Indexes get fragmented based on the operation we perform against records and modification we do against index keys. We use one of the Dyna...

Fill Factor is a setting that uses with Indexes for determining how much free space remains on each leaf-level page for future operations ...

A column like email address  in en entity like Customer or Employee is always set with an UNIQUE Constraint  to make sure that no duplica...

In order to improve the loading performance, specifically when a data warehouse or a large table is loaded, it is recommended to disable c...

SQL Server mainly maintains two structures for tables: Heap  and Clustered . If there is no clustered index created with the table, table ...

If we are loading a large volume of data into an indexed table, we always drop the index, load the dataset, and re-create indexes assuming...

Here is another tricky question? It is on Indexing. Can we create an index without mentioning what column(s) to be used? Obviously...

This is one of the questions I got in last week. To make it more clearer, the question is, when we have 1,000,000 records in a clustered-st...

Assume that an index has been created using three columns. Will SQL Server use the index if the 2nd column is used for filtering? I asked ...

Here is the presentation used for discussing SQL Server indexing. This discusses index structures, storage patters and different implemen...

If you have worked with large databases (or data warehouses), you have already seen enough of scenarios where you do not get much benefits o...

Indexes are added mostly based on WHERE conditions used with queries execute frequently. Once the index is added, it speeds up the search on...

GUIDs are commonly used in distributed applications which require “uniqueness” across the entire world. Unfortunately I have seen the usage ...

Index fragmentation is something we need to monitor frequently specifically on databases that are heavily indexed. If indexes added are frag...

DBCC IND command is one of the important commands used when indexes are analyzed. Specifically this can be used for seeing the linkage betwe...