Desiree Harris

Desiree Harris

back to homepage

Desiree Harris Free Articles

Moving A SQL Server Database

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.

Read More

Indexes: An Overview and Maintenance for Performance

Many people know the ... of creating indexes on SQL Server database tables. Indexes greatly improve the ... of a ... However, while many people create indexes on their SQL Server

Read More