Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

RealSQLGuy - Helping You To Become A SQL Hero

My real name is Tracy McKibben. I’ve been working with database products for over 20 years, starting with FoxBase running on Xenix. Over the years, I’ve worked with all flavors of FoxPro, some Clipper and dBase, and starting somewhere around 1995, SQL Server. I’ve even dabbled with Oracle, though I’ve tried to block out all memories of that experience. At present, I’m the Senior SQL Server DBA and the DBA Team Supervisor for Pearson VUE. All opinions expressed on this site are my own and do not reflect the opinions of Pearson VUE.

Friday Followup For August 8, 2014


It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

Comments That Were Posted This Week

  • David on No, Simple Mode Doesn’t Disable The Transaction Log:
    I wrote a Perl program that ran insert statements. Each statement inserted perhaps 20 rows all together as one transaction. Grouping statements together to form bigger transactions made a tremendous difference in overall throughput. For a different project, I had studied throughput as a function of batch size, but I am off on a tangent now and have already answered your question. (I was on vacation last week or I would have responded sooner.)

This Week In History

None, the past holds no lessons this week

That’s it for this week. Get back to work!



Leave a comment on the original post [, opens in a new window]

Loading comments...