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
- Don’t Get Slimed By Bad Parameter Sniffing
- Which One’s Better?
- Cheating DBCC To Fix Index Corruption
- Building (for FREE) a Virtual Server for SQL Demos
- Automated Permissions Auditing With Powershell and T-SQL: Part 1
- Do You Need A Log Recovery Tool?
- Using A Non-correlated Subquery To Avoid DISTINCT
- What Are Your Servers Doing While You’re Sleeping?
- CAST(‘RealSQLGuy’ AS BELIEVER)
- Automated Permissions Auditing With Powershell and T-SQL: Part 6
Comments That Were Posted This Week
- David on No, Simple Mode Doesn’t Disable The Transaction Log:
I ran a test once to compare the speed of the simple recovery model to the full recovery model. On my workstation, I pumped data into three tables for an hour. Under simple mode I was able to insert 52 million rows into my test database. Under full recovery mode, insert rate jumped to 84 million rows per hour. I suppose the simple recovery model had more random disk seeks that slowed things down. Perhaps the full model just kept pumping data to the end of the file, a relatively efficient operation.
This Week In History
None, the past holds no lessons this week
That’s it for this week. Get back to work!
