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.