Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN

July 12, 2010

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

I just received following “NOT FOR SALE” subscription of Microsoft Visual Studio 2010 Ultimate with MSDN. As a MVP, MCT I already have free subscription to MSDN and TechNet. I plan to give away this free subscription to someone who is need of the same or can use it the…

SQL SERVER – Parallelism – Row per Processor – Row per Thread – Thread 0

July 11, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Earlier I had posted article answering question. “When SQL Server executes any query on multiple processors, do all processors process equal numbers of rows?” Read the answer over SQL SERVER – Parallelism – Row per Processor – Row per Thread. In the same article, I had asked back to readers as…

SQLAuthority News – Milestone – 1400th Post and Why do I blog

July 10, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

I am very glad today that I have reached milestone of 1400th post. I was looking back to my journey which I started on Nov 1, 2006 and I feel that it has been long way. I have noticed a lot of changes in myself too. Earlier, I used to…

SQLAuthority News – I am a MVP and I Love SQL Server

July 9, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

MVP, SQL User Group

I am very glad that I received this prestigious award for the third time in a row. I am very thankful to Microsoft for introducing this wonderful technology of SQL Server. I enjoy getting involved with the community, which also helps in my self-improvement as well. I would like to…

SQL SERVER – The Self Join – Inner Join and Outer Join

July 8, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The…

SQL SERVER – Upper Case Shortcut SQL Server Management Studio

July 7, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

Few days ago, I received code which is very similar to code shown below. select * from Sales.SalesOrderDetail where ProductID > 777 I am not the guy who go crazy for formatting but I do appreciate proper coding. I like if the code was formatted like below. SELECT * FROM…

SQLAuthority News – I am Microsoft Certified Trainer (MCT)

July 6, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Training

I am a Microsoft Certified Trainer and I am very much proud of it. Because I am a MCT, I have the support of great community leaders and trainers who help me constantly to improve in what I do. I have many Microsoft Certifications and I constantly try to take…