Home/Tag: indexes


Hi Friends, I see a common practice with DBAs: If you have to rebuild a HEAP, you will create a clustered index and drop it – this two phase process does the rebuild job, but is expensive. SQL Server supports ALTER TABLE REBUILD command to rebuild a heap. Creating a dropping a clustered index, the [...]

SQL Server Dynamic Index seek operation

Hi Friends, Indexing is a wonderful thing. We all know about Index scans and seeks. Today I want to talk about SQL Server dynamic index seek operation. I find it tough to explain in words so I will straight away use an example without further ado ! Suppose you run the following query (turn on [...]