Post-Holiday Blues.

Hrm. That's more than one word. ... Let me try that again.

WOTD: Morning?

Hope everyone enjoyed their long weekend (those of us who got one).

In the spirit of changing the water cooler topic (and for those who missed the thread I posted this...

It's always good to keep the original data of the table stashed in a different DB / different table just in case you have to restore data from that one...

homebrew01 (11/23/2010)

---

When I have a job that I want disabled for a period of time. instead of disabling it, I often change the start date to a future date, so...

Oddly enough, I know a lot of DBAs & Devs who use SELECT DISTINCT out of nothing more habit. It's not that they need to do it. They just assume...

Glad you're out of the hospital, Jack. I hope you're feeling better.

Try to have a little fun at work if it's less stressful then the kids. And if you need...

Or that someone's doing...

A few more comments on your code. Look at your first three insert statements. Remove the subqueries, do LEFT OUTER JOINS with the subqueries, and look at making all three...

Gangadhara MS (11/21/2010)

---

I have followed the same steps and found that some stored procedures having highest duration abnd IO/CPU.

But my developer saying i can't further tune with query as...

shopping

(for holiday eats)

Thanks, Gail. I can't check twitter while I'm at work.

"Stress is the universe's way of telling you to sloooooooooow doooooooooooown."

Tofurkey

Chris Morris-439714 (11/22/2010)

---

Our DBA caught some...

CirquedeSQLeil (11/22/2010)

---

Alvin Ramard (11/22/2010)

---

Brandie Tarvin (11/22/2010)

---

I live in Florida now. Black Friday is not so bad when you can wait in line at 2:00 a.m. in only a jacket, t-shirt,...

holiday.