Feeds:
Posts
Comments

Archive for September, 2011

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

Posted in DMV, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on September 30, 2011 | 7 Comments »

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 created for the same. SELECT [...]

Read Full Post »

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

Posted in DMV, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on September 30, 2011 | 1 Comment »

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, f.FILE_ID, size DBSize, file_system_type, volume_mount_point, [...]

Read Full Post »

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

Posted in About Me, Best Practices, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on September 29, 2011 | 2 Comments »

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 so many spots that many [...]

Read Full Post »

SQL SERVER – Denali – DMV Enhancement – sys.dm_exec_query_stats – New Columns

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL DMV, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 28, 2011 | 2 Comments »

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 recently ran query, their execution [...]

Read Full Post »

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

Posted in Best Practices, Database, Pinal Dave, PostADay, SQL, SQL Authority, SQL Index, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology on September 28, 2011 | 2 Comments »

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 favorite tool of many when [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers