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

• Which One’s Better?
• Don’t Get Slimed By Bad Parameter Sniffing
• Do You Need A Log Recovery Tool?
• Cheating DBCC To Fix Index Corruption
• Building (for FREE) a Virtual Server for SQL Demos
• Using A Non-correlated Subquery To Avoid DISTINCT
• Automated Permissions Auditing With Powershell and T-SQL: Part 1
• Dell Webcast Followup: Subqueries For Superheroes
• Automated Permissions Auditing With Powershell and T-SQL: Part 3
• No, Simple Mode Doesn’t Disable The Transaction Log

Comments That Were Posted This Week

• Dawson Lewis on Which One’s Better?:
  Nice article. I love empirical tests like this.
• Kenneth Fisher on Which One’s Better?:
  Great post! My personal favorite is WHERE EXISTS (SELECT 1/0 FROM …
• realsqlguy on Which One’s Better?:
  Ha… That pretty much proves it…
• realsqlguy on Which One’s Better?:
  Thanks! Glad you liked it. It’s hard to argue with numbers…

This Week In History

None, the past holds no lessons this week

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