Viewing 15 posts - 2,731 through 2,745 (of 6,486 total)
thuybui (6/27/2008)
I received this error while running the query?Msg 156, Level 15, State 1, Line 17
Incorrect syntax near the keyword 'OVER'.
Any idea?
Are you running this in 2005 "native"? meaning...
June 27, 2008 at 10:43 am
rbarryyoung (6/27/2008)
GilaMonster (6/27/2008)
Jeff Moden (6/27/2008)
All ya gotta do now is store all of the data in a single monster EAV and you'd have it made. 😛
<Shudder>
Fortunatly I don't think anyone...
June 27, 2008 at 10:30 am
Steve Jones - Editor (6/26/2008)
June 27, 2008 at 9:48 am
At a previous job, we used to have the same SA passwords....until some trojan captured that password and started mercilessly DOS'ing our servers.
So, instead of having a common password, we...
June 27, 2008 at 9:12 am
Have any of you had a chance to try out some of the stuff Adam Machanic did with Inline TVF's? Just curious, becuase the perf differences are fairly remarkable.
I...
June 27, 2008 at 8:23 am
Jeff Moden (6/27/2008)
jjssilva (6/27/2008)
Jeff Moden (6/26/2008)
jjssilva (6/26/2008)
Check Buffer Cache values. Also, how big are the Databases?The DB shouldn't take more than 80% of the available RAM.
So... what do you do...
June 27, 2008 at 7:25 am
Steven Cameron (6/27/2008)
I think the point of the question is that unless you know how windowed aggregation works, it is a gotcha.
That's certainly a good way to describe it! ...
June 27, 2008 at 7:22 am
The gotcha is in the Windowed aggregate itself. It's a bit RBAR-like in that it seems to create a worktable with LOOP joins to the outer query, so its...
June 27, 2008 at 7:18 am
Never would have thought of THAT one....
Nice part is - by doing just the selects through OLEDB - perf shouldn't suffer too much.
June 27, 2008 at 7:06 am
GilaMonster (6/24/2008)
Matt Miller (6/23/2008)
Gail - in 2005, if you knew it was going to recompile - would you FORCE the recompile on a given statement?
If I know absolutely,...
June 26, 2008 at 9:31 pm
well - I don't know if this qualifies as "simple", but there is a way....Use OPENQUERY.
Of course, in order for that to work, you'd need to set up an alias...
June 26, 2008 at 9:01 pm
Jeff Moden (6/26/2008)
Matt Miller (6/26/2008)
After all - the "-5" on is in...
June 26, 2008 at 5:18 pm
Could daylight savins time be the differentiating factor? This would explain the discrepancy with no timezone factor involved.....
After all - the "-5" on is in the summer (GMT-5), and...
June 26, 2008 at 3:11 pm
Hmm... That's a thought - I'm just not quite sure how to span multiple DB's that way....
Thanks for the reminder re: Grant. I'll ping him if he doesn't pop...
June 26, 2008 at 3:01 pm
....you KNOW you're supposed to do the multiplies FIRST, and then the divides... Regardless of the storage mechanism you're using, you're aritificially aggravating the amount of error.
Makes my blood run...
June 26, 2008 at 2:08 pm
Viewing 15 posts - 2,731 through 2,745 (of 6,486 total)