Viewing 15 posts - 33,001 through 33,015 (of 59,102 total)
trstringer (8/4/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 4, 2011 at 10:48 pm
thundersplash845 (8/4/2011)
Hmmmm... i just want to print the output in a text file 🙁 ....any alternative way u could suggest??
BWAA-HAA!!! Understood and very much appreciated. 🙂
SQL Server (T-SQL, really) isn't...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 4, 2011 at 10:35 pm
I don't believe you're going to be able to do much with that view. The query is too big and the reason why it has a DISTINCT in it...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 10:21 pm
I've found that one of the biggest reasons why people originate or move databases to the cloud is so that you don't have to have a lot of hardware locally....
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 10:13 pm
rjdpa2 (8/3/2011)
thanks!! that helps a lot but it also requires me to change the compatibility level of the DB, which i can't really do. is there another alternative?
What compatibility level...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 10:01 pm
danymorales17 (8/3/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 9:53 pm
pwalter83 (8/3/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 9:38 pm
daveriya (8/3/2011)
hii cant put my all execution plan,all oher field is 0%,except table spool and key lookup.
i dont understand how to increase my time
daveriya,
Without any additional information, the best suggestion...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 9:18 pm
There is no answer to this question that will satiate the primordial fears of all the DBA's in the world. With that in mind, what will you allow? ...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 9:10 pm
WayneS (8/3/2011)
LutzM (8/2/2011)
Changing subject:@Wayne:
Did you notice you have a sibling? (at least in terms of your avatar...) 😀
For a moment I was confused (more than usual)
Interesting. But since I actually...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 7:23 pm
Pagan DBA (8/3/2011)
The reason I joined this forum - to learn.
Not sure it will help at this point, but I recognized that. Looking back at what I posted,...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 6:49 pm
Here's the "Full Monty" for this problem using the very high performance Quirky Update method. I've included not only the new safety check for the method (thank you Paul...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 9:38 am
Ninja's_RGR'us (8/3/2011)
Jeff Moden (8/3/2011)
Flexdog (8/2/2011)
Hi Ninja,I wonder if the conversion is outside of the aggregate, would perf improves?
'avg'=sum(Value)/cast(COUNT(*) as float)
...ignoring sum() int overflow scenario.
On my machine, that runs about 3...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 6:33 am
Ninja's_RGR'us (8/2/2011)
Jeff Moden (8/2/2011)[hr
I haven't actually done a performance test but I know enough about machine language at the cycle level to say that it will always take fewer cycles...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 12:07 am
Flexdog (8/2/2011)
Hi Ninja,I wonder if the conversion is outside of the aggregate, would perf improves?
'avg'=sum(Value)/cast(COUNT(*) as float)
...ignoring sum() int overflow scenario.
On my machine, that runs about 3 times faster on...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2011 at 12:03 am
Viewing 15 posts - 33,001 through 33,015 (of 59,102 total)