SQL Tips and Tricks Archives - Page 364 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Difference Between GETDATE and SYSDATETIME

June 10, 2010

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 – 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 – Generate Database Script for SQL Azure

June 4, 2010

Pinal Dave

SQL Tips and Tricks

SQL Azure, SQL Scripts, SQL Server

When talking about SQL Azure the common complaint I hear is that the script generated from stand-along SQL Server database is not compatible with SQL Azure. This was true for some time for sure, but not any more. If you have SQL Server 2008 R2 installed you can follow the guideline below to generate a script which is compatible with SQL Azure.

SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days

June 3, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Training

Today’s blog post is not technical as usual. Here, I present a real story, and I also invite you all to share your thoughts or opinions on this post. I am a professional SQL Server Trainer; I also do consultation in the area of the Performance Tuning and Query Optimizations.…

SQL SERVER – Stored Procedure and Transactions

June 2, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

I just overheard the following statement – “I do not use Transactions in SQL as I use Stored Procedure“. I just realized that there are so many misconceptions about this subject. Transactions has nothing to do with Stored Procedures. Let me demonstrate that with a simple example. USE tempdb GO…