Question: How to Get Volume Mount Point for SQL Server Files?
Answer: I was asked this question by my client during the recent Health Check.
Nested Transactions are Myth – SQL in Sixty Seconds #125
Many sent me an email that they want to know more about the nested transactions. Let us learn about them in today’s blog post.
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.
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.
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 – Running Log Backup While Taking Full Backup
A full backup and log backup can overlap on one SQL Server database. A customer noticed both during a slowdown.