I agree. I was tempted to pick A, but (and perhaps I was reading the question too literally) picked D because the question said the cost had to be below...

In principle there is no difference, but in PR terms there may be. People may have the wrong impression that a system is automatically more secure when it uses a...

Thanks! I think it turned out that the performance issue in this case was not due to the database, which supports your suggestion that the tlog size was not the...

Just an update - the transaction log file size is now up to about 2 GB.

Is this OK?

Thanks again.

----

webrunner

We are on SP1. SP2 had some trouble so we have not moved to it yet.

I ended up writing a T-SQL procedure to do the deletions, based on an example...

I know the feeling. Looking forward to getting the script if you can post it.

Thanks again!

---

webrunner

Thanks, that is good to know. So a database that is, say, 610 MB, with a tlog file that is 615 MB, is not necessarily bad?

In terms of performance,...

Hi, and thanks,

The reason I think it is too large is that it is larger than the database file itself (the .mdf file). I thought that was a sign of...

Thanks for your reply. I'll try to answer your questions as best I can.

We run transaction log backups every hour. We make a full backup once per dayat 6:00 pm....

Thanks to everyone for the advice.

rstone - would you be willing to share the details of the job you created that runs every 15 sconds and logs/emails info? At least...

Thanks to everyone for the replies. Modifying the owner worked. I made a copy of the job and set the owner to the generic account the previous DBA created for...

Thanks, that is a good suggestion. I checked the job properties, but it does appear that the job is pointing to the correct database on the production server. Also, since...

Great point, thanks.

---

webrunner

I think IT, medicine, and law intersect in interesting ways.

Medicine is the most obvious case where lives can literally be lost if mistakes are made. But so can law and...

Hello Andy,

Yes, the mini-review format is useful. Frankly, I am happy to see any discussion of SQL books.

Something I have noticed is that SQL books are extremely expensive on...