A very popular question I often receive during my Performance Health Check is about how to use stored procedures in SELECT Statement.
SQL SERVER – TempDB Error: CREATE FILE encountered operating system error 3
Let us fix error TempDB error: CREATE FILE encountered operating system error 3 (The system cannot find the path specified.)
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.
Data Compression for Performance – SQL in Sixty Seconds #188
Earlier I wrote a blog post about how Data Compression for Performance can help improve the efficiency of SQL Server.
SQL SERVER – Script to Estimate Compression
I had implemented Data Compression at my client Performance Health Check. Let us discuss how we can estimate compression.
SQL SERVER – Is Query from Cache? Execution Plan Property
Well, of course, there is an easy way to know this and that is Execution plan property. Is there any way to know if the executed query is from cache or not?
SQL SERVER – List Databases Where User Has DB Access
A client asked how to see which databases a user can reach. The HAS_DBACCESS function makes it easy to list databases where the user has DB access.