2025-09-17
1,673 reads
Fragmentation
SQL Server Fragmentation Impact with Modern Hardware
Read this article to find out if you still need to worry about SQL Server index fragmentation with modern hardware.
2023-11-03
[Video] Fragmentation Explained in 20 Minutes at SQLBits
What does fragmentation mean? How does it happen? Can you fix it with fill factor? Should you rebuild your indexes to fix it?
2022-09-26
Index fragmentation on all databases
The script returns all the fragmented indexes on all databases on the instance you run it. Can be run on multiple instances in the same time using central management capability.
2021-07-12 (first published: 2021-07-06)
3,962 reads
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)
3,216 reads
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,562 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,725 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
809 reads
Blogs
Finding the Last Last Name in SQL: #SQLNewBlogger
By Steve Jones
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got...
SQL Server 2025 GAs Today
By Steve Jones
If you aren’t watching the Ignite keynotes today, then you might have missed the...
Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe
Short version You want to get this running as fast as possible. Do these...
Forums
Email change does not work
I changed my email address in Edit Profile page, but it has no effect...
The case for "Understanding our business" training
Comments posted to this topic are about the item The case for "Understanding our...
Specifying the Collation
Comments posted to this topic are about the item Specifying the Collation
Question of the Day
Specifying the Collation
I am dealing with issues on my SQL Server 2022 instance related to collation. I have an instance collation of Latin1_General_CS_AS_KS_WS, but a database collation of Latin1_General_CI_AS. I want to force a few queries to run with a specified collation by using code like this:
DECLARE @c VARCHAR(20) = 'Latin1_General_CI_AS'
SELECT p.PersonType,
p.Title,
p.LastName,
c.CustomerID,
c.AccountNumber
FROM Person.Person AS p
INNER JOIN Sales.Customer AS c
ON c.PersonID = p.BusinessEntityID
COLLATE @c
Will this solve my problem? See possible answers