SQLAuthority News – Happy Deepavali and Happy News Year

Posted by pinaldave 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: 770

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)


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

Related posts about About Me

    Related posts about Pinal Dave