Database Collation defines default character comparison rules for a database. I also inspect the columns and expressions involved.
A Self-Review Checklist for Stored Procedure Changes
Use a self-review checklist for stored procedure changes: realistic data, plans, IO, NULL inputs, clean rollback, and a ready recovery script.
SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value
How do you find the Nth Highest Salary of an employee? I link my earlier answers and share reader Pravin Phatangare’s simple TOP query for the 6th highest salary.
What to Alert On, and What to Let Sleep
Make SQL Server alerting actionable by tying thresholds to impact, checking missing work, reducing duplicates, and reviewing every overnight call.
DATEPART tzoffset: Read the Signed Offset in Minutes
DATEPART tzoffset extracts an offset in minutes. Preserve its sign, test sub-hour values and retain the source temporal type.
SQL SERVER – Introduction to Heap Structure – What is Heap?
What is Heap? When table data has no logical order and no clustered index, SQL Server stores it as a Heap Structure. I explain pages and extents too.
SQL SERVER – 2005 – List All Column With Identity Key In Specific Database
Question I received in Email : How to list all the columns in the database which are used as identity key in my database?