Skip to main content

“SQL Server 2005 Everywhere Edition” Now Called “SQL Server 2005 Compact Edition”

Written by Julian Kuiters

Ahead of the final release in December 2006, Microsoft have released SQL Server Compact Edition RC1. SQL Server 2005 Compact Edition is a very lightweight, in process relational database engine for use in desktop applications and mobile devices. It has an extremely small footprint (~3MB) and minimal overhead. It won’t use any where near as […]

SQL Server / Microsoft SQL Server / MSSQL, SQL Server 2005, , ,
Read More

Optimising SQL Server 2005 TempDB

Written by Julian Kuiters

Microsoft’s whitepaper on Optimising TempDB in SQL Server 2005 contains a lot of useful information for anyone trying to push the performance of SQL Server 2005. Along with the internal improvements to tempdb, there are a number of things a database administrator should do as part of any installation: Increase the number of data files […]

SQL Server / Microsoft SQL Server / MSSQL, SQL Server 2005, , , , , , ,
Read More