Steve Jones - Editor (1/6/2010)

---

good editorial, and nice reminder, Grant.

When I'm with Scouts, if we're out in the woods and something breaks, you need to have things to respond to...

GilaMonster (1/6/2010)

---

Why are there so many 'if you don't help me I'll lose my job' posts all over the place? I just got one by PM. Frankly, seeing that in...

CirquedeSQLeil (1/5/2010)

---

Lynn Pettis (1/5/2010)

---

Actually, nothing earlier indicated that it was urgent, so more...

There are multiple web sites out there that list the various symbols used by the different modeling methods. For example, here's the class, probably most reductive example: http://en.wikipedia.org/wiki/Entity-relationship_model

Tossing another penny down the well, I'd go with the Internals books. I'd especially focus on T-SQL Querying book. It has a couple of chapters on how the optimizer works...

sunpalozzi (1/5/2010)

---

New issue, I am testing the script. I defined the condition field to be varchar(500) in the table. I queried out the table into a cursor. ...

The thing you're looking for is the TOP operator (check it out in BOL) but it's going to return nonsense values if you don't supply additional information, basically something to...

Thanks Scott. I'm looking forward to your presentation at Data Camp 2.0 as well. You need to keep up your work for the community also.

Now, I happen to be closely...

Nice article and useful for digging out those silly artifacts.

Ronald Cartmale (1/5/2010)

---

I could not agree more with the editorial and have always sort to ensure that my company’s data is protected by the best possible practice but when you...

Edogg (1/4/2010)

---

Grant Fritchey (1/4/2010)

---

Speak of Murphy and he...

ken.trock (1/4/2010)

---

This is something of a...

Oh, that's a backup. I thought it was disaster recovery.

sudhakara (1/4/2010)

---

Jack Corbett (1/4/2010)

---

Sorry to say that you are basically screwed since you have no backups. Your only option is to run DBCC CHECKDB or CHECKTABLE with one of...

GilaMonster (1/4/2010)

---

But why would you need a backup? I mean, it's not as if a disk will fail, or someone drops a table (or the entire database) or the data...