Jim Murphy (5/9/2011)

---

Sounds great. I'm flying out of Austin, TX tomorrow afternoon and I'll be in Grants session on Wed.

If...

I just registered for the PASS Rally in Orlando. Wasn't sure I'd be able to get the time/money for it, but it worked out. See you there if...

I've used a forced Merge Join one time. Was a query that most...

Grant Fritchey (5/9/2011)

---

To add one thing to what Gail said:

... and you've tested them extensively on the query that you're planning to use them on.

Test, test, test and then test...

Brandie Tarvin (5/6/2011)

---

Whoot! Did I mention I just got another story accepted? "The Hunt for Liberty Jones," my second science fiction story. And yesterday, I received the edits request.

Editor's Note:

---

...

You're welcome.

You're welcome. Sounds like a classic trees vs forest issue. Happens to everyone now and again.

If you simply query the XML, that's exactly what you will get. That's how XML stores that type of data.

What end result are you trying to get?

If, for example,...

I'm assuming by "join" you mean have the two sum fields together in one row kind of thing. Right?

If so, it looks like the two queries are very similar...

There really isn't a math to that. One connection doing a heavy enough query can bring any server to its knees, so how could there be?

The file extensions are just there for your convenience, since you probably won't be double-clicking a backup file to try to "open" it. Use whatever you're comfortable with.

The script...

When you set the value for the XML variable, put an "N" in front of the first single-quote. That makes the string unicode. Right now, you're using an...

Insofar as "best method", define "best". It gets the job done.

Dan.Humphries (5/4/2011)

---

I would take the opportunity to work "What" into every conversation, e-mail, and interaction I could. I would then put "What" posters all over my cubicle. That...

To really test query performance, you need bigger datasets than this. To legitimize a few apples:apples points, try a test like this:

SET NOCOUNT ON ;

IF OBJECT_ID(N'tempdb..#T1') IS NOT NULL...