SQLAuthority News – Author’s Birthday – 5 SQL Server Best Practices

Today is my birthday. For those who are curious, I have now completed 31 years in my life. I have learned lots of new things during the course of the past few years. Every year I feel that I am getting better as a human being. Since today is my birthday, I have decided NOT to work and NOT to blog. I will do something really fun!

I am going to clean up my personal servers as well and finish a few tests, as well as complete my benchmark projects. My personal data is also stored in one gigantic database. Because it is my personal server, no one pays me and thus I hardly maintain it.

Today I am going to do the following maintenance tasks on it:

  1. Backup Master. I am going to have a backup of the database using script; however, the backup script has not been updated for a long time now. Last time, I noticed that I was not getting the master database’s backup. And no matter what one suggests, I still think it is very important to have a backup of the master database. I am going to alter the script to have a correct backup of the master database.
  2. Online Indexing. I have upgraded my server from SQL Server 2005 Standard to SQL Server 2008 Enterprise. On the other hand, I never changed the index rebuilding script. One of the tables is very huge and when indexes are rebuilt in it, it often gets broken. I plan to change the index rebuild script to include the option of (ONLINE = ON). This will be good to avoid the time outs.
  3. Restarting the Server. I have the server connected to UPS and even though we have lots of very short power outages, my server is not affected, fortunately. I almost forgot when I really restarted it. Although, it is not necessary to restart server at all, this procedure is intended for my windows box, which has many updates installed but I have not rebooted it in order for these updates to take effect. This may not be the best technique, but it works enough for me because my data is not that critical. If you are maintaining a high-availability solution, I suggest that you have fail over solution implemented before restarting the server.
  4. Wait Stats. I recently learned about Wait stats. I am eager to know what Wait Statistics really are, and what they can do for my server. Due to the fact that I have not upgraded the hardware for many years now (although I have upgraded the OS, SQL Server version and huge data growth), I could find out which of my hardware needs an upgrade.
  5. Fresh Air. I will make sure that after all of the above tasks are completed I am going to go out with my family and breathe some fresh air.

Reference: Pinal Dave (http://blog.sqlauthority.com)

55 thoughts on “SQLAuthority News – Author’s Birthday – 5 SQL Server Best Practices

  1. Hi Pinal,

    Many Many Happy Returns of the day

    On your birthday I wish you much pleasure and joy;
    I hope all of your wishes come true.
    May each hour and minute be filled with delight,
    And your birthday be perfect for you!

    Thanks
    Manish

    Like

  2. Good Morning Champ!!!! Many Many happy returns of the day!!! have wonderful & memorable moment today with your family and of course with a friend (like me)…….

    BTW, the cake you saw us here, is really ready at your home… kindly let me know so I can stop by your home :)

    Like

  3. Hi Pinal,

    How are you?

    I am very Happy to know your Birthday..

    Wish u Happy Birthday to you..

    I got my Bday wishes from you @ CSSUG Events on July 17th


    Kalyan, Chennai

    Like

  4. Happy birth day ! Pinal….

    Wishing all success ………….

    Regards and best wishes……………..
    Pravin Patel……….

    Like

  5. MANY HAPPY RETURNS OF THE DAY PINAL. May you achieve more and more success and contribute to the SQL Server community. It is always enlightening going through your blogs and site.

    Like

  6. Hey Pinal !!!

    wish you many many happy returns of the day….May you keep making progress in all aspects of your life.

    God Bless you:-)

    Like

  7. Regarding the backup – make sure you also test the back up and also make sure that the resource database is backed up as well.
    Regarding the ONLINE rebuild – you can get a script which automatically determines the edition and does the ONLINE rebuild for you.
    Regarding the wait stats – the best thing to do is to actually “dump” DMV data about wait statistics to a database ever our, lets say, and then analyze the data for a period of time.
    Also, keep track of the file stats, stalls, etc.
    Fresh air is important, as well as good food and especially good desert. :) Make sure you get some GOOD cake on your Birthday.

    Happy Birthday!

    Like

  8. Hi Pinal,

    Count your life by smiles, not tears.
    May all your dreams and wishes come true coming years.

    Happy Birth day Sir.

    Wishing you a happy and prosperous birthday ………:-)

    Suhas R. Kudekar
    Pune

    Like

  9. Hi Pinal,

    Happy Birthday to DB Expert.

    Congrats for all your achievments.

    All the best for your new achievement in this year.

    Have a Great (B)Day

    -Devaraj Diraviyam
    Mumbai

    Like

  10. Hi Pinal,

    Many Many Happy Returns of the day,Have a great year ahead.

    You are one of the persons who makes me think on how to move forward when it comes to career terms and I greatly appreciate all your hardwork to make this blog stunning.

    Cheers,
    Anup

    Like

  11. Hello Pinal,

    Belated Happy Birthday.
    May your all dreams come true!!!

    You are one of great persons on the earth, who is pouring his knowledge to improve this generation

    With great regards
    Anurodh Srivastava

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s