What is Azure SQL? In the recent past, Microsoft introduced Azure SQL, bringing all the SQL Server products in one suite. Microsoft is grouping all

Case study #16 Here is another recent SQL Server performance tuning report. The stored procedure below was one of the most called on the client’s

Real sample #15 Here is another recent SQL Server performance tuning report. Improvements achieved CPU from 125 to 18 Reads from 21,737  to 18,411 Duration

Today I am sharing another MS SQL Performance tuning report from recent tuning. Improvements after Red9 SQL Server tuning  After making a couple of small

Category: Performance Item: Objects created with SET Options What are the set options? SQL Server backward compatibility SET options allow legacy T-SQL code to run

Category: Performance Item: SPs with RECOMPILE What is the RECOMPILE option? The compilation is the process when a query execution plan of a stored procedure

Category: Performance Item: Page life expectancy What is the SQL Page Life Expectancy (PLE)? PLE is the expected time (in seconds) that a data file page read

Category: Performance Item: Implicit Conversion What is SQL Server implicit conversion? It occurs when SQL Server needs to convert the value of variables or columns to another

What is Deadlock in SQL Server? A deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set

Why should you care about them? You may be wasting your precious resources on unused services. It would be best if you prioritize your more

Category: Performance Item: Trigger usage What are SQL Server triggers? They are a particular type of stored procedure that automatically runs when an event occurs in the

What are orphaned datafiles? Orphaned database files are files not associated with any attached database (live database). Sometimes when you drop a database from a