Ever wondered why sometimes SQL Server sits there, twiddling its thumbs, when you create or grow a database file? That’s because, by default, SQL Server zeroes out the space to keep things "secure." ...

Let’s be honest: When you're restoring a large database at any time (manually or with an agent job or automated batch) and watching the progress bar barely move, you start questioning life, backups, ...