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.

• Get FREE Books by Sign up for tomorrow’s webcast by Rick Morelan
• Watch SQL in Sixty Seconds Series – FREE SQL Learning
• Read my earlier 2300+ articles

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)