SQL

COAX EVEN MORE SPEEDOUT OF YOUR SQL SERVER DATABASES...

SQL Server's replication feature lets you reproduce data from one database to another. A major component of SQL Server's replication technology involves horizontal (row) and vertical (column) partitioning, which lets you control what data you rep...

Speeding Large Data Loads with Bulk Copy Program...

What a difference a CPU makes...

table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; text-align: center; } ...

I used Dynameasure 1.0 by Bluecurve to generate my test load and...

The Straight Story on Virtual Server Chat with Mike Otey Chat live on May 25 Robert Schneider introduced 10 ways to optimize >SQL Server from the programming viewpoint in, "10 Easy Tips for Better SQL Serve...

Arguments over row- vs. page-level locking take on near religious importance...

table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; text-align: center; } ...

To use DMO from VB, follow these simple rules: Include the SQL DMO type library Create a SQL Server object Connect the SQL Server object to SQL Server Use the SQL Server objects Disconnect from SQL Server