Here is the update...]

I combined 2 sql statements as 1 query in to second and got rid of DISTINCTm then i was able get same numer of records with 30min...

Guys...what do u mean by that.

" this probloem deos not apply to sql 7 or later"

i tred combining then but no use. How DISTINCT is eliminated if you are combining, i dont think so.

also when i tried combining them does the whole result set go...

ohh yeah i agree. its my mistake.

yeah i need to keep duplicates.

I think union all is always beter than union.

UNION ALL looks for and discards duplicate rows in the result set, whereas the UNION statement does not.

ACtually in my query vwBud and Budget are the views, you can check the view above.

is there a way i can get distinct value without using DISTINCT, i think this keyword makes query slow.

or let me put this way, how many ways i can run...

I cant change the requirement in the query and also we do have duplicates in that view, this is how we process. I am only looking for any way to...

what is the work around for this so the it never happens again.

This happens every day to the developers , not sure why?

where the problem might be? is it related to sql server or network problem

is there any clue why i get disconnectyed all of a sudden. and i get this error mesg

"A transport-level error has occurred when sending the request to the server"

Yes I would try to create a junk folder in each volume and just select all the files in the folder and try to move them to junk folder, if...

Chris

I dont see any diffrence in your query when compared to mine. Its just the same, then how would that improve performance?

yes i have sql litespeed

Is it possible to backup just 24 partitions (2yrs data) of a database every month and do a restore test just for those 24 partitions. Before backing up 24 partitions...