SET DEADLOCK_PRIORITY
SET DEADLOCK_PRIORITY HIGH;BEGIN TRANSACTION;— Your critical transaction code hereUPDATE Orders SET Status = ‘Processed’ WHERE OrderID = 12345;COMMIT TRANSACTION; Or set a lower priority for… Read More »SET DEADLOCK_PRIORITY
SQL Server
Log Shipping Restore Threshold
Extending the Log Shipping Restore Threshold in SQL Server Log shipping is a solid disaster recovery (DR) solution in SQL Server, offering automated transaction log… Read More »Log Shipping Restore Threshold
Stedman SQL Podcast: Exploring VLFs and Exciting New Features
Welcome to this week’s episode of the Stedman SQL Podcast! In this episode, we dive deep into an often-overlooked aspect of SQL Server: Virtual Log… Read More »Stedman SQL Podcast: Exploring VLFs and Exciting New Features
Tune in Tomorrow!
Tomorrow June 20th at 1pm PST we launch our very first Live Stream Discussion! Submit a question for our discussion >> Link to our Live… Read More »Tune in Tomorrow!
Live SQL Discussion with Stedman Solutions Kickoff
Join Us for This Live Event – Tuesday 20th – 1pm pacific / 4pm eastern These engaging broadcasts will bring valuable content each week! This… Read More »Live SQL Discussion with Stedman Solutions Kickoff
Introducing a Fantastic New Event!
Introducing – Live SQL Discussion with Stedman Solutions We are thrilled to share the exciting news that our team will now be hosting weekly live… Read More »Introducing a Fantastic New Event!
Steps to help keep your SQL Server running smoothly.
SQL Server is a powerful and complex database management system that is used by millions of organizations worldwide to store, manage, and analyze their critical… Read More »Steps to help keep your SQL Server running smoothly.
What are all the values of the state_desc column in the sys.databases system table in SQL Server?
The sys.databases table in SQL Server contains information about all databases in the current SQL Server instance. The state_desc column in this table represents the… Read More »What are all the values of the state_desc column in the sys.databases system table in SQL Server?
SQL Server Standard Edition vs. SQL Server Express Edition
Microsoft SQL Server is a relational database management system (RDBMS) available in several editions to cater to different needs and requirements. Two of the commonly… Read More »SQL Server Standard Edition vs. SQL Server Express Edition
SQL Server – Security Patches
In the last day or two Microsoft has released several updates with security patches. If you have SQL Server running anywhere, please make sure it’s… Read More »SQL Server – Security Patches