Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Denali – DMV – sys.dm_os_windows_info – Information about Operating System

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL DMV
One more quick introduction to DMV for Denali. Following DMV provides information about Windows Operating System. Here is the quick example of the same. This DMV returns information about the operating system volume (directory) on which the specified databases and files are stored. Here is the quick example I have…
Read More

SQL SERVER – Denali – DMV – sys.dm_os_volume_stats – Information about operating system volume

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL DMV
SQL Server Denali has many new interesting feature – one of the interesting feature is New DMVs. This DMV returns information about the operating system volume (directory) on which the specified databases and files are stored. Here is the quick example I have created for the same. SELECT DB_NAME(f.database_id) DatabaseName,…
Read More

SQLAuthority News – Various Ways to Stay in Touch with SQLAuthority.com – Best Practices

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices
Social Media is growing and quite commonly we reach to the point where we have confusion about the various aspects of the same. I have written a previous article on this subject SQLAuthority News – Social Media Confusion – Twitter, FaceBook, LinkedIn and Me. I am present and active at…
Read More

SQLAuthority News – Tomorrow Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, Database, SQL Index
Today in few hours I am going to present on my very favorite subject of performance tuning. You can read more about this sessions over here. This presentation is based on the famous book ‘The Art of War’ written in sixth century BC by Sun Tzu. Index is usually a…
Read More

SQLAuthority News – Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, Database, SQL Index
Performance Tuning has been my favorite subject always. I love this subject the most. I personally have enjoyed every aspect of performance tuning. Quite often I have seen that when it is about performance, people end up talking about Indexes. Index for sure can help performance, but it is like…
Read More