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. [...]
Archive for the ‘SQL Server’ 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 | 1 Comment »
SQLAuthority News – An Incredible Successful SQL Saturday #116 Event – First SQL Saturday in India
Posted in PostADay, SQL, SQL Authority, SQL PASS, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology on February 3, 2012 | 4 Comments »
We have recently wrapped up our most recent event, SQL Saturday #116, and I am I am sure I am not alone in reporting that it was a huge success! We had a full crowd – every seat taken, plus standing-room-only in the back. We also had a lot of good feedback and the crowd [...]
SQL SERVER – An Inspiring Personal Story – Movie from The Book – Video Course – SQL Server Questions and Answers – Pluralsight
Posted in About Me, Pinal Dave, PostADay, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Query, SQL Server, SQL Tips and Tricks, SQL Training, SQLAuthority News, SQLServer, T SQL, Technology on February 2, 2012 | 6 Comments »
Nov 3, 2011 – Visit to Grandma When our SQL Server Interview Questions and Answers book got published I ran to my grandma with a copy of the book for her blessings. Well, just like every grandma, she loves me, her grandson, unconditionally. She is not into the technology domain (obviously), but she loved the book. She read the [...]
SQL SERVER – What is Slowly Changing Dimension – Quiz – Puzzle – 31 of 31
Posted in Pinal Dave, PostADay, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on February 1, 2012 | Leave a Comment »
Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to [...]
SQL SERVER – Advantages of Partitioning – Quiz – Puzzle – 30 of 31
Posted in Pinal Dave, PostADay, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on January 31, 2012 | Leave a Comment »
Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to [...]
free community tool
About Pinal Dave
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2000 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of three SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.
Follow @pinaldave Send +Pinal Dave an email at pinal@sqlauthority.com
-
Blog Stats
- 36,747,376 (36 Million+)
Next Office Hours
Books I Authored
SQLAuthority Links
Subscribe to Newsletter
My Homepage
Windows Live Blog
--------------------
Top Downloads
PDF Downloads
Script Downloads
Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 2
All Scripts - 3
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
> SQL Interview Q & A <
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
About Nupur Dave
Nupur Dave loves technology simply because it makes life more convenient. She is devoted to technology because it touches our heart makes our daily lives easier. Among the many technological programs she uses and embraces Windows Live most because she can do lots of things with ease – from photo management to movies; business emails to personal social media connections.
Disclaimer
This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet/ BOL. My employer do not endorse any tools, applications, books, or concepts mentioned on the blog. I have documented my personal experience on this blog.
Categories
- About Me (145)
- Best Practices (143)
- Business Intelligence (36)
- CodeProject (10)
- Data Warehousing (49)
- Database (321)
- DBA (137)
- DMV (13)
- Joes 2 Pros (47)
- MVP (147)
- PASS (14)
- Readers Contribution (114)
- Readers Question (126)
- SharePoint (7)
- Software Development (69)
- SQL Add-On (99)
- SQL Azure (15)
- SQL Backup and Restore (79)
- SQL BOL (11)
- SQL Coding Standards (21)
- SQL Constraint and Keys (57)
- SQL Cursor (28)
- SQL Data Storage (59)
- SQL DateTime (47)
- SQL DMV (23)
- SQL Documentation (299)
- SQL Download (310)
- SQL Error Messages (161)
- SQL Function (161)
- SQL Humor (29)
- SQL in Sixty Seconds (1)
- SQL Index (155)
- SQL Interview Questions and Answers (139)
- SQL Joins (78)
- SQL Milestone (25)
- SQL Optimization (152)
- SQL PASS (20)
- SQL Performance (340)
- SQL Puzzle (95)
- SQL Security (127)
- SQL Server DBCC (42)
- SQL Server Management Studio (44)
- SQL Service Pack (13)
- SQL Stored Procedure (116)
- SQL String (26)
- SQL System Table (61)
- SQL Trigger (24)
- SQL User Group (57)
- SQL Utility (153)
- SQL View (26)
- SQL Wait Stats (41)
- SQL Wait Types (42)
- SQL White Papers (67)
- SQL XML (12)
- SQLAuthority (632)
- SQL Training (19)
- SQLAuthority Author Visit (141)
- SQLAuthority Book Review (39)
- SQLAuthority News (577)
- SQLAuthority Website Review (42)
- SQLServer (227)
- Tech (1588)
- Pinal Dave (1575)
- SQL Scripts (861)
- Technology (2033)
- PostADay (454)
- SQL (2033)
- SQL Authority (2033)
- SQL Query (2032)
- SQL Server (2033)
- SQL Tips and Tricks (2033)
- T SQL (2033)
- Video (5)
Top 3 Commenters









