SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identif...

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

2/4/2012

I recently received email from one of my very close friend from CaliforniaHis question was very interestingHe wanted to know how many virtual processors are there available for SQL ServerHe already had script for SQL Server 2008 but was mainly looking for SQL Server 2000.

He made me go to my past[...].

Full story: Journey to SQL Authority with Pinal Dave

Similar articles

DotNetShoutout - Latest published stories

SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors 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 alre...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Demo Script – Keeping CPU Busy Recently face very interesting situation, during presentations at event, I was asked very famous questions: “My CPU is very high all the time, how can I reduce it?” This is very interestin...

DotNetShoutout - Latest published stories

Script Data in MS SQL Server 2008 Database Tables using Generate SQL Server Script Wizard Script Data in MS SQL Server 2008 Database Tables using Generate SQL Server Script Wizard MS SQL Server 2008 has new Generate Scripts option which enables sql programmers to script data in SQL S...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Download Logical Query Processing Poster Earlier this year, I had written article on SQL SERVER – Logical Query Processing Phases – Order of Statement Execution and I had asked one question to readers. I got very good response for this quest...

ASP.NET Weblogs

SQL Server Index Defrag Script Hiya. . . Some of you may have already seen this, but just in case you haven't; Some excellent SQL Server work from Michelle Ufford, also known as "SQL Fool". http://sqlfool.com/2009/06/index-defrag-s...

DotNetShoutout - Latest published stories

New LOGICAL functions in SQL Server Denali IFF Function If you are an old Access or Excel “developer” you know this one. This is not a function I have been missing before I read about it today. If you, like me, is so tired of writing CASE stat...

Comments on this article

Add your comment

Report

Latest from Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle Part 3 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value Before continuing this blog post – please read the two part of the SEQUENCE Puzzle here A Puzzle – Fun with SEQUENCE in SQ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle Part 2 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value Before continuing this blog post – please read the first part of the SEQUENCE Puzzle here A Puzzle – Fun with SEQUENCE in ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value Yesterday my friend Vinod Kumar wrote excellent blog post on SQL Server 2012: Using SEQUENCE. I personally enjoyed reading the c...

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117 During my 8 years of career, I have been many times interviewer and quite often interview candidate myself. If I am interviewer ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use th...

Journey to SQL Authority with Pinal Dave

SQL SERVER – SmallDateTime and Precision – A Continuous Confusion Some confusion never go away. Here is the one of the ancient one. Precision of the SmallDateTime is the one concept/confusion I...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Renaming Index – Index Naming Conventions If you are regular reader of this blog, you must be aware of that there are two kinds of blog posts 1) I share what I learn rece...

Journey to SQL Authority with Pinal Dave

SQL SERVER – New Look for CodePlexProject – Hosting for Open Source Software Codeplex is my favorite site. CodePlex is Microsoft’s free open source project hosting site. You can create projects to sh...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST Note: I have used SQL Server 2012 for this small fun experiment. Here is what we are going to do. We will run the script one at ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server 2012 – Guest Po Nakul Vachhrajani is a Technical Specialist and systems development professional with iGATE having a total IT experience of more...

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

Similar articles

DotNetShoutout - Latest published stories

Journey to SQL Authority with Pinal Dave

DotNetShoutout - Latest published stories

Journey to SQL Authority with Pinal Dave

ASP.NET Weblogs

DotNetShoutout - Latest published stories

Comments on this article

Latest from Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Sign In