Feeds:
Posts
Comments

Archive for the ‘SQL DMV’ Category

SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors

Posted in PostADay, SQL, SQL Authority, SQL DMV, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on February 4, 2012 | 2 Comments »

I recently received email from one of my very close friend from California. His question was very interesting. He wanted to know how many virtual processors are there available for SQL Server. He already had script for SQL Server 2008 but was mainly looking for SQL Server 2000. He made me go to my past. [...]

Read Full Post »

SQL SERVER – DVM sys.dm_os_sys_info Column Name Changed in SQL Server 2012

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL DMV, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on November 25, 2011 | 3 Comments »

Have you ever faced situation where something does not work? When you try to fix it ‑ you enjoy fixing it and started to appreciate the breaking changes. Well, this is exactly I felt yesterday. Before I begin my story, I want to candidly state that I do not encourage anybody to use * in [...]

Read Full Post »

SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL DMV, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 16, 2011 | 5 Comments »

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 [...]

Read Full Post »

SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL DMV, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on October 6, 2011 | 4 Comments »

In my recent Office Hours, I received a question on how to determine the case sensitivity of the database. The quick answer to this is to identify the collation of the database and check the properties of the collation. I have previously written how one can identify database collation. Once you have figured out the [...]

Read Full Post »

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

Posted in PostADay, SQL, SQL Authority, SQL DMV, 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 »

Older Posts »