Month: July 2019

4 Options Now That Your SQL Server 2008 Is Out of Support

As of July 9, 2019, SQL Server 2008 and SQL Server 2008 R2 have officially passed from Extended Support to No Longer Supported. What does that mean? It means that Microsoft will no longer release any updates for any version of SQL Server 2008. That includes security patches and data integrity fixes. If a hacker…
Read more

How Many tempdb Data Files Should My SQL Server Have?

We’re frequently asked how many tempdb files a SQL Server should have, especially from those who have downloaded our free 5 Common SQL Server Configuration Issues PDF. That’s because there’s a lot of well-intended but incorrect information posted on the internet about tempdb.  What Is tempdb? Let’s start with a very brief description of tempdb. When SQL…
Read more