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 (https://blog.sqlauthority.com)
4 Comments. Leave new
Happy Diwali, Pinal!
Happy Diwali Pinal….
Happy Diwali……….
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.