indexes

/Tag:indexes

SQL Server ALTER TABLE REBUILD

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 [...]

By |September 22nd, 2014|SQL Server|3 Comments

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 [...]

By |May 2nd, 2014|SQL Server|1 Comment