Feeds:
Posts
Comments

Archive for July, 2010

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN

Posted in SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology on July 12, 2010 | 158 Comments »

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 best. You can win the [...]

Read Full Post »

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

Posted in Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 11, 2010 | 4 Comments »

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 well. “If you look carefully [...]

Read Full Post »

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

Posted in About Me, Pinal Dave, SQL, SQL Authority, SQL Milestone, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 10, 2010 | 15 Comments »

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 write a milestone post every [...]

Read Full Post »

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

Posted in About Me, MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, T SQL, Technology on July 9, 2010 | 20 Comments »

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 take this moment to thank [...]

Read Full Post »

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

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Joins, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 8, 2010 | 19 Comments »

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 usual answer is that it [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers