Viewing 15 posts - 7,711 through 7,725 (of 8,416 total)
Jeff Moden (6/20/2009)
June 20, 2009 at 9:34 pm
Jeff Moden (6/20/2009)
It would be really helpful if several other IE users started throwing rocks at this annoying problem.
Hey Jeff,
So yeah - I'm game - at whom should we throw...
June 20, 2009 at 9:12 pm
tfifield (6/20/2009)
I've kind of forgotten what the advantage to SCHEMABINGING is for a scalar UDF. I think I read it somewhere, but I can't find it in my SQL...
June 20, 2009 at 8:28 pm
Lynn Pettis (6/20/2009)
If we just give him answers and he ends up in a position that he isn't qualified for do, who's fault is it, ours or the employer who...
June 20, 2009 at 10:43 am
ps (6/20/2009)
Well it looks as if someone's put his exam question papers here to be solved ..:-Dhttp://www.sqlservercentral.com/Forums/Topic738841-146-1.aspx
It took an enormous effort of will on my part not to post sarcastic...
June 20, 2009 at 10:29 am
RBarryYoung (1/14/2009)
When I've been in your situation, I have...
June 20, 2009 at 10:24 am
Hey there,
The problem with ROW_NUMBER and paging in very large tables is that you end up calculating the row number for a very large number of rows.
In your case, it...
June 20, 2009 at 10:08 am
Florian Reischl (6/20/2009)
WayneS (6/20/2009)
I haven't heard of this tool... maybe you and/or Paul can write an article about it?Great idea 😀
Heh. Not going to happen!
There a free trial available...
June 20, 2009 at 9:52 am
mazzz (6/20/2009)
I appear to have won a year's licence for Quest's Spotlight for Sql Server, after filling in my details at their booth at the SQLBits conference!
Does anyone...
June 20, 2009 at 7:29 am
leomar,
It's really hard to offer a solution here, particularly since the query appears to reference a view which could be anything! The general construction of the query is potentially...
June 20, 2009 at 4:28 am
JamesNZ (6/20/2009)
GilaMonster (6/20/2009)
June 20, 2009 at 4:19 am
Jeff Moden (6/19/2009)
Heh... cool... maybe a little head boiling will get him to fix the code windows for IE? 😛
I admire your persistence.
And your optimism!
😛
June 19, 2009 at 11:57 pm
Steve Jones - Editor (6/19/2009)
June 19, 2009 at 11:50 pm
dan (6/19/2009)
Actually performs far better when rewritten like thisSelect ds.ndate, p.policyID
From policy p
Cross join
dateSequence ds
where p.dateFrom = (select max(dateFrom) from policy where ds.ndate>=dateFrom and policyID=p.policyID)
Hey Dan,
I would just say...
June 19, 2009 at 11:44 pm
Might be that the server is occasionally caching an execution plan based on a parameter value which is not typical for your workload. A plan that works well for...
June 19, 2009 at 10:39 pm
Viewing 15 posts - 7,711 through 7,725 (of 8,416 total)