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

• What Are Your Servers Doing While You’re Sleeping?
• Cheating DBCC To Fix Index Corruption
• Don’t Get Slimed By Bad Parameter Sniffing
• Which One’s Better?
• Do You Need A Log Recovery Tool?
• Automated Permissions Auditing With Powershell and T-SQL: Part 1
• Building (for FREE) a Virtual Server for SQL Demos
• Using A Non-correlated Subquery To Avoid DISTINCT
• CAST(‘RealSQLGuy’ AS BELIEVER)
• Dell Webcast Followup: Subqueries For Superheroes

Comments That Were Posted This Week

• realsqlguy on No, Simple Mode Doesn’t Disable The Transaction Log:
  Were you inserting data through a bulk insert operation, or as batches of transactions?
• Don Schaeffer on Don’t Get Slimed By Bad Parameter Sniffing:
  Sometimes the best answer can be two query plans. A stub can check the parameters and execute one of two identical procedures depending of the input parameters. For example, our procedures often include a start date and end date, The best query plan for a single date is likely to be different than when for a date range of a year. So create two procedures.

This Week In History

None, the past holds no lessons this week

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