About Desire Harris

Desire Harris is a support specialist with ORCS Web - a company that provides managed hosting services for clients who develop and deploy their applications on Microsoft Windows platforms.
Indexes: An Overview and Maintenance for Performance

Many people know the importance of creating indexes on SQL Server database tables. Indexes greatly improve the performance of a database.

Moving A SQL Server Database
· 1

A database move can be done a couple different ways, but when the database is updated frequently and the move needs to be completed with minimal downtime and no data loss, it is best to move it by detaching and then reattaching the database on the new server. The database will be offline during the move but it is better to have it offline than to miss transactions when backing up and then restoring the database on the new server.