Fragmentation

No Significant Fragmentation? Look Closer…

  • Article

If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occasional 'edge' conditions on larger tables that will cause severe degradation in performance. It is worth being aware of patterns of data access in particular tables when judging the best threshold figure to use.

2012-03-14

3,229 reads

Blogs

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

By

This is the fourth and final post in a series about modern Data Lake...

SQLOrlando 2019

By

We just had our final event of the year and looking back, not bad...

Read the latest Blogs

Forums

Convert nchar to time and addition functionality

By Rock

I have a scenario: I have a nchar field which is tagged as start...

Index missing from execution plan

By SQLSACT

Hi All Hoping to get something cleared up. I have a query, it runs,...

@AR*https://secchampionshipsec.co/2019/

By all315sporbp

https://secchampionshipsec.co https://secchampionshipsec.co/2019/ https://secchampionshipsec.co/live/ https://secchampionshipsec.co/stream/ https://secchampionshipsec.co/football/ https://secchampionshipsec.co/reddit/   https://accchampionshipthe.co https://accchampionshipthe.co/2019/ https://accchampionshipthe.co/live/ https://accchampionshipthe.co/stream/ https://accchampionshipthe.co/football/ https://accchampionshipthe.co/reddit/  

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers