Tags » SQL Performance

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

Improve SQL Network Performance

Need to improve your SQL Network Performance?

  • Disable LLMNR – Clients and Server (Click enable)
  • Adapter settings¬†adjustment to match registry entry- RSS (below)
    • Disable all but Flow Control and RSS settings – match registry entries for RSS…
  • 227 more words