Koen - You mean 'DBCC TimeWarp(SlowTime)' doesn't speed up response by slowing time for the end-user? Drat...:-D

I don't think Prod has slowed down, as none of the...

Come now, there is at...

Ed Wagner (6/13/2014)

---

Jack Corbett (6/13/2014)

---

GilaMonster (6/13/2014)

---

Thought process of last 10 minutes.

- Tune a proc quick, then go home

- Wait, it's got user defined functions

- Wait,...

Awful quiet in here over the last couple days...

Should we turn out the lights on this thread?

:hehe:

The log file is going to be as big as it needs to be. Lots of small transactions, a couple long-running transactions could keep it at the size you're...

dax.latchford (6/10/2014)

---

Also as mentioned my colleague has created a domain account with the rights to backup to a UNC location. Is it safe for me to do the following to...

OK, if you folks don't knock it off with the divide by 0 discussion, I'm going to execute DBCC TIMEWARP (GETDATE()/0)!!!

Then we'll see what happens when you divide by 0!

:hehe:

I run into something...

You know, I'd not really thought about this until now, but...

How do people find all these "undocumented" options for various SQL commands?

dbcc autopilot???

create index... WITH STATISTICS_ONLY = ???

What do these...

It's not entirely true that an online index rebuild takes *no* locks. It takes (generally) very short locks at the beginning and the end of the process.

Here's an article...

Shredder

Ninja

Thanks all!

Yeah, the original *is* a monstrosity, it's the first time on my servers I've seen a query stalled out on CXPACKET waits...

Should be interesting to see what comes up...

As someone stated (movie? book? paraphrased regardless): We stand on the shoulders of giants, building on their successes.

Every generation builds on top of what the previous generation accomplished....

Jcrawf02 - No, I think when you go for a ride, you're up front. One of the guys I used to work with went up in Yankee Lady and...