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.
SQL SERVER – What is the Difference Between Latches and Locks
What is the difference between latches and locks? Latches guard a page only during the physical operation, while locks last for the whole transaction.