The RETURN statement ends a stored procedure at once and hands back one integer status code. This post builds a small demo, shows how to read the code, stops a procedure after a chosen step, and tests what RETURN does with NULL, text, open transactions and errors.
A Daily Streak in SQL: Finding the Longest Run of Consecutive Days
Find consecutive days with gaps and islands, rank the longest streak per user, and define a current streak using the right business date.
Why Query Store Actual Operation Mode is Not Same as Requested? – Interview Question of the Week #248
Question: Why Query Store Actual Operation Mode is Not Same as Requested? Query Regression (poor performing queries, once working great)
Session Wait Stats: Find the Query Behind a Wait Type
Session wait stats tell you which session produced a wait type, and the input buffer tells you which query that session ran. This post shows how to see who waits right now, how to read the wait history of each session, and how to join them to the query text. It also explains the THREADPOOL wait.
No Custom Security Extensions: SQL Server Upgrade Rule Failure
The No Custom Security Extensions rule failure stopped a SQL Server upgrade because Reporting Services had custom extensions configured. The fix that worked was to clear the extensions in RSReportServer.config, upgrade, and put them back afterward.
Parallel Plans: Reading Gather Streams and Repartition Streams
Read Gather Streams and other parallel exchanges, inspect rows per thread and spill evidence, and relate exchange waits to actual work.
Setup Error 1060: The Specified Service Does Not Exist During Upgrade
Setup error 1060 stopped an in-place upgrade from SQL Server 2008 R2 to 2014 right after the product key. The setup log asked for a ReportServer service that no longer existed. Removing the leftover SSRS fixed it.