Best practices for better Database Performance: keep only needed data, normalize tables, use lookup tables and small primary keys. I list 14; you suggest the 15th.
SQL SERVER – 2005 – Transferring Ownership of a Schema to a User
Transferring ownership of a schema to another user in SQL Server 2005 takes one ALTER AUTHORIZATION ON SCHEMA statement. A reader asked, so here it is.
SQL Server – Good Articles on Database Collation
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.