Viewing 15 posts - 16 through 30 (of 236 total)
Lynn Pettis (12/14/2012)
December 17, 2012 at 9:34 am
Yes Scott, thanks. That's the kind of change I was looking for. I think performance will be better with that but I'll test and let you know. I was just...
December 17, 2012 at 9:27 am
LOL, I generated that view, and it's 4900 select statements, just for the numeric columns 🙂
It was good for a laugh anyway... I wish I could post the graphical execution...
October 2, 2012 at 4:03 pm
OK that's kinda what I was thinking, but these tables change periodically, so I'll have to figure out a way to generate the view, as I don't want to write...
October 1, 2012 at 3:48 pm
call.copse (8/21/2012)
Raoul Bastendorff (8/20/2012)
skron (8/20/2012)
August 21, 2012 at 9:25 am
george.clarke (8/20/2012)
August 20, 2012 at 9:26 am
Thanks David, that's exactly what I needed. I'll look into that information and do some more testing.
August 20, 2012 at 9:15 am
David Webb-200187 (8/17/2012)
August 17, 2012 at 4:16 pm
AlBran LVP (8/17/2012)
August 17, 2012 at 3:49 pm
sturner (8/9/2012)
jbnv (8/9/2012)
Is there any benefit of bringing such a vision to a company that can't seem to grasp it?
Sadly, No. A lot of existing organizations have business...
August 9, 2012 at 9:26 am
WTH?! It doesn't short circuit?! How can that be possible? I've based my whole life on that principle! OMG, what will I do now? How can we prove this? 🙂
July 18, 2012 at 10:21 am
The Express version is missing tools, like the index tuner. It's worth it to go find the disk to get the full version if you need those tools, but yeah...
July 18, 2012 at 9:49 am
I can't see your image, probably the firewall here. I don't really understand what you're trying to do either. It's either really simple or really complicated - I can't tell....
July 18, 2012 at 9:46 am
GilaMonster (7/17/2012)
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
And to toss fuel on the fire, several of the query patterns mentioned in this thread would cause all sorts of hell when the plans are reused with different...
July 18, 2012 at 9:37 am
SQLKnowItAll (7/17/2012)No arguments, just a spirited discussion 🙂 Curious though... How do you know that the index scan runs faster in mine? I did not post any execution plan or...
July 18, 2012 at 9:33 am
Viewing 15 posts - 16 through 30 (of 236 total)