In this script we create a temporal table and then review all indexes with next conditions.
avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %
2008-09-03 (first published: 2008-07-10)
4,697 reads
2008-09-03
231 reads
2008-09-02 (first published: 2008-07-10)
2,693 reads
2008-08-27
1,034 reads
2008-08-27 (first published: 2008-07-03)
2,190 reads
2008-08-26 (first published: 2008-07-09)
839 reads
Generacion de numero de registros y espacio usado en disco todas las tablas de la base de datos
2008-08-22 (first published: 2008-06-24)
535 reads
To import the SQL Server error log into a table, so that it can be queried
Written by: Anand Mahendra Tested on: SQL Server 2000
2008-08-21 (first published: 2008-06-30)
785 reads
2008-08-20 (first published: 2008-06-19)
1,133 reads
2008-08-18 (first published: 2008-06-25)
1,745 reads
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Comments posted to this topic are about the item The SQL Server 2016 Plan
hi, a few years ago was at a very large company that bought a...
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers