Capture rows with INSERT EXEC, match result columns, understand nested and multiple-result limits, and choose supported alternatives.
Session State in SQL Server With Memory-Optimized Tables
Store transient session state in memory-optimized SQL Server tables with native reads and writes, expiry checks, and clear durability rules.
Using Stored Procedure in SELECT – SQL in Sixty Seconds #193
Today we are going to learn about how Using Stored Procedure in SELECT. However, the easiest method to run the stored procedure.
SQL SERVER – Capturing Stored Procedure Results with a Matching INSERT EXEC Table
A stored procedure is not normally a table expression in a SELECT Statement. The question concerned rows from uspGetManagerEmployees.
Estimate Compression Savings for Every Table in a Database
To estimate compression savings for every table, loop over the database and call sp_estimate_data_compression_savings with ROW and PAGE. This post ranks tables by space saved and checks one estimate against a real rebuild.
ZIP Codes Stored as int: Lost Zeros and How to Repair Them
An int column turns 01234 into 1234 and never gives the zero back. Here is how to fix the column, and how to repair old rows without guessing.
Last Used Stored Procedure in SQL Server: When Did It Last Run?
To find the last used stored procedure, read last_execution_time from sys.dm_exec_procedure_stats. This post tests it on demo procedures, shows why a NULL does not mean never, and adds Query Store for a longer memory.







