Reproduce stale views after SELECT star and ALTER TABLE, find candidate definitions, refresh with sp_refreshview, and prevent the pattern.
SQL SERVER – The Basics of the SSIS Execute SQL Task – Notes from the Field #044
Many developers do not know SSIS can run SQL queries. Andy explains the basics of the SSIS Execute SQL Task in very simple words.
Live Execution Plan of a Running Query: SQL in Sixty Seconds #073
A live execution plan shows how far a query has gotten while it is still running. This post builds a slow query on SQL Server 2025, watches it through sys.dm_exec_query_profiles from a second window, and explains why rows divided by the estimate is a progress meter only when the estimate is right.
SQL SERVER – Live Plans for Long Running Queries
How do you see live plans for long running queries while they still run? SQL Server 2014 adds the DMV sys.dm_exec_query_profiles, and I show a simple test.
SQL SERVER – How to Know Cardinality of Executed Query?
Which estimator did SQL Server 2014 use? There are two ways to know the cardinality of executed query, starting with the execution plan properties.
JSON_CONTAINS in SQL Server 2025: Searching Inside JSON Arrays
JSON_CONTAINS checks whether a JSON document holds a value at a path, including inside an array. This post tests it on SQL Server 2025: the json data type it needs, numbers versus text, case, NULL results and the older OPENJSON way.
SQL SERVER – CTRL + R Shortcut Does Not Work in SSMS
After a fresh SQL Server 2014 install, CTRL + R no longer hid the results pane in SSMS. These keyboard option steps got my shortcut working again.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype – Part 2
Harsh improved the identity query from Part 1 so it also works when seed values or increment values are not 1. Here is his script.
SQL SERVER – Detecting Corruption with Suspect Pages Table – Notes from the Field #043
John Sterrett shows how the suspect pages table helps with detecting corruption, a tip worth learning even if your database has never been corrupted.
SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype
Mark Hickin improved my old query, so it now shows seed, increment and current identity column value along with the max value of the datatype.









