I’m using simple recovery, so the log file isn’t important right?

One of the big myths of SQL Server resolves around the transaction log, and how it’s used with the simple recovery model. Many people think that the simple recovery model doesn’t use the transaction log.  More specifically they think that it’s there because it has to be there, but that SQL Server doesn’t actually use […]

Recommended reading from mrdenny for April 26, 2013

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. What is 360° view of a Customer? Migrating Legacy LOB Data Types to Current Ones – A Big Gotcha! Implementing Snapshot or Read Committed Snapshot Isolation in SQL Server: A Guide How […]

Write about what you care about. If you do the page views will happen.

Ask any SEO “expert” and they’ll tell you to write stuff that’ll get you lots of page views, to use key words to lure people in.  The problem with this approach is that you end up not writing about the stuff that people want to read week over week, month over month. Now getting people […]

Recommended reading from mrdenny for April 19, 2013

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Understanding When Statistics Will Automatically Update Analyzing Complexity of Text MCM – I passed! Pie in the Sky (January 4, 2013) Seamless insights on structured and unstructured data with SQL Server 2012 […]