Dang it, Jack! Somehow I missed this article when it was published. Found it as a link in one of your good posts. Awesome article especially for...

mark.hall (11/3/2008)

---

I've got an SQL server where my avg. page splits per second is 3-4. However there is process that runs twice a day when this process is running...

OMG! LMAO! Stop it! {Clutching at sides trying to catch a breath} That's just too funny! 😛

J (11/3/2008)

---

Never used CLR yet. This was supposed to be the greatest thing since sliced bread.

Jeff, would you please enlighten me as to why CLR is viewed as a bad...

I appreciate the comments guys. Thank you very much. Perhaps I will write it up as an article with a couple of more "gotcha" examples... Thanks again.

jack_hc (11/3/2008)

---

Jeff Moden (10/31/2008)

---

jack_hc (10/30/2008)

---

Hi,

I am facing a problem to extract data from a table, the table contains over 41k records, and some of them(>5k) share same column value, now...

It's amazing, even to me, how often that particular solution has been used, lately. Nice job, Seth. 🙂

Heh... I wanna know who ever said that "set based" meant "everything done in one query... 😛

Angela Henry (10/31/2008)

---

An update on this.

I thought I had figured out how to do this. I set up a total of three separate shared schedules (not bothering with leap...

charles.frank (11/3/2008)

---

Thanks for all of these ideas. They've helped me narrow the scope of what I need. I'm most interested in the amount of time that machines take...

BWAA-HAAAA!!! You're addicted! Now, that's some funny stuff right there! 🙂

Nice job on the code, Seth. Only thing you might want to try,...

Ummm... the answer is actually near the beginning of this thread. Instead of waiting, read the rest of the thread.

jeanangeo,

Where does "SessionTypeX" come from in your desired results?

I agree... you want practice? THIS is the place to get it. Lot's of books have the same ol' stuff and while they may be good for rank...

Views are no worse than "Inline Views" like CTEs or Derived Tables (sub-queries that are used like tables)... proper views, that is.

The problem with a good number of views is...