Month: September 2013

Best Practice No.37

Check Database consistency at-least once every month. Related posts: Best Practice No.5 Best Practice No.6 Best Practice No.22 Best Practice No.11 Best Practice No.25

Best Practice No.36

Do proper capacity planning for the growth of your Transaction log file and size them accordingly – don’t leave it to Auto-grow on default setting to avoid performance hit. Transaction Log files cannot take advantage of Instant File Initialization. Related posts: SQL Tip-3 | Don’t Shrink your Database Best Practice No.5 Best Practice No.6 Best …

Best Practice No.35

In your backup strategy avoid taking daily backups of your read-only databases, monthly full backup is more than enough. Related posts: Best Practice No.20 Best Practice No.14 Best Practice No.6 Best Practice No.33 Best Practice No.18

SQLServer Day 14th September 2013 | Gurgaon

Hi Friends, cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And this time we are coming to two cities in India; Gurgaon & Hyderabad. This is yet another opportunity to learn. The Sessions are Troubleshooting Deadlocks, How to use SQLDiag and SQL Nexus, Hekaton (In-Memory) Database SQL …