The drive has free space, yet the file will not grow. Here is how to calculate the next autogrowth and test it against disk and MAXSIZE.
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.
One Default Row per Customer With a Filtered Unique Index
Two browser tabs, two default addresses. Here is how a filtered unique index keeps the rule in the database and how to switch defaults safely.
TempDB Operating System Error 3: Fix a Wrong TempDB Path
TempDB operating system error 3 means a tempdb file path cannot be found, for example after a typo in a move. This post reproduces the error safely, shows how error 3 differs from error 2 and lists the repair steps when the service will not start.
Performance Troubles – Function on Date Variable – SQL in Sixty Seconds #192
However, I have a really good reason to use that. Today we are going to discuss Performance Troubles – Function on Date Variable.
Performance: Between and Other Operators – SQL in Sixty Seconds #191
If we use BETWEEN what will be the impact of performance. Let us watch Performance: Between and Other Operators.
Most Used Database Files – SQL in Sixty Seconds #190
If a client has many databases, this script finds the most used database files. Here is my SQL in Sixty Seconds video on it.