Viewing 15 posts - 18,436 through 18,450 (of 22,202 total)
Completely no help to you, this is a great example of how the estimated costs and the actual costs have nothing to do with each other. Jeff would love it.
February 6, 2009 at 11:57 am
Looking at it some more, you're query is joining between tables with this:
JOIN dbo.Citizenships AS C
...
February 6, 2009 at 11:55 am
That's a strange one. The estimated & actual rows are WAY off. You might check the statistics. Let me keep looking.
February 6, 2009 at 11:47 am
TheSQLGuru (2/6/2009)
I have seen this for massively partitioned tables as well.
Really. When did it occur? When the query had to hit lots of the partitions or is it just a...
February 6, 2009 at 11:20 am
Oh no, if it's going to bug the apps, then clearly the data is not guaranteed unique. I'm just saying if the data is going to be unique, there's no...
February 6, 2009 at 9:08 am
Lynn Pettis (2/6/2009)
Grant Fritchey (2/6/2009)
I forgot, swabbie, deck ape, blue jacket, airedale, a-ganger (nasty job).
The more you remind me of what my brother said about the Navy, the more I'm...
February 6, 2009 at 8:13 am
Yeah, that's pretty much my understanding too. Better & more memory management in the 64bit operating system, which benefits SQL Server.
I don't know where you heard that it's 32-bit only...
February 6, 2009 at 8:10 am
It depends on the queries being run. The optimizer will take into account when an index is unique and it can improve performance, but it really does depend on the...
February 6, 2009 at 8:08 am
I forgot, swabbie, deck ape, blue jacket, airedale, a-ganger (nasty job).
February 6, 2009 at 8:04 am
GilaMonster (2/6/2009)
February 6, 2009 at 7:52 am
GilaMonster (2/6/2009)
February 6, 2009 at 7:51 am
Lynn Pettis (2/6/2009)
Grant Fritchey (2/6/2009)
Lynn Pettis (2/6/2009)
February 6, 2009 at 7:48 am
Chris Morris (2/6/2009)
Grant Fritchey (2/6/2009)
February 6, 2009 at 7:45 am
Lynn Pettis (2/6/2009)
February 6, 2009 at 7:11 am
Lynn Pettis (2/6/2009)
Grant Fritchey (2/6/2009)
February 6, 2009 at 6:50 am
Viewing 15 posts - 18,436 through 18,450 (of 22,202 total)