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)
Filed under: About Me, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology