The following table specifies the maximum sizes and numbers of various objects defined in SQL Server databases or referenced in […]
What is Mirroring in SQL Server ? Database mirroring is an alternative high-availability solution to failover clustering in SQL Server. […]
I have been asked to build a specification for a Server Install for SQL Server 2008 and it is to […]
This topic summarizes how the Database Engine implements row compression. This summary provides basic information to help you plan the storage […]
This topic summarizes how the Database Engine implements page compression. This summary provides basic information to help you plan the storage space […]
You can manage and optimize SQL Server resources through configuration options by using SQL Server Management Studio or the sp_configure […]
If you’re trying to connect to SQL Server 2008 Express remotely without enable remote connection first, you may see these […]
SQL Server 2008 Install Nightmare It all started with an installation of Visual Studio 2008 SP1, which included SQL Server […]