June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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 – 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