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

So, for anyone who uses TrueCrypt personally or professionally:

Ars Technica: "TrueCrypt is not secure"[/url]

Reading comments elsewhere (Theregister.co.uk) one commenter suggested that rather than this being a plot by the NSA...

Thanks Ed!

Yeah, I've been doing some poking around on the sort_in_tempdb...

Pretty much, do I want the DB to (potentially) grow, or TempDB?

An advantage I can think of to using two (or more) individual monitors over one large one is, if you maximize a window in a dual monitor setup, it stays...

I think the big issue seems to be that a lot of companies see the only progression (at least if you want your pay to increase by more than a...

My question would be, what is this for? Is this for a learning sandbox so you can get a feel for / practice setting up a fail-over cluster, or...