SQLAuthority News – Happy Deepavali and Happy New Year

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.

SQLAuthority News - Happy Deepavali and Happy New Year diwaliphoto3

SQLAuthority News - Happy Deepavali and Happy New Year diwaliphoto1

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 (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Get Free Books on While Learning SQL Server 2012 Error Handling
Next Post
SQL SERVER – Concurrency Basics – Guest Post by Vinod Kumar

Related Posts

No results found.

4 Comments. Leave new

Leave a Reply

Menu