Question: How to Determine Read Intensive and Write Intensive Tables in SQL Server?
Answer: The script is very simple and lets us see in the blog.
Create an Index Online in SQL Server: What ONLINE = ON Locks
To create an index online in SQL Server, add WITH (ONLINE = ON) to CREATE INDEX, and writers keep working while the index builds. This post compares a plain build with an online build on a three million row table, measures what each one blocks and what the online build costs, and shows where it still waits.
Autogrowth Settings: Check Every Database File in SQL Server
To check autogrowth settings for every database file, read sys.master_files and turn its raw page counts into sizes you can judge. This post builds a demo database with three differently set files, reports the current size, the next growth step and the room left, and fixes the weak settings. It also explains why the same query can return no rows.
SQL SERVER 2019 – Supports Compatibility Level from 2008 to 2019
Compatibility Level from 2008 to 2019 requires separating database migration from engine upgrade support. SQL Server 2019 supports levels 100 through 150.
How to Write INNER JOIN Which is Actually CROSS JOIN? – Interview Question of the Week #250
Question: How to Write INNER JOIN Which is Actually CROSS JOIN?
Experienced this question another day while working with a client.
ABORT_QUERY_EXECUTION: Stopping a Runaway Query With a Query Store Hint
ABORT_QUERY_EXECUTION is a SQL Server 2025 Query Store hint that makes one known bad query fail before it uses any CPU. This post sets the hint, shows the exact error the caller gets, lists and clears the hint, and covers the traps: exact text, SET options and queries already running.
Estimated Plan With a Temp Table: Why It Guesses One Row
An estimated plan for code that fills a temp table guesses one row for every read of that table. This post compares the estimated plan and the actual plan on SQL Server 2025, shows where the numbers split, and explains when to trust each one.