Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – 2005 – Features Comparison Chart

July 11, 2007

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

This post in the response to all the readers who have asked what are the differences between SQL Server 2005 editions. The reason I have never posted article about this as Microsoft has wonderful comparison chart on Microsoft SQL Server web site. This chart explains the difference between features of…

SQL SERVER – 2008 – Scheduled Launch at an Event in Los Angeles on Feb. 27, 2008

July 11, 2007

Pinal Dave

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

Database, SQL Scripts

SQL SERVER 2008 will be launched at an Event in Los Angeles on Feb. 27, 2008. “In anticipation for the most significant Microsoft enterprise event in the next year, Turner announced that Windows Server® 2008, Visual Studio® 2008 and Microsoft SQL Server™ 2008 will launch together at an event in…

SQL SERVER – Count Duplicate Records – Rows

July 11, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Duplicate Records, SQL Scripts

In my previous article SQL SERVER – Delete Duplicate Records – Rows, we have seen how we can delete all the duplicate records in one simple query. In this article we will see how to find count of all the duplicate records in the table. Following query demonstrates usage of…

SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days

July 10, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts, SQL Stored Procedure

I usually run following script to check if any stored procedure was deployed on live server without proper authorization in last 7 days. If SQL Server suddenly start behaving in un-expectable behavior and if stored procedure were changed recently, following script can be used to check recently modified stored procedure.…

SQL SERVER – Result of EXP (Exponential) to the POWER of PI – Functions Explained

July 9, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

SQL Server can do some intense Mathematical calculations. Following are three very basic and very necessary functions. All the three function does not need explanation. I will not introduce their definition but will demonstrate the usage of function. SELECT PI() GO SELECT POWER(2,5) GO SELECT POWER(8,-2) GO SELECT EXP(99) GO…

SQL SERVER – FIX : ERROR Msg 244, Level 16, State 1 – FIX : ERROR Msg 245, Level 16, State 1

July 8, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Function, SQL Scripts

FIX : ERROR Msg 244, Level 16, State 1, Line 1 FIX : ERROR Msg 245, Level 16, State 1, Line 1 This error can happen due to conversion of one data type to incompatible datatype. Few examples are: VARCHAR to INT, INT to TINYINT etc. I have spotted this…

SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Generic Quotes

July 8, 2007

Pinal Dave

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

Database, SQL Humor

Few days ago, in meeting I was forced to answer one of the question from non-programmer was considered as funny quotes for long time. “Yes it is latest year 2005 version of SQL Server – still it will not play your flash movie” — Pinal Dave (SQLAuthority.com) Many of following…