That was an oversight on my part, you are correct. To much R&R over the holiday I guess. :hehe:

David

Good article. One thing to add, if running SQL2K5 or later on Windows 2003 or later, enable instance file initialization. Doing this will minimize the impact of growing...

If you want to use DBMail for alerts, be sure to enable this in the SQL Server Agent properties.

David

A database snapshot cannot be backed up, either with SSMS or any third party software that I'm aware of. Technically since a db snapshot is viewed as a read-only...

Hilarious... yet so true.

David

A snapshot backup is different then performing a database snapshot described in the question. :blink: SSMS does not support snapshot backups but SQL Server itself does but only...

Not to be obvious, but you cannot shrink a snapshot. Taking a new snapshot does not shrink it, it creates a new snapshot with a new and update view...

Good question. Unfortunately SQL Server 2005 SP2 does not ignore database snapshots when selecting the "all databases" option in the backup task in a maintenance plan. Seems to...

My initial response to the question was "No" because the question never stated a full backup was taken. Like many of the others, the idea of a performing a...

All voting systems are prone to errors and corruption. Paper votes can be altered, replaced or "lost" so I would not say that having a paper voting system is...

You do have a choice. You can run DBCC Checkdb at the low usage times, like at night or middle of the month or when you determine the lowes user...

I tried this as well and...

I really hope the driver gets updated to fix this issue, at least for Excel 2007 files. Really annoying and potential dangerous when you define an input column as...

Great question and I almost selected "reduce the amount of query activity on the system". The reason I didn't is because though this would help the performance of the...

From what I've seen, importing data from excel can be very hazardous so I avoid it whenever possible. The import process will interpret your data type by sampling the data...