Maximum Capacity Specifications for SQL Server

The following table specifies the maximum sizes and numbers of various objects defined in SQL Server databases or referenced in Transact-SQL statements. SQL Server Database Engine object Maximum sizes/numbers SQL Server (32-bit) Maximum sizes/numbers SQL Server (64-bit) Batch size1 65,536 * Network Packet Size 65,536 * Network Packet Size Bytes…

How to Setup Mirroring in SQL Server ?

What is Mirroring in SQL Server ? Database mirroring is an alternative high-availability solution to failover clustering in SQL Server. Database mirroring supports automatic failover, but does not require cluster-capable hardware, and can therefore provide a cost-effective alternative to failover clustering. In this Article, we will implement Mirroring with witness Server and…

Row Compression Implementation

This topic summarizes how the Database Engine implements row compression. This summary provides basic information to help you plan the storage space that you need for your data. Enabling compression only changes the physical storage format of the data that is associated with a data type but not its syntax or…

Page Compression Implementation

This topic summarizes how the Database Engine implements page compression. This summary provides basic information to help you plan the storage space that you need for your data. Note The details of data compression are subject to change without notice in service packs or subsequent releases. Page compression is similar for tables,…

Setting Server Configuration Options

You can manage and optimize SQL Server resources through configuration options by using SQL Server Management Studio or the sp_configure system stored procedure. The most commonly used server configuration options are available through SQL Server Management Studio; all configuration options are accessible through sp_configure. Consider the effects on your system…

SQL Server 2008 R2 Express remotely

If you’re trying to connect to SQL Server 2008 Express remotely without enable remote connection first, you may see these error messages : “Cannot connect to SQL-Server-Instance-Name An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by…

SQL Server 2008 Install Nightmare

SQL Server 2008 Install Nightmare It all started with an installation of Visual Studio 2008 SP1, which included SQL Server Express 2005.  From there I wished to install SQL Server 2008 Standard on the default port and upgrade SQL Server 2005 Express to SQL Server 2008 express.  Unfortunately, this proved…