This script will provide a dynamic mechanism to decide between REBUILDING an index or simply REORGANIZING an index. Tested and approved for SQL Server 2005 & 2008 Standard or Enterprise or R2.
2012-11-26 (first published: 2012-10-18)
3,857 reads
A very useful query that will allow you to monitor the resource governor memory grants along with other useful information.
2011-03-03 (first published: 2011-02-14)
3,185 reads
A useful script that I wrote that will sample the DMV sys.dm_os_performance_counters table to provide an average PLE captured in (1) minute intervals.
2010-12-01 (first published: 2010-11-16)
1,664 reads
By SteveHood79
When I get alerts from SQL Server I want it to do three things...
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By Kevin3NF
SQL Server backups are database insurance – you don’t really appreciate them until disaster...
Comments posted to this topic are about the item Upgrades to SQL Server 2022
Comments posted to this topic are about the item Elements of the SQL Server...
I am working with a script to exclude certain data types, and I was...
What is the earliest version from which you can directly upgrade to SQL Server 2022?
See possible answers