Viewing 15 posts - 121 through 135 (of 659 total)
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...
February 14, 2009 at 10:48 am
Guys...what do u mean by that.
" this probloem deos not apply to sql 7 or later"
February 14, 2009 at 10:20 am
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...
February 14, 2009 at 9:07 am
ohh yeah i agree. its my mistake.
yeah i need to keep duplicates.
February 13, 2009 at 3:42 pm
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.
February 13, 2009 at 3:39 pm
ALTER VIEW [dbo].[Budget]
AS
Select *
from Budget_R
union all
select *
from Budget_PA
ACtually in my query vwBud and Budget are the views, you can check the view above.
February 13, 2009 at 2:43 pm
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...
February 13, 2009 at 1:55 pm
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...
February 13, 2009 at 11:17 am
what is the work around for this so the it never happens again.
February 13, 2009 at 8:36 am
This happens every day to the developers , not sure why?
where the problem might be? is it related to sql server or network problem
February 13, 2009 at 8:03 am
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"
February 13, 2009 at 7:47 am
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...
February 13, 2009 at 7:12 am
Chris
I dont see any diffrence in your query when compared to mine. Its just the same, then how would that improve performance?
February 13, 2009 at 6:30 am
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...
February 11, 2009 at 8:17 am
Viewing 15 posts - 121 through 135 (of 659 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy