Make keeping up SQL Server knowledge manageable with release-note reviews, one deep topic each quarter, and a small record of relevant changes.
SQL SERVER – SELECT TOP Shortcut in SQL Server Management Studio (SSMS)
Want a SELECT TOP shortcut in SSMS? Besides the right click Select Top 1000 menu, you can set up your own keyboard shortcut to see the top rows.
A Daily DBA Checklist You Can Run as One Script
Run a daily DBA checklist that reports stale backups, failed jobs, offline databases, recent errors, low volume space and current blocking.
geometry STCrosses: Crossing Depends on the Intersection Dimension
geometry STCrosses uses the dimension and interior position of the intersection to define crossing. I compare it with endpoint contact and collinear overlap. A shared point or segment does not automatically satisfy that definition.
Watching the tempdb Version Store
Watch the tempdb version store with per-database space DMVs, find transactions that delay cleanup, and plan capacity from trends.
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot
A Snapshot database is a read-only, static view of a source database. I explain how it works and how to restore a database from a snapshot.
SQL SERVER – Enable Identity Insert – Import Expert Wizard
An SSIS package failed with an identity error because both tables had identity columns. Checking Enable identity insert in the Import Expert Wizard fixed it.