The Login Types

The External Database Principals

The Extra Columns

Finding SQL Logins

DMV’s for the Beginner

I give performance presentations at many different events to all levels of SQL Server professionals. Over time I’ve noticed that some DBAs and developers have never looked at the...
The...

Find Top 5 expensive Queries from a Write IO perspective

Top 5 expensive Queries from a Write IO perspective

Find Top 5 expensive Queries from a Read IO perspective

The below written query helps us find the most expensive queries from a read IO perspective. The DMV that we have used in this script is sys.dm_exec_query_stats and the function that we have used is sys.dm_exec_sql_text.