Inspect a view’s columns and their data type with SQL Server catalogs, result-set metadata, and checks for stale view definitions.
Interview Question of the Week #003 – How to Write Script for Database Cursor?
Write a database cursor with LOCAL FAST_FORWARD, understand cleanup and fetch status, and compare the loop with a set-based update.
Interview Question of the Week #002 – Script to Find Byte Size of a Row for All the Tables in Database
Calculate the byte size of a row carefully, separating declared column limits, actual values, row overhead, and off-row storage.
Interview Question of the Week #001 – Script to List Foreign Key Relationships and Constraint Name
List foreign key relationships with schema names, matched columns, referential actions, and trust flags using SQL Server catalogs.
SQL SERVER – How to Catch Errors While Inserting Values in Table
Want to catch errors while inserting values into a table? Use TRY…CATCH. This simple example captures the error number and message.
SQL SERVER – Basics of Delayed Durability in SQL Server 2014
SQL Server 2014 adds Delayed Durability, which puts performance ahead of durability. I explain it in simple questions and answers, starting with full durability.
Explain a SQL Server Index in Sixty Seconds, Then Prove It
How to explain a SQL Server index in an interview in about a minute, then prove every word with one table. On SQL Server 2025, the same query read 5,737 pages with no index, 133 with a plain index and 3 with a covering index. Three extra indexes doubled the log of 20,000 inserts.