Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle

August 7, 2008

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

One of the JR. Developer asked me a day ago, does SQL Server has similar operation like MINUS clause in Oracle. Absolutely, EXCEPT clause in SQL Server is exactly similar to MINUS operation in Oracle. The EXCEPT query and MINUS query returns all rows in the first query that are…

SQL SERVER – Query to Find Column From All Tables of Database

August 6, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage, SQL Scripts, SQL Stored Procedure, SQL System Table

One question came up just a day ago while I was writing SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN. How many tables in database AdventureWorks have column name like ‘EmployeeID’? It was quite an interesting question and I thought if there…

SQL SERVER – 2005 – Get Field Name and Type of Database Table

August 5, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

In today’s article we will see question of one of reader Mohan and answer from expert Imran Mohammed. Imran thank you for answering question of Mohan. Question of Mohan: hi all, how can i get field name and type etc. in MS-SQL server 2005. is there any query available??? Answer…

SQLAuthority News – SQLAuthority Site With New Banner

August 4, 2008

Pinal Dave

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

I am glad to inform all the blog readers regarding new updated banner of this site. I would like to thank Ritesh, Sanjay and Rashmika who have spent their time to create the banner and gift to SQLAuthority. I really liked the new banner and I think it goes better…

SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN

August 3, 2008

Pinal Dave

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

SQL Joins, SQL Scripts

INTERSECT operator in SQL Server 2005 is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost same results as INNER JOIN clause many times. When using INTERSECT operator the number and the order of the columns must…

SQL SERVER – Effect of Order of Join In Query

August 2, 2008

Pinal Dave

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

SQL Index, SQL Joins, SQL Scripts, SQL Server

Let us try to understand this subject with example. We will use Adventurworks database for this purpose. Table which we will be using are HumanResources.Employee (290 rows), HumanResources.EmployeeDepartmentHistory (296 rows) and HumanResources.Department (16 rows). We will be running following two queries and observe the output. In the resultset the order…

SQL SERVER – 2008 – Get Current System Date Time

August 1, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server

How to get current system date time in SQL Server?