Dear Gail and Adi,

Here is my testing code on SQL Server 2005

set statistics io on

go

set statistics time on

go

DBCC DROPCLEANBUFFERS

--EXISTS for all columns

begin

if exists(select * from users)

print '*'

end

--EXISTS for 1

begin

if...

Dear Adi,

It was my notion that while I am using "SELECT *", it returns whole resultset. Naturally, taking more system resources rather "SELECT 1" because it returns only 1, though...

HI Imtiaz,

EXISTS is the fastest operator to check existence. It works on boolean value and whenever finds any TRUE it terminates. Also, it is not taking the NULL values.

HI Gail,

Want 2 know something.

"Also u may try to tune each query individually, like

use WHERE NOT EXISTS(SELECT 1 FROM D_Allocation D...

instead of WHERE NOT EXISTS(SELECT D.Label FROM D_Allocation D..

There's no...

UNION ALL is faster than UNION. So, if u allow any duplicate data, then use UNION ALL.

Also u may try to tune each query individually, like

use WHERE NOT EXISTS(SELECT...

OOhhh, forgotten to write, u can also run the CRETAE database script from a query window, specifying all the parameters.

1. Go to Object explorer

2. Right click on Database icon under right server.

3. A window ll appear, where u can specify new database name. datafile and log flle name...

Hi wesley,

Really a great help.

MAny thanks to u.

Hi Waslay,

can u give me some details about "EXCEPT"? How r u using it?

Many thanks to all of you. Its really greatful to me.

Because if I have near about 1 million of rows, its difficult to manage by Excel also. Then we need to axe the resultset and test the result snippets seperately...

Thanks GilaMonster for ur valuable advice.

One query again, is there any tool present for this type of testing?

Hi,

rbarryyoung's code is not working.

Gouthama's code is working, but it is not effective from the context because actually its trying to insert from two tables.

I guess, we need...

Is performance of SQL Server 2008 is better than 2005?

U may use export-import wizard or SSIS