May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Introduction to sys.dm_exec_query_optimizer_info

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, SQL System Table

Many times when I am just bored I surf Book On Line for SQL Server 2005. Almost all the time I find something new which makes me believe that I have lot to learn and there are so many things I am not aware of. Today I found system catalog view sys.dm_exec_query_optimizer_info. I just enjoyed reading about it and now I will share this with you.

Read More

SQL SERVER – 2005 – Display Fragmentation Information of Data and Indexes of Database Table

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL DMV, SQL Index, SQL Scripts, SQL Server DBCC, SQL System Table
One of my friend involved with large business of medical transcript invited me for SQL Server improvement talk last weekend. I had great time talking with group of DBA and developers. One of the topic which was discussed was how to find out Fragmentation Information for any table in one…
Read More

SQL SERVER – 2005 – Last Ran Query – Recently Ran Query

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL System Table
How many times we have wondered what were the last few queries ran on SQL Server? Following quick script demonstrates last ran query along with the time it was executed on SQL Server 2005. SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query] FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest…
Read More