Good article Dwain.

IMHO, it more illustrates how important it is for the DBA to understand better about SET based logic. I'm a huge fan of Itzik Ben-Gan's book "Inside Microsoft...

Couldn't you accomplish the same thing with Roles? Set built-in users to datareader role, even get a little bit paranoid if you'd like and explicitly deny datawriter role.

We currently use...

I don't like it when viewing from desktop; too much wasted space on large screen.

It's nice for mobile display; which I seldom use.

Dana Medley (11/30/2012)

---

arthurolcot (11/30/2012)

---

Lokesh Vij (11/30/2012)

---

Stewart "Arturius" Campbell (11/30/2012)

---

Koen Verbeeck (11/30/2012)

---

Got it wrong because you can update or delete rows in the primary tables if you specify ON CASCADE options.

Next...

Tom,

To start off with an improperly sized log file such as that of which you are describing can actually hurt your performance in a magnitude that is unacceptable. You may...

SQL Noob (11/9/2009)

---

interesting

i have two databases that are replicated and generate tens of millions of commands a few times a month. Most of the db is deleted and new data...

Ok, so what about taking concept to the real world? Easy enough to do…in both scenarios you can create a database at the proper size (150MB to store my code...

Gail, great questions (especially the proof question). I split this into two postings; to make a little easier to read...as well as easier for anyone who wants to respond to...

That sure did a horrible formatting job...

here is the...

Here is a simplified version of my last query...

SELECT * FROM #LogInfo

WHERE ([CURRENT LSN]) > (SELECT TOP (1) [Current LSN]                       ...

Charles Kincaid (11/9/2009)

My mileage varies here. For me unplanned server restarts are the big one. Having a customer call to say that the cleaning person unplugged the SQL...

Now to add on to what Charles has already said...

The flip side of the coin with the performance between SIMPLE and FULL is that if you have a large number...

Robert,

One way, although not the only (nor the best for that matter), to determine if you have an issue with performance due to the transaction log sharing the database hard...

Robert,

That's a great question...and the answer is, as almost always, "it depends".

My opinion, if you want to "guarantee" the optimal performance...then always use different physical (and logical) hard drives. This...

What is your recovery model set at?

It sounds like it might be set as SIMPLE. If it is, try setting it to FULL and then attempt to continously add data...