on SQL Authority
See other posts from SQL Authority
or by pinaldave
Published on Tue, 13 Nov 2012 01:30:57 +0000 Indexed on 2012/11/13 5:06 UTC
Read the original article Hit count: 553
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
© SQL Authority or respective owner