How do you stop people from using SELECT * in views? A slow query in a Health Check came from SELECT * over a wide view, so here is one way to prevent it.
Checking Optional Features Installed on an Instance From T-SQL
A 1 in SERVERPROPERTY does not mean the feature runs. Here is how I line up the flag, the setting and the service in one query.
Asynchronous Statistics Updates: When They Help and When They Hurt
Evaluate asynchronous statistics updates against compile latency, data-change timing, and low-priority metadata locking in SQL Server.
Index Key Size Limits: 900 and 1,700 Bytes Explained
Check index key size against the 900-byte clustered and 1,700-byte nonclustered limits, then narrow keys without losing query semantics.
Intelligent Query Processing: Checking What Is On per Database
Check intelligent query processing by database compatibility level, scoped switches, and actual plan evidence before comparing servers.
SQL SERVER – Selecting Random n Rows from a Table
To select random-looking n Rows, I can sort by NEWID and use TOP. A developer wanted ten AdventureWorks Product rows.
How to Escape a Single Quote in SQL Server? – Interview Question of the Week #192
How do you escape a single quote in SQL Server? A college student asked me at a Bangalore user group, a few people laughed, and here is the simple answer.