Flushing with sys.sp_flush_log hardens preceding committed delayed-durable transactions in the current database. I use delayed durability only with an accepted tradeoff.
Unquoted Procedure Parameters: Are Single Quotes Optional?
Unquoted procedure parameters work in SQL Server when the value is one plain word. This post builds a small procedure and tests which values fail without single quotes. It also shows how NULL, DEFAULT and numbers change the value.
Custom Query Shortcuts in SSMS: Run Your Own Procedure
Custom query shortcuts in SSMS run a stored procedure of your own on the text you have selected. This post writes a small procedure that explains any session, tests it the way the shortcut calls it, assigns it to a free key, and explains which keys you can use.
Error 8632: Internal Error, Expression Services Limit Reached
Error 8632 says an expression services limit has been reached. It appeared in a few stored procedures after a SQL Server upgrade. Recreating the procedures, and the nested ones, fixed it without a restart.
SQL SERVER – Finding Open Transactions for Session – @@TRANCOUNT
To inspect Open Transactions for Session nesting on my connection, I use @@TRANCOUNT. It does not directly inspect another session.
Dropping Temp Table in Stored Procedure – SQL in Sixty Seconds #124
Is dropping temp table in stored procedure code really needed? In this SQL in Sixty Seconds video, I compare two procedures to show what happens.
What is Temp Stored Procedures? – Interview Question of the Week #294
Temp stored procedures are the SPthat are created with the help of the # at the beginning of the name and only available until the SQL Server restarts.