Thursday, November 09, 2006

Three SQL Server Tips

From TechRepublic.com:

Add Bulk Copy Program (BCP) to your SQL Server Arsenal  "The Bulk Copy Program (BCP) is a command-line utility that ships with Microsoft SQL Server. With BCP, you can import and export large amounts of data in and out of SQL Server databases quickly and easily. Any DBA who has utilized this functionality will agree that BCP is an essential tool."

Achieve High Availability with log Shipping in SQL Server 2000 Log shipping is a technology in SQL Server that database administrators can use to provide a standby database to failover to in the event of a primary database failure.

Running Totals in SQL Server Queries An example of how to run totals in SQL Server queries. Two advantages to such a query include: you don't have to store the results, and you end up with a transaction log that can be inspected row by row.

No comments: