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 per short string column 8,000…

Read More

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 will Automatic Failover too. What…

Read More

Disk Set up for SQL Server 2008 on SAN Storage

I have been asked to build a specification for a Server Install for SQL Server 2008 and it is to make use of SAN Storage. With a server connected to Disks (Connected to the server or Disk Array) I would set it up as belowC: – OSD: – MSSQL BinariesF: – System DB’sG: – tempdbI: –…

Read More

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 semantics. Application changes are not…

Read More

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, table partitions, indexes, and index…

Read More

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 carefully before setting these options….

Read More

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 the fact that under the…

Read More

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 to be a troublesome desire. …

Read More