Anybody else see that Alvin morphed from a chipmunk to a human being?

home

Just so it is clear and to reiterate once again -

Store the results of the cte in a temp table if they are needed for later consumption in the...

SSIS, SSRS, Improve Perf Tuning (perpetual goal), more active in PASS, and Blog

THANKS FOR THE QOD BitBucket

Try the DBCC UpdateUsage that Gail also suggested. Also, try updating stats for all tables rather than just the tables involved.

Nice article

Steve Jones - Editor (12/31/2009)

---

CirquedeSQLeil (12/31/2009)

---

The jobs I have held followed this idea of "do the job" 24x7x365. Most had no compensation for on-call nor for holidays - the...

Happy New Years All (jumping on the BANDWAGON):hehe:

As for snow, we had our snowstorms over the past couple of days - nothing major, just a little slick and only about...

lmu92 (12/31/2009)

---

I know a company that runs the following concept:

During weekend and Holiday there will be a three level support system:

Level 1: On Call

You have to be reachable by phone...

Steve Jones - Editor (12/28/2009)

---

Mzak,

you are correct. However many jobs, many IT jobs, don't specify holiday requirements. I've never had that be stated when I was hired. You're expected to...

jcrawf02 (12/31/2009)

---

My very...

Are we human or are we dancer?

That is just wrong

One such script can be found at http://blog.sqlauthority.com/2006/12/01/sql-server-cursor-to-kill-all-process-in-database/

I think it would need some mods to keep it to killing only the desired SPIDS