Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Disadvantages (Problems) of Triggers

May 24, 2007

One of my team member asked me should I use triggers or stored procedure. Both of them has its usage and needs. I just basically told him few issues with triggers. This is small note about our discussion. Disadvantages(Problems) of Triggers It is easy to view table relationships , constraints,…

SQL SERVER – 2005 Retrieve Configuration of Server

May 24, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Few days ago I was asked what is our SQL Server’s configuration. I provided way more information then they requested. Run following script and it will provide all the information about SQL Server . SQL Server provides in detailed information if Advanced Options are turned on. It is very clear…

SQL SERVER – NorthWind Database or AdventureWorks Database – Samples Databases

May 23, 2007

Pinal Dave

SQL Tips and Tricks

SQL Download, SQL Sample Database, SQL Server, SQL Server Express

SQL Server 2005 does not install sample databases by default due to security reasons.I have received many questions regarding where is sample database in SQL Server 2005. One can install it afterward. AdventureWorks and AdvetureWorksDS are the new sample databases for SQL Server 2005, they can be download from here. Let us learn how to install NorthWind Database – samples databases.

SQL SERVER – 2005 Explanation Left Semi Join Showplan Operator and Other Operator

May 23, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins

I come across very interesting documentation about Joins, while I was researching about article about EXCEPT yesterday. There are few interesting kind of join operations exists when execution plan is displayed in text format. Left Semi Join Showplan Operator The Left Semi Join operator returns each row from the first…

SQLAuthority News – Funny One Liners – Humor

May 23, 2007

Pinal Dave

Personal

SQL Humor

Once in a while we should laugh and relax. Here are few of my favorite funny one liners which I often use in my presentations. Let us start-

Just read that 4,153,237 people got married last year, not to cause any trouble, but shouldn’t that be an even number?

SQLAuthority News – T-Shirts in Action

May 22, 2007

Pinal Dave

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

SQL T-Shirt

Thank you All for great response to SQLAuthority T-Shirts. I have ran out of all of them. Please put your request here. I will go over all of them soon and see what I can do. They are made from high quality fiber and very comfortable. Reference : Pinal Dave…

SQL SERVER – 2005 Comparison EXCEPT operator vs. NOT IN

May 22, 2007

Pinal Dave

SQL Tips and Tricks

SQL Index, SQL Operator, SQL Scripts, SQL Server

The EXCEPT operator returns all of the distinct rows from the query to the left of the EXCEPT operator when there are no matching rows in the right query. The EXCEPT operator is equivalent of the Left Anti Semi Join. EXCEPT operator works the same way NOT IN. EXCEPTS returns any distinct values from the query to the left of the EXCEPT operand that do not also return from the right query.