david.avraamides (11/1/2010)

---

I would consider using a sentinel date such as the maximum T-SQL datetime (9999-12-31) for two reasons: 1) your queries become simpler since you don't always need that "or...

Here's part 1 of a blog series I started and never continued. Still have plans to do it some day 😀

http://sqlblog.com/blogs/adam_machanic/archive/2008/02/08/who-s-on-first-solving-the-top-per-group-problem-part-1-technique.aspx

(edit): Sorry, I was confused and thought Dave's signature was...

Why go to all of the work of talking to end users when you could have simply used OPTION (GOFAST) ?!? Much simpler and, I daresay, more effective.

larry.meklemburg (7/8/2010)

---

I believe it is exactly what occurs in John's case. Thanks for the idea. I will try running Adam's whoisactive script when I next get the error.

As...

For reference, the URL...

WayneS (4/27/2010)

---

Does anyone happen to know where a Microsoft reference exists that defines the XML index structures in SQL 2008? I'm looking for both the Primary and Secondary XML index...

I'm going to unsubscribe...

The Dixie Flatline (4/27/2010)

---

By the way, Adam. I thought you said that you didn't have time to keep up with The Thread about a dozen posts ago. ...

Steve Jones - Editor (4/27/2010)

---

Don't hide, Adam, learn to manage. These people will be doing the SQL Server equivalent of "do you want fries with that" as you point them...

Lynn Pettis (4/27/2010)

---

Not only do you see a lot of homework/test questions here on SSC, but I have seen quite a few of freelance jobs advertised on freelancerer.com for school...

I think it's simpler than you might expect. First of all, phrases of 7 or 8 words are generally enough to be unique, unless they're familiar quotations, etc. Try it...

Jeff Moden (4/27/2010)

---

Sorry Steve... I'm missing...

Tom.Thomson (4/26/2010)

---

I think maybe you're overlooking a couple of things: (1) there are 4 times as many people in India as there are in the USA, so if the two...

This is certainly true. I have...

Hi Chandrashekar and others:

First of all, Chandrashekar, I appreciate your coming on this thread and how quickly you took down the posts. Plagiarism seems to be getting more and more...