In this blog, we would see the current setting of instant file initialization and how to make the modification. Let us learn about it today.
Table Variable Deferred Compilation: Before and After SQL Server 2019
Compare table variable deferred compilation at compatibility levels 140 and 150, then decide when a temporary table gives better estimates.
SQL SERVER – Performance and Recompiling Query – Summary
I have been having with many of the readers after reading the latest blog post series on Performance and Recompiling Query.
SQL SERVER – DATABASE SCOPED CONFIGURATION – PARAMETER SNIFFING
My client had hired me after reading my recent series on Parameter Sniffing. Today, we will discuss Database Scoped Configuration – Parameter Sniffing.
Lightweight Query Profiling: Live Progress Without the Old Overhead
Use lightweight query profiling to inspect live operator rows and in-flight plans, while avoiding misleading progress percentages.
SQL SERVER – SET NOCOUNT – Impact on Stored Procedure Performance
Recently, I solved a huge performance problem for one of my clients by just adding the SET NOCOUNT inside the stored procedure.
SQL SERVER – Clone Database Using DBCC CLONEDATABASE
The client had a requirement that we can’t run any query SELECT queries on the production system. Clone Database Using DBCC CLONEDATABASE.