I have been in developer’s shoes for close to 5+ years before reinventing myself to do things that made me even better in coding. It is a tough challenge these days being a developer. 453 more words
Tags » SQL Performance
Just last week, I moderated a SQL Server interview and I heard very interesting conversation.
Question – What are the best practices are you following for SQL Server? 754 more words
Troubleshooting SQL Server is something almost every single DBA has to go through in their lifespan. It sounds simple and often we are clueless on where to start. 515 more words
Don’t run sp_updatestats after rebuilding your indexes. The sp_updatestats will use the default sample and you could end up with less accurate stats post sp_updatestats than you had after your index rebuild. 246 more words