T-SQL query to find deadlocks in SQL Server
Here is the quick query to find deadlocks which I have used for long time. This statement is based on the SYS.DM_EXEC_REQUESTS dynamic management view.
Performance
Collecting Poor Performing Queries And Storing Them For Analysis (Using Extended Events)
Simple step by step illustration for collecting poor performing queries or batches and store them for further analysis in SQL Server using Extended Events.
Collect Poor Performing Queries And Store Them (Using Profiler)
How to collect poor performing queries or batches and store them in a database table for further analysis in SQL Server using MSSQL Profiler?
Union vs Union All – Usage and Performance In SQL Server
Difference between union and union all. Performance comparison of union vs union all and identifying the best one to use and the scenarios to use them.
Finding Deadlocks Using Extended Events In SQL Server
Finding the deadlocks and blocked processes using extended events In SQL Server. Collecting deadlocks using extended events
How To Find Long Running Stored Procedures In SQL Server?
How to find long running stored procedures In SQL Server? Step by step illustration to find slow running SQL Server stored procedure.
What Are Extended Events In SQL Server?
What Are Extended Events In SQL Server? What are the advantages of extended events over profiler? How to use SQL Server XEvents?
SQL Server: Does WITH (NOLOCK) increase performance?
Does with (nolock) increase performance in T-SQL Queries? Can you increase the performance of SQL queries by adding WITH NOLOCK? Lets find out.
count(*) or count (1) or count(”) Which is better in SQL server?
SQL Server: count(*) or count (1) or count(”) Which is better? Let’s do an experiment to find the better option among the count.
Does Index Improve SQL Server Query Performance?
Does Index Improve SQL Server Query Performance. Yes Index improves the SQL Server query performance to a large extend. Let’s do an experiment.
Installing and Using YSlow for Code Review
Detailed step by step instructions with pictures on Installing and Using YSlow on Firefox and Chrome browsers for Code Review.
Clear Cache and Buffer of Stored Procedure in SQL Server
Professional way to clear cache and buffer of SQL Server Stored Procedure for performance testing without restarting the server or recreating the procedure.
SP_WHO and SP_WHO2
SP_WHO and SP_WHO2 – Brief description about Microsoft system stored procedures SP_WHO and SP_WHO2. SP_WHO vs SP_WHO2 which one to use when.
ASP.NET Caching with SqlCacheDependency
ASP.NET caching technology has various technique for specific caching requirements. SqlCacheDependency class is one among them.
Using isnull in where clause is expensive in SQL Server
Using isnull in where clause is expensive in SQL Server. How to avoid useing isnull? Simple way to use case instead of isnull in where clause.