Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Desiree Harris

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Indexes: An Overview and Maintenance for Performance

SQL Server for the most part will maintain itself, updating statistics, choosing optimal query plans, and requiring minimal maintenance to keep running. However to optain optimum performance, a real DBA needs to spend some time checking and tuning indexes, rebuilding them as fillfactors change. This new article from Desiree Harris looks at how you can perform some of these tasks to keep your server performing at the optimum level.   Read more...
By Desiree Harris 2004/12/30 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 12,698 reads

Sending SQL Notifications with CDOSYS

SQL Server has a nice alert system, but SQLMail leaves something to be desired. New author Desiree Harris, from hosting provider Orcsweb, looks at an alternative method for sending alerts using an SMTP server and without requiring Outlook to be installed.   Read more...
By Desiree Harris 2004/09/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,252 reads
   Items 1 to 2 of 2