Resource Hog! What’s my busiest database?
Imagine that we’re seeing very heavy load on our SQL server, be it CPU or IO and we need to find out which database is the driver. I’m sure...
2022-05-11 (first published: 2022-05-03)
1,111 reads
Blog Posts
Restore Database or Restore Log?
How long has this worked, and why didn’t anyone tell me? A typical restore statement from a FULL backup and a LOG backup: USE [master] RESTORE DATABASE [XE_demo] FROM...
2022-05-11
39 reads
T-SQL Tuesday #150: Your First Technical Job
T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Kenneth Fisher (blog | twitter) asks us to talk about our...
2022-05-11
2 reads
Daily Coping 10 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-10
16 reads
Mic Check
Is this thing on? If you’re reading this test post, it means DNS has updated properly and I’ve successfully migrated to Azure Static Web Sites. Welcome!
2022-05-10
7 reads
My First Technical Job: T-SQL Tuesday #150
It’s that time of the month again for a T-SQL Tuesday blog party. This month is hosted by Kenneth Fisher, who has hosted a few times in the past....
2022-05-10
57 reads
My job managing a calling list. : T-SQL Tuesday #150
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I ... Continue reading
2022-05-10
9 reads
Daily Coping 9 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-09
38 reads
Database Design for Tracking Solar Production
We had a solar system installed at our house this year. I’m excited to see how this performs, as our estimates and research shows this ought to be a...
2022-05-09 (first published: 2022-04-27)
332 reads
Friend of Redgate 2022
I am honored and humbled to be chosen to be part of the Friend of RedGate program for another year. This program is near and dear to my heart, and I look forward...
2022-05-09
39 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