A stored procedure is SQL with a name, a door and a contract. Why granting EXECUTE beats granting table access, what parameters buy you, and the plan reuse story people get half right.
What Is tempdb, and Why Everyone Shares It
tempdb is one scratch database shared by every database on the instance. The three kinds of thing that land in it, why it is rebuilt at every restart, and the reason its file count keeps coming up.
What Is a Transaction in SQL Server?
A transaction in SQL Server is a group of changes that all happen or none do. A rollback that undid 16,440 rows, what ACID means in four short words, and the open transaction that quietly fills a drive.
SQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052
I take my puzzle to the next level with SET ANSI_NULLS OFF. Why do two different queries now return almost the same results? Watch the 60 second video.
SQL SERVER – RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds #051
Episode 51 of SQL in Sixty Seconds shows how to RESEED identity column values to a number higher, or even lower, than the current one.
SQL SERVER – Interview Questions and Answers Sample Chapter Free Download – SQL in Sixty Seconds #050
SQL in Sixty Seconds hits its 50th episode and a full hour of play time. To celebrate, get a free SQL Server Interview Questions and Answers sample chapter.
SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049
Old server names clutter the SSMS Connect dialog. This SQL in Sixty Seconds video shows how to remove cached login entries in SQL Server 2012 and earlier.