Defrag All Indexes On a Database
Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.
2012-05-25 (first published: 2012-05-15)
2,538 reads
Fragmentation
The Real World: Fragmented Disk and High PAGEIOLATCH Waits
This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.
2012-04-20
6,351 reads
No Significant Fragmentation? Look Closer…
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
Analyze and Fix Index Fragmentation in SQL Server 2008
This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation
2008-12-11
2,876 reads
2008 Index Fragmentation Maintenance
Just a stab at automating index maintainenance in SQL Server 2008
2013-01-11 (first published: 2008-11-07)
2,551 reads
Are disk volumes fragmented on server? Does it require to be defragged
Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.
2008-10-24
784 reads
2008-05-15 (first published: 2008-02-29)
3,248 reads
Blogs
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4
By Gerard
This is the fourth and final post in a series about modern Data Lake...
Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.
I love this error. Primarily because it demonstrates two very important things. Errors matter....
Forums
Convert nchar to time and addition functionality
I have a scenario: I have a nchar field which is tagged as start...
Index missing from execution plan
Hi All Hoping to get something cleared up. I have a query, it runs,...
@AR*https://secchampionshipsec.co/2019/
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/
Ask SSC