ROFL Steven!

Where the hell did you find that?! 😀 :w00t:

Hey Chrissy,

A number of folks (myself included) would be happy to help you nail down your requirements and the like and help with the presentation. The best forums for...

Thanks for the kind words folks, and I'm glad people can still get some distance from this article.

Dird, I'm sorry you disagree but just because it's common doesn't...

Nevermind.

GilaMonster (5/22/2013)

---

No idea what one...

Lynn Pettis (5/22/2013)

---

If anyone can find it a provide the url (by clinking and pasting from the message number) I would appreciate it. I have been rereading the past...

Need more data. What are you trying to group it by? All you're showing us is what appears to be half a query with the MIN/MAX. What...

The only person I know around these parts who has gone deep enough into the internals to really understand costing and why a particular number would be x would be...

Well, I've been around...

Yeah, sorry, been working all night and hoped a quickie would get your answer for you. Got some time now so here's your query end to end:

IF OBJECT_ID ('tempdb..#test1')...

rocky_498 (5/21/2013)

---

INSERT INTO Test1

VALUES ('1','FirstValue','140/90','1','4')

INSERT INTO Test1

VALUES ('2','SecondValue','140/90','1','4')

INSERT INTO Test1

VALUES ('3','ThirdValue',null,'4','3')

INSERT INTO Test1

VALUES ('4','FourthValue',null,'4','3')

Select

* from test1 t1

...

Costs are guidelines and SQL tends to overestimate XML breakouts in my experience. I don't see anything particularly strange here, however. Also, this is an estimated query plan.

Are...

I don't usually say this but your problem is a bit too large for a forum post. The amount of details and discussion required to get into the nitty...

Rule of thumb before we starting getting rediculous amounts of cores....

As usual, this conversation got away from my 'quick reply' ability to respond to the pieces, so my tardiness isn't ignoring it, it's wanting to make sure I had enough...