How do you find which table has a transaction lock and what lock type it is? Imran Mohammed explains it for SQL Server 2000 and 2005, and how to avoid locks.
Stable Weekday Numbers Without Changing DATEFIRST
Stable weekday numbers use a fixed Monday anchor and negative-safe modulo. Map Monday to one without changing DATEFIRST or session language.
Generating Backup Commands for Every Database With STRING_AGG
Use STRING_AGG for generating backup commands with copy-only backups, checksums, safe database names, and dated files for careful review.
SQL SERVER – 2008 – Introduction to Online Indexing Operation
An introduction to online indexing in SQL Server, which lets you create or rebuild an index while the table stays available to your app.
Splitting a URL Into Host, Path and Query String in T-SQL
Practice splitting a URL into host, path, and query values with T-SQL string functions, SQL Server 2025 regex, and ordered parameter rows.
ABS: Widen an Integer Before Taking Its Magnitude
ABS can overflow even when the negative input fits its signed integer type. I widen the input before asking for its magnitude. Casting the output afterward would be too late to protect the calculation.
SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle
Is there a MINUS clause in SQL Server like in Oracle? Yes, EXCEPT returns the rows of the first query that are not in the second. Example included.