Is your database Case Sensitive? Find its collation, then look it up in fn_helpcollations() and read the description. A quick answer from my Office Hours.
SQL SERVER – Denali – DMV – sys.dm_os_windows_info – Information about Operating System
A quick look at sys.dm_os_windows_info, the new Denali DMV that returns information about the Windows operating system, with an example query.
SQL SERVER – Denali – DMV – sys.dm_os_volume_stats – Information about operating system volume
The new Denali DMV sys.dm_os_volume_stats shows the operating system volume where each database file is stored, with its total and available space.
SQL SERVER – Denali – DMV Enhancement – sys.dm_exec_query_stats – New Columns
SQL Server Denali adds four new columns to sys.dm_exec_query_stats, like total_rows and last_rows, so you can see how many rows your queries returned.
SQL SERVER – Author’s Book is Available in India and USA
My book is now officially available in India and USA: Flipkart in India and Amazon in the USA. If you like this blog, I think you will like this book.
SQL SERVER – Find Details for Statistics of Whole Database
Need statistics of whole database in one view? My script uses DMVs instead of the deprecated sp_helpstats and shows each stat, column and last update.
SQL SERVER – Pending IO request in SQL Server – DMV
How many pending IO requests are there for each MDF and LDF file? My handy script joins sys.dm_io_pending_io_requests with virtual file stats.