A cluster scenario is not solely for the purpose of HA. Within a multi-node cluster deployment multiple active SQL Server instances have concurrent read and write access to a given...

Have you determined the root cause of the transaction log growth? What is prohibiting the SQL Server from automatically truncating the log and thereby freeing disk space? Are database backup...

For well designed relational databases, foreign key (FK) constraints are not optional. They play a significant role in maintaining referential integrity. Having stated that principle, it is possible to place...

The generic approach is to upgrade to a SQL Server cluster (where multiple SQL Server instances concurrently access the suite of databases), and implement asynchronous database mirroring (to an failover...

Have you tried within your SELECT statement to CAST/CONVERT the variable length VARCHAR fields to a fixed length data type, e.g., CHAR.

When working with a single data source and a single data destination it is advisable to use the Import and Export wizard with the SQL Server Management Studio (SSMS). That...

If your source table is managed by a MS SQL Server 2008, then you can alter its database to allow Change Tracking. When doing so, you can also set the...