SQLAuthority News – Happy Deepavali and Happy New Year

Diwali or Deepavali is popularly known as the festival of lights. It literally means “array of light” or “row of lamps“. Today we build a small clay maps and fill it with oil and light it up. The significance of lighting the lamp is the triumph of good over evil. I work every single day in a year but today I am spending my time with family and little one. I make sure that my daughter is aware of our culture and she learns to celebrate the festival with the same passion and values which I have.

Every year on this day, I do not write a long blog post but rather write a small post with various SQL Tips and Tricks. After reading them you should quickly get back to your friends and family – it is the most important festival day.

Here are a few tips and tricks:

  • Take regular full backup of your database
  • Avoid cursors if they can be replaced by set based process
  • Keep your index maintenance script handy and execute them at intervals
  • Consider Solid State Drive (SDD) for crucial database and tempdb placement
  • Update statistics for OLTP transactions at intervals

I guess that’s it for today. If you still have more time to learn. Here are few things you should consider.

Well, I am sure that will keep you busy for the rest of the day!

Happy Diwali to All of You!

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

About these ads

4 thoughts on “SQLAuthority News – Happy Deepavali and Happy New Year

  1. You mention that “Keep your index maintenance script handy and execute them at intervals”. Have you previously written about such handy index maintenance scripts. If yes then i have not found them during google and sqlauthority custom search. I would appreciate if you give some links to study on them.

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