Reasons Why You May Not Want to Use a Heap
Indexing, Performance Tuning | February 27, 2009 | 4:41 pmI have started compiling a list of reasons why heaps aren’t usually a good choice when designing a database. Now, I didn’t say that heaps are always bad, but in most cases, I think they should be avoided (read the list to see why).
As I compiled the list, in some cases I have had the ...read more
Do You Verify Your Database Backups?
Database Administration, Database Maintenance, Opinion | February 24, 2009 | 12:47 pmIn the past, I have written and spoken a lot about SQL Server “best practices”. One that I emphasize over and over again is the need for DBAs to verify, regularly, the integrity of their database backups. However, I sometimes feel my advice is falling on deaf ears. When giving a presentation, I often ask ...read more
Do You Run Antivirus Software on Your SQL Servers?
Database Administration, Opinion | February 9, 2009 | 12:49 pmI have been to some IT departments where the standard procedure is to install antivirus/antispyware software on all servers, no matter what applications are running on it. In addition, the default settings are left untouched, which means that virtually every byte of data is examined, in real time, before it is read or written to ...read more
