Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – Best SQLAuthority Posts of May

May 31, 2011

Personal, SQL, SQL Server, SQL Tips and Tricks

Month of May is always interesting and full of enthusiasm. Lots of good articles shared and lots of enthusiast communication on technology. This month we had 140 Character Cartoon Challenge Winner. We also had interesting conversation on what kind of lock WITH NOLOCK takes on objects as well. A quick…

SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)

May 30, 2011

Pinal Dave

SQL Puzzle

SQL Scripts, SQL Server

Earlier this weekend I have presented at Bangalore User Group on the subject of SQL Server Tips and Tricks. During the presentation I have asked a question to attendees. It was very interesting to see that I have received various different answer to my question. Here is the same puzzle for you and I would like to see what your answer to this question.

SQL Azure – SQL Azure Throttling and Decoding Reason Codes

May 29, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Azure

I was recently reading on the subject SQL Azure Throttling and Decoding Reason Codes and end up reading the article over here. What I really liked is the explanation of the subject with Graphic. I have never seen any better explanation of this subject. I really liked this diagram. However,…

SQL SERVER – A Quick Notes on SQL Azure

May 28, 2011

Pinal Dave

SQL Tips and Tricks

SQL Azure, SQL Server

I was recently attending a small meeting where I was asked if I can share few things to be considered when designing SQL Azure database. Today I am sharing the same notes over here.

SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server

May 27, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure, SQL Backup and Restore, SQL Server

SQL Server has a feature which copy database from one database to another database and it can be automated as well using SSIS.

SQL SERVER – Getting Columns Headers without Result Data – SET FMTONLY ON

May 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I was recently watching a videos online of TechEd 2011 USA (link) and I learned that SET FMTONLY ON is going to be replaced with enhanced DMVs in future versions of SQL Server. I really liked the new direction of the product. However, SET FMTONLY ON is really have done…

SQLAuthority News – Most Valuable Photographer – Vijay Raj

May 25, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Database

A good snapshot stops a moment from running away. ~Eudora Welty If I could tell the story in words, I wouldn’t need to lug around a camera. ~Lewis Hine Vijay Raj is a passionate Technology Evangelist and a Microsoft MVP. He recently took few snaps of my daughter. As soon…