Tags » SQL Performance

SQL SERVER - Script: Finding queries without JOIN Predicates

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

SQL Authority

Interview Question of the Week #028 - Few SQL Best Practices

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

SQL Authority

SQL SERVER - Querying Performance Counters from SQL Server

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

SQL Authority

Why you shouldn't run sp_updatestats after you rebuild your indexes

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

Sql Server

Tips to Improve SQL Performance

An experienced business analyst and former Cleveland resident, Abhishek Dutta has served with a number of financial companies, including Emigrant Bancorp and Freddie Mac, during his 10-year career. 248 more words

Abhishek Dutta