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...

The impression I've gotten is that they already have a contract with NASA to ferry crew, it's just been waiting for the man-rated capsule to be completed and certified.

Dang, I...

Steve, definately unplug as much as possible. While I've not taken a "sabatical," I've taken a couple vacations where I've had to 99% unplug and you come back from...

So, anyone hear about the unveiling of the SpaceX Dragon V2 capsule last night? It's their first man-rated capsule, and they're planning to have their first manned launch in...