SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: June 2011

Where Do You Go for Authoritative SQL Server Best Practices?

Reprinted from my editorial in Database Weekly.

In early 2000, I started a new DBA job with a large organization, as their first full-time SQL Server DBA. My first job was to clean up the mess left by several accidental DBAs who had gone before me, and who had… Read more

2 comments, 872 reads

Posted in SQL Aloha on 27 June 2011

Do You Ever Physically Defragment Your SQL Server MDF & LDF Files?

Every since the first file was written to a floppy disk drive using DOS, physical file fragmentation has been a problem. Essentially, when the OS writes a file to a disk subsystem, and if contiguous clusters are not available, they are written elsewhere on disk. So when a file is… Read more

1 comments, 1,881 reads

Posted in SQL Aloha on 1 June 2011

June Question: How Do You Monitor Your SQL Servers?

As DBAs, one of our biggest responsibilities is to monitor our SQL Servers to ensure they are performing as expected. So, for this month’s question, “How do you monitor your SQL Servers?”, please share with us how your monitor your SQL Servers. For example, do you monitor them manually using… Read more

0 comments, 1,212 reads

Posted in SQL Aloha on 1 June 2011