Orders commit and the message vanishes? Save both in one transaction, then let a worker claim, send and retry with a lease. Duplicates are still possible.
Storing Images in varbinary(max): Size, Reads and Backups
Store images in varbinary(max), read file bytes with OPENROWSET, inspect LOB allocation, and evaluate backup and retrieval costs.
SQL SERVER – Listing Primary Key of Table with Stored Procedure sp_pkeys
Here is how to list the primary key of a table with the stored procedure sp_pkeys, a follow up to my earlier post on sp_fkeys.
SQL SERVER – Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys
A quick trick to list all the foreign key relationships of a table with the stored procedure sp_fkeys, with a sample script on AdventureWorks2012.
Learning SQL Wait Stats: The Complete Series Guide
Learning SQL Wait Stats is the fastest way I know to find out why a SQL Server is slow. This guide lists every post in my wait stats series, told as one story about an all-night diner, and answers the questions readers ask before they start.
SQL SERVER – Dude, Where is the SQL Agent Job History? – Notes from the Field #017
A job failed but you cannot find the SQL Agent Job History? John Sterrett explains this common problem he sees in the field and what to do about it.
SQL SERVER – Find Anything in Object Explorer in SSMS
It is easy to find anything in Object Explorer, but how do you find every object where a string exists? Here is my chat with Vinod Kumar about it.
Makers That Sell PCs but Not Laptops: HAVING With Conditional Counts
One WHERE clause cannot say ‘has a PC but no laptop’. Here are three queries that can, and the NULL trap.
Finding Databases With Auto Shrink or Auto Close Turned On
Find auto shrink and auto close settings, generate reviewed correction commands, inspect model, and check the effects of prior shrink work.
Azure SQL Database or Managed Instance
Azure SQL database or managed instance is a choice about compatibility, cross-database work, Agent, networking, and the cost of each service.










