SQL Server 2008 and 2008 R2 Diagnostic Information Queries
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008 and SQL Server 2008 R2. These...
2010-09-18
3,916 reads
Glenn Berry
SQL Saturday #52 in Denver
Its only about a week until SQL Saturday #52 in Denver. This is an all day, free event, being held...
2010-09-17
637 reads
Hardware 201:Selecting and Sizing Database Hardware for OLTP Performance
I did a presentation for the fourth hour of 24 Hours of PASS – Fall 2010 today, which was a lot...
2010-09-16
818 reads
Some Moderately Big Iron on x64
Here is a screenshot from a Dell PowerEdge R910 with four 2.27GHz Intel Xeon X7560 processors and 256GB of RAM....
2010-09-08
1,003 reads
Discount Code For SSWUG Ultimate Virtual Conference
If you are interested in watching some high quality SQL Server content from the comfort and convenience of your own...
2010-09-03
740 reads
Hardware Performance Research
I am trying to gather some information about some of the newer Intel and AMD processors as part of my...
2010-08-30
1,891 reads
How Old Are Your Database Statistics?
Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having...
2010-08-30
10,965 reads
SQL Server 2008 R2 Diagnostic Queries from SQL Saturday #51 Nashville
Here are the diagnostic queries that I ran during my presentation at SQL Saturday #51 in Nashville on August 21,...
2010-08-24
1,203 reads
DMV Emergency Queries From SQL Saturday #51 in Nashville
I wanted to post the first T-SQL script from my DMV Emergency Room presentation on August 21 in Nashville. This...
2010-08-23
1,715 reads
Estimating Data Compression Savings in SQL Server 2008 and 2008 R2
Since I finished upgrading the last of my Production environment to SQL Server 2008 R2 running on Windows Server 2008...
2010-08-23
3,113 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
Having Issue deploying a report to an on prem server from PowerBI desktop
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers