SQL Archives - Page 355 of 519 - SQL Authority with Pinal Dave

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

June 6, 2010

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

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…

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…

SQL SERVER – Precision of SMALLDATETIME – A 1 Minute Precision

June 1, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

I am myself surprised that I am writing this post today. I am going to present one of the very known facts of SQL Server SMALLDATETIME datatype. Even though this is a very well-known datatype, many a time, I have seen developers getting confused with precision of the SMALLDATETIME datatype.…

SQLAuthority News – Monthly Roundup of Best SQL Posts

May 31, 2010

Pinal Dave

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

After receiving lots of requests from different readers for long time I have decided to write first monthly round up. If all of you like it I will continue writing the same every month. In fact, I really like the idea as I was able to go back and read…

SQLAuthority News – Guest Post – Performance Counters Gathering using Powershell

May 30, 2010

Pinal Dave

SQL

Powershell, SQL Utility

Laerte Junior has previously helped me personally to resolve the issue with Powershell installation on my computer. He did an awesome job to help. He has sent this another wonderful article regarding performance counter for readers of this blog. I really liked it and I expect all of you who are Powershell geeks, you will like the same as well.

SQL SERVER – DATE and TIME in SQL Server 2008

May 27, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts, SQL Server

I was thinking about DATE and TIME datatypes in SQL Server 2008. I earlier wrote about the about best practices of the same. Recently I had written one of the scripts written for SQL Server 2008 had to run on SQL Server 2005 (don’t ask me why!), I had to convert the DATE and TIME datatypes to DATETIME. Let me run a quick demo for the same.