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
70-461 Training
Free SQL Server Training Videos
Over the last year, I have published many videos to YouTube with Free SQL Server Training. You can find these on my YouTube Channel at… Read More »Free SQL Server Training Videos
TSQL Training: JOINs
>>> Try our JOIN Types Course Today! Today’s training will be on JOINs. Here is the outline for the training. Basic SELECT INNER JOIN LEFT… Read More »TSQL Training: JOINs
Using The TSQL EOMONTH Function
Here is a quick video training on how to use the T-SQL EOMONTH function on SQL Server. This was originally part of my free SQL query training… Read More »Using The TSQL EOMONTH Function
Using The TSQL DATEADD Function
Here is a quick video training on how to use the T-SQL DATEADD function on SQL Server. This was originally part of my free SQL query training… Read More »Using The TSQL DATEADD Function
Using The TSQL DATEDIFF Function
Understanding the transact sql (T-SQL) DATEDIFF Function: A Comprehensive Guide In this video, we dive deep into the DATEDIFF function in T-SQL, a powerful and… Read More »Using The TSQL DATEDIFF Function
Using The TSQL DATEPART Function
Here is a quick video training on how to use the T-SQL DATEPART function on SQL Server. This was originally part of my free SQL query training… Read More »Using The TSQL DATEPART Function
Using the TSQL GetDate Function
Here is a quick video tutorial on how to use the T-SQL GetDate function on SQL Server 2012, SQL Server 2014 or newer. This was originally… Read More »Using the TSQL GetDate Function
Using the TSQL CASE Statement
Here is a quick video tutorial on how to use the T-SQL CASE function on SQL Server 2012, SQL Server 2014 0r newer. This was originally… Read More »Using the TSQL CASE Statement
TSQL OUTER JOINS (LEFT and RIGHT)
>>> Try our JOIN Types Course Today! After learning the INNER JOIN when querying SQL Server, the LEFT OUTER JOIN and RIGHT OUTER JOIN are often… Read More »TSQL OUTER JOINS (LEFT and RIGHT)