SanDroid (5/6/2011)

---

Paul Randal (5/6/2011)

---

There's no choice but to have it behave that way because something in the transaction log that gets recovered at the end of the restore good disable...

I'm not sure there's something you "need" to know about R2. There are more features, PBM is enhanced, filestream, etc. that are changed a bit, but I'm not sure there...

What best practices are you looking for? SQL Server is so wide, with so many features, it's hard...

AFAIK, most people are still running with SPs. I haven't seen much positive or negative on the R2 CUs.

I'll check the R2 link

pubic is a role that should not have permissions assigned. That query returns nothing for my instances, which leads me to believe someone has assigned permissions on your server.

If I...

Tom.Thomson (5/6/2011)

---

You're right :blush:. Sorry, brain wasn't functioning - I looked at it and thought "how many heaps" and answered that instead of what was actually asked; and then didn't...

Interesting blog post from Roy. Anyone ever tried this?

http://www.sqlservercentral.com/blogs/dba_rumblings/archive/2011/05/06/why-you-should-ask-your-cto-to-attend-the-user-group-meetings.aspx

I used to go to a networking conference with my boss. A bit of a boondoggle, but I did get to point...

Brandie Tarvin (5/6/2011)

---

Whoot! Did I mention I just got another story accepted? "The Hunt for Liberty Jones," my second science fiction story. And yesterday, I received the edits request.

Editor's Note:

---

...

You don't want to lock the record, you want to prevent changes, correct?

A FK can help if you have explicitly declared them as a constraint. Then all the referencing items...

Mhlewis (5/6/2011)

---

I assumed that the question was referring to backup compression, not page or row compression. I think the question would be more clear if the terminology of "page...

Eric M Russell (5/6/2011)

---

Companies like Google or FaceBook manage a lot of data, but it's not held the same degree of scrutiny. For example, if FaceBook dropped 1 out of...

Tom.Thomson (5/5/2011)

---

I am very sure that the "correct" answer is utterly wrong.

The MS documentation makes an absolutely clear distinction between "heap" and "heap structure". For example the sentence...

JoeS 3024 (5/5/2011)

---

So Steve what would you recommend then for those poor souls? As being one of them it drives me nuts to constantly be told I can't get...

J Thaddeus Klopcic (5/6/2011)

---

As a former database developer for UPS, I can defintely state that UPS does use SQL Server to process its packages. While the main package database...

Nakul Vachhrajani (5/6/2011)

---

Here in India, we have a saying that if a restauranter does not eat in his/her own restaurant or if a building contractor does not live in buildings...