Viewing 15 posts - 11,521 through 11,535 (of 22,214 total)
Looking at the query, we're really going about it the hard way. A little searching brought up this, and Isaac Kunen's solution. Try that instead.
December 9, 2011 at 10:53 am
Nuts. I wasn't paying attention... again...
Yeah, 2008 is problematic. They fixed stuff in R2. If you're doing spatial, you really need to move. That's the only good solution. Sorry.
December 9, 2011 at 9:26 am
Hmmm.... I'd try low too. The density stuff seems counter-intuitive sometimes.
December 9, 2011 at 8:14 am
Do you have an index in place? If so, start messing with the density on the index. I found that changing[/url] that has interesting impact. The key to the density...
December 9, 2011 at 7:25 am
Hmmm... I'm stumped. I'm not sure why that TOP is in there. But, I don't know that I'd sweat it at the moment with all those clustered index scans to...
December 8, 2011 at 12:39 pm
Stefan Krzywicki (12/8/2011)
Grant Fritchey (12/8/2011)
Stefan Krzywicki (12/8/2011)
Grant Fritchey (12/8/2011)
Stefan Krzywicki (12/8/2011)
Brandie Tarvin (12/8/2011)
December 8, 2011 at 12:23 pm
Stefan Krzywicki (12/8/2011)
Grant Fritchey (12/8/2011)
Stefan Krzywicki (12/8/2011)
Brandie Tarvin (12/8/2011)
Have you cleared the cache to make sure it isn't still trying to pull info from the cached copy of the proc?
It...
December 8, 2011 at 12:00 pm
Stefan Krzywicki (12/8/2011)
GilaMonster (12/8/2011)
RECOMPILE means that the plans will never be cached and hence will have to be recreated on each execution. Grant has a blog...
December 8, 2011 at 9:36 am
Stefan Krzywicki (12/8/2011)
Brandie Tarvin (12/8/2011)
Have you cleared the cache to make sure it isn't still trying to pull info from the cached copy of the proc?
It is a production server,...
December 8, 2011 at 9:34 am
What you need to do is set up a design where the tables define the screen. That's going to be hard to build and hard to program. No way around...
December 8, 2011 at 5:35 am
GilaMonster (12/8/2011)
Grant Fritchey (12/8/2011)
With a permanent table, I have to make clean up a part of some explicit transaction at some point.
And have a process to handle cases where...
December 8, 2011 at 5:04 am
Excellent write up. 5 Stars. Useful information for anyone that has to deal with this stuff.
I'm not an nHibernate expert, nor do I play one, anywhere, but I'm pretty sure...
December 8, 2011 at 4:44 am
julian.fletcher (12/8/2011)
Thanks for your comments. When I said "real table", I meant a permanent one, not one created as and when required in the way that you would with a...
December 8, 2011 at 4:27 am
It almost sounds like there might a view involved. You sure they're all tables? If you eliminated the TOP, but you're still getting it in the plans, even with RECOMPILE......
December 7, 2011 at 1:43 pm
hawg (12/7/2011)
December 7, 2011 at 1:34 pm
Viewing 15 posts - 11,521 through 11,535 (of 22,214 total)