Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Follow up on Beginning NuoDB – Who will Benefit and How to Start – Part 2

August 1, 2012

Earlier I blogged about Beginning NuoDB – Who will Benefit and How to Start, I received a few follow up questions about it so I decided to write a short article as a follow up. One of the questions I received was why I started with this product. Well, the…

SQL SERVER – Beginning NuoDB – Who will Benefit and How to Start

July 31, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB, SQL Documentation, SQL Download

I finally got some time to play around with the beta 7 release of NuoDB that I downloaded a few weeks ago. Personally I don’t think NuoDB yet gives downloaders enough information on how to get started so I decided to tackle that here myself. Before I get into the…

SQLAuthority News – A Year Older and 3 SQL Server Books and 3 Video Courses – 33

July 30, 2012

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Today is my birthday. I am 33 today. 33 is an interesting number. There are two 3’s in this number. Curiously, I looked it up in Wikipedia and found out that there is plenty of information about this number. Let me quote a few statements from Wikipedia here. “33 is the largest positive…

SQL SERVER – Services Pack 2 for SQL Server 2008 R2 – Microsoft SQL Server 2008 R2 Service Pack 2

July 29, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Service Pack

Service packs are very critical and important. In the industry I have seen many people waiting for the first service pack to arrive before moving to opting the product. I often see it as a good practice because there are some unknown bugs or missed enhancements in original product which are…

SQL SERVER – Difference Between ORIGINAL_LOGIN() and SUSER_SNAME()

July 28, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Today let us start today’s blog post with a simple start question which I was asked by reader of my latest book SQL Server Interview Questions and Answers. Indeed a good question warrants a good answer with a script associated with the same. Question: What is the difference between ORIGINAL_LOGIN() and…

SQL SERVER – Query to Get Unique Distinct Data Based on Condition – Eliminate Duplicate Data from Resultset

July 27, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Seems like in T-SQL world the issue with Duplicate Records never an old topic. Today lets quickly go over another question which made it to my mailbox 3 times this week. Question: How do I display only unique records from my table? The natural reaction will be to suggest DISTINCT…

SQL SERVER – Answer – How to Convert Hex to Decimal or INT

July 26, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Has it ever happened to you that you say something but forget to follow up due to any reason? It usually does not happen to me as I try to remember everything in my task list but there is always an exception. Last year I asked a question regarding about…