In this blog post we will see three new DMVs which are introduced in Denali. The DMVs are very simple and there is not much to describe them. So here is the simple game. I will be asking a question back to you after seeing the result of the each of the DMV and you help me to complete this blog post.
SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()
In my recent Office Hours, I received a question on how to determine the case sensitivity of the database. Let us learn about how we can Detecting Database Case Sensitive Property using fn_helpcollations().
SQL SERVER – Denali – DMV – sys.dm_os_windows_info – Information about Operating System
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 MoreSQL SERVER – Denali – DMV – sys.dm_os_volume_stats – Information about operating system volume
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 MoreSQL SERVER – Denali – DMV Enhancement – sys.dm_exec_query_stats – New Columns
SQL Server version next Denali has lots of enhancements. Some of the enhancements are just game changing and overcomes needs of more coding to do the same thing. Similar function DMV is sys.dm_exec_query_stats. There are four new columns added to this DMV. I have often used this DMV to check…
Read MoreSQL SERVER – Author’s Book is Available in India and USA
I am feeling very good to write this short blog post. My book is now officially available on in India and USA. In India you can get it from Flipkart – In USA you can get it from Amazon – This book is just like this blog and contains all…
Read More
SQL SERVER – Find Details for Statistics of Whole Database – DMV – T-SQL Script
I was recently asked is there a single script which can provide all the necessary details about statistics for any database. This question made me write following script. I was initially planning to use sp_helpstats command, but I remembered that this is marked to be deprecated in future.