Category: Indexes

SQL Server 2012 Diagnostic Information Queries — Glenn Berry (copied)

— Copied from http://sqlskills.com/blogs/glenn/ — SQL Server 2012 Diagnostic Information Queries — Glenn Berry — June 2016 — Last Modified: June 8, 2016 — http://sqlserverperformance.wordpress.com/ — http://sqlskills.com/blogs/glenn/ — Twitter: GlennAlanBerry — Please listen to my Pluralsight courses — http://www.pluralsight.com/author/glenn-berry —

Find index fragmentation in table

As a DBA, you often get question from developers and users- what is indexing and fragmentation? Well, in simple words indexing is the process of creating index in the table to enhance the performance of queries. Index is created as the subset

Top