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

ItsJustMe_Peter (5/6/2011)

---

There is absolutely no integration with SSMS. The power to work this relies solely on the skill and discipline of my developers. I have found over the...

Data Compression is a feature, as noted in the question explanation that is only available in Enterprise and Data Center editions. If you restore a backup that contains this, or...

I think that this is an item that very few people have thought about, or experienced. I...

Doh! my links are broken. Here you go

http://www.sqlservercentral.com/articles/524/

http://www.sqlservercentral.com/articles/525/

http://www.sqlservercentral.com/articles/526/

On the cheap, you can look here: http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/vcspart1/523/

Red Gate's Source Control supports a lot of VCS systems with the latest release and integrates nicely with SSMS.

Disclosure: I work for Red...

Interesting idea. Sounds like a reasonable strategy for your business. I'd be concerned about having to recovery with Compellent at another location, but that's separate.

One other question for you: do...

Me either, but it makes some sense that you might want to mirror your publications. I think not...