Move a hierarchyid subtree while keeping stable node identifiers. Check the whole branch, repeated requests, missing endpoints and cyclic destinations.
SQL SERVER – 2005 -Track Down Active Transactions Using T-SQL
Want to track down active transactions in your database? One simple DMV query on sys.dm_tran_session_transactions returns them in SQL Server 2005.
Reading SQL Server Error Messages Carefully
Reading SQL Server error messages carefully means using number, severity, state, and line to narrow the cause before searching.
ACID Properties Shown With Real Transactions
ACID properties shown With Real Transactions uses short SQL Server scripts to explain atomicity, consistency, isolation, and durability.
Writing Tests for Stored Procedures
Write tests for stored procedures with arrange, act, and assert steps in T-SQL, isolated data, and a repeatable check before every change.
SQL SERVER – Two Connections Related Global Variables Explained – @@CONNECTIONS and @@MAX_CONNECTIONS
@@CONNECTIONS and @@MAX_CONNECTIONS explained: login attempts since SQL Server started versus the most simultaneous user connections allowed.
THROW or RAISERROR
THROW or RAISERROR changes how SQL Server handles severity, formatting, and XACT_ABORT; choose the right pattern for new procedures.