SQL copy only back and restore

If you would like to create an ad-hoc backup without disrupting your current backup jobs you will have to use the new copy only option for SQL 2005. This is command line only operation that you can’t do within the SQL gui window. We will assume the following: old database name: DataBase1 old database logical name: Database1 old database transaction […]

SQL index Fragmentation

One of the most common reason I have seen for SQL slow down is improper maintenance of the databases indexes. While I won’t get into the specifics of an index. I’ll just say that the closest analogy is a table of contents for a book. Once I have a idea of the database that is being used I will run […]