Msg 1842 appeared when a client’s data file reached the 16 TB limit, 2147483647 pages of 8 KB. Their SQL Agent job kept failing with a full filegroup message. The fix is to add another data file, or to free space or add a log file for the log.
How to Decode @@OPTIONS Value? – Interview Question of the Week #268
How to decode @@OPTIONS value? Session-level SET options live in the @@options variable, and this script turns that number into readable settings.
SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?
“I/O is frozen on database” and “I/O was resumed on database”? Did you check the air conditioner temperature? Let us learn about it in today’s blog post.
Scheduler ID Values in dm_os_schedulers: What the Big Numbers Mean
Scheduler ID values in dm_os_schedulers run from 0 up to a few thousand, and then jump past one million. This post groups the rows into user, dedicated admin connection and hidden schedulers, and shows the filter that keeps CPU scripts honest. It also shows why filtering on the number alone is fragile.
Proving a Tuning Change Worked With Before and After Numbers
Prove a tuning change with before and after numbers from Query Store for CPU, reads, duration, and comparable execution volume.
How to Do Case Insensitive Search? – Interview Question of the Week #267
Question: How to Do Case Insensitive Search?
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data.
SQL SERVER Management Studio – Rebuild All Indexes on Table
SSMS can open a Rebuild All dialog for table indexes. An e-commerce customer discovered this shortcut during my health check.