One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of how ...

So I have a specific database that won't release and shrink its log files. The DB backups are happening successfully, but I still have 4GB of logfiles (and no, this DB does not generate 4GB of log ...

What do you do when you can't avoid huge transaction logs in SharePoint and your files are too large? Last month, I wrote about how to avoid having ginormous transaction logs within SharePoint ...

While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft’s database has a boatload of new features and delivers solid performance improvements.