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
I was recently asked is there a single script which can provide all the necessary details about statistics for any database.
SQL SERVER – Pending IO request in SQL Server – DMV
I received following question: “How do we know how many pending IO requests are there for database files (.mdf, .ldf) individually?” Very interesting question and indeed answer is very interesting as well. Here is the quick script which I use to find the same. It has to be run in…
Read More