Category Archives: Index

Index Rebuild VS Reorganize

Advertisements

Posted in Basic, Index, Others, Troubleshooting | Tagged | Leave a comment

Denali — Day 5: Column-store indexes (aka Project Apollo)

Denali – Day 5: Column-store indexes (aka Project Apollo)   There is another great achievement for Denali, especially for Data warehouse, where data is static and very huge – READONLY, and user always require data to be retrieved quickly as … Continue reading

Posted in Denali, Index, Performance Tuning | Tagged , , | Leave a comment

Day 7: RE-index job failed – Deadlock

Sometimes our re-index maintenance plan job fails with following error:   Failed:(-1073548784) Executing the query “ALTER INDEX [INX] ON [dbo].[XXX] REBUILD WITH ( FILLFACTOR = 90, PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, SORT_IN_TEMPDB = … Continue reading

Posted in Index, Troubleshooting | Tagged , | Leave a comment

Important: System Objects/Views/DMV/DMF

Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF. Catalog View: All system information is stored on catalog views which look like Sys.xxx Eg. Sys.databases Compatibile views: This are views to manage old compatibility Select * … Continue reading

Posted in DMV, General, Index, Memory, Performance Tuning | Tagged , | Leave a comment

List of indexes and Parallel queries

Today while being on forum found this information so though to blog for future reference. thanx Uri Dimant for sharing this.  WITH cte  AS  (  SELECT object_name(ic.object_id) as object_name , index_name = i.name, ‘column’ = c.name,         ‘column usage’ = … Continue reading

Posted in Index, Performance Tuning, Personal, What I learned today | Tagged | Leave a comment