To inspect Open Transactions for Session nesting on my connection, I use @@TRANCOUNT. It does not directly inspect another session.
SQL SERVER – Simple Recovery Model and Restrictions
Simple Recovery changes recovery options before it changes a performance diagnosis. I choose it from the agreed recovery requirements.
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.
FORCE_DEFAULT_CARDINALITY_ESTIMATION: A Simple Explanation
FORCE_DEFAULT_CARDINALITY_ESTIMATION is a query hint that gives one query the default cardinality estimator, even when the database is set to the legacy one. This post builds a demo table, compares the row estimates of both models with the real count and shows how to prove which model a plan used. It also names the opposite hint and the permission difference.
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.
SQL SERVER – Delete Statement and Index Usage
An index can help a DELETE statement locate rows to remove. A customer asked whether indexes benefit modifications alongside SELECT queries.
Where are SQL Jobs Stored? – Interview Question of the Week #293
Question: Where is SQL Jobs Stored?
Answer: In MSDB Database in dbo.sysjobs table. Let us learn about it in today’s blog post.