SQL Server Index Hint
SQL Server query optimizer decides which index to use, when a query is requested. SQL Server optimizer is a cost based optimizer so it picks the index which has low cost …
Read MoreTag: Index
sys.dm_db_xtp_nonclustered_index_stats – Day 76 – One DMV a Day
Hello Geeks and welcome to the Day 76 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
Read MoreSQL Server: Engine Estimated time to complete Online Index operations.
There is always a way to work around something even if we are not able find the absolute solution. So the show must go on .I am sure that in any …
Read MoreSQL Server DTA: Finding Unused Indexes
This is another good feature of DTA. There are lot of different scripts available over internet to find unused indexes, however why not use the SQL Servers very own DTA to …
Read MoreSQL Server Clustered Index Physically Orders a Table Revisited
Hi Friends, Continuing on from my last blog post “SQL Server Clustered Index Physically Orders a table”, this post demystifies the myth “Clustered index physically a table”. The order of the …
Read MoreSQL Server Index Fill Factor
Index Fill Factor FILLFACTOR, The FILLFACTOR option allows you to allocate a percentage (0 to 100) of free space on the leaf-level index pages to reduce page splitting. This option is …
Read More