All Articles - SQL Authority with Pinal Dave

SQLAuthority News – Author Visit – SQL Server 2008 R2 Launch

June 14, 2010

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

June 11, 2010 was a wonderful day because I attended the very first SQL Server 2008 R2 Launch event held by Microsoft at Mumbai. I traveled to Mumbai from my home town, Ahmedabad. The event was located at one of the best hotels in Mumbai,”The Leela”. SQL Server R2 Launch…

SQL SERVER – What is Denali?

June 13, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I see following question quite common on Twitter or in my email box. “What is Denali?” Denali is code name of SQL Server 2011. Here is the list of the code name of other versions of SQL Server. In 1988, Microsoft released its first version of SQL Server. It was…

SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE

June 12, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

Earlier I wrote blog post SQL SERVER – Difference Between GETDATE and SYSDATETIME which inspired me to write SQL SERVER – Difference Between DATETIME and DATETIME2. Now earlier two blog post inspired me to write this blog post (and 4 emails and 3 reads from readers). I previously populated DATETIME…

SQL SERVER – Difference Between DATETIME and DATETIME2

June 11, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

Yesterday I have written a very quick blog post on SQL SERVER – Difference Between GETDATE and SYSDATETIME and I got tremendous response for the same. I suggest you read that blog post before continuing with this blog post today. I had asked people to honestly take part and share…

SQL SERVER – Difference Between GETDATE and SYSDATETIME

June 10, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

Sometime something so simple skips our mind. I never knew the difference between GETDATE and SYSDATETIME. I just ran simple query as following and realized the difference. SELECT GETDATE() fn_GetDate, SYSDATETIME() fn_SysDateTime In case of GETDATE the precision is till miliseconds and in case of SYSDATETIME the precision is till…

SQL SERVER – Fastest Way to Restore Database

June 9, 2010

Pinal Dave

SQL Performance

SQL Restore, SQL Server

A few days ago, I received following email from blog reader where the question was about the fastest way to restore database.

SQL SERVER – Merge Operations – Insert, Update, Delete in Single Execution

June 8, 2010

Pinal Dave

SQL Tips and Tricks

SQL Joins, SQL Scripts, SQL Server

This blog post is written in response to T-SQL Tuesday hosted by Jorge Segarra. I have been very active using these Merge operations in my development. However, I have found out from my consulting work and friends that these amazing operations are not utilized by them most of the time. Here is my attempt to bring the necessity of using the Merge Operation to surface one more time.

SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2

June 7, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

This blog post is part 2 of the earlier written article SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best by Paulo R. Pereira. Paulo has left excellent comment to earlier article once again proving the point that SQL Server Engine is smart…

SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best

June 6, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

This is followup post of my earlier article SQL SERVER – Convert IN to EXISTS – Performance Talk, after reading all the comments I have received I felt that I could write more on the same subject to clear few things out. First let us run following four queries, all…

SQL SERVER – Convert IN to EXISTS – Performance Talk

June 5, 2010

Pinal Dave

SQL Performance

SQL Scripts, SQL Server

In recent training one of the attendee asked if I can show a simple method to convert IN clause to EXISTS clause so it impacts performance. Here is the simple example.