Tag Archives: statistics

How SQL Server Optimizer Calculates the Estimated Row Count

Posted on June 4, 2017 by uday arumilli

How SQL Server Optimizer Calculates the Estimated Row Count This post can help you out in understanding “How SQL Server Optimizer Calculates the Estimated Row Count”. Once query is submitted, query optimizer takes the help from Histogram (Cardinality Estimates) statistics … Continue reading →

Posted in Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , | 1 Comment

Top 40 SQL Server Performance Tuning Interview Questions

Posted on December 12, 2016 by uday arumilli

Top 40 SQL Server Performance Tuning Interview Questions SQL THE ONE There are total 254 questions are answered under SQL Server Performance Tuning category in the book “SQL THE ONE”. In this chapter we can see questions and answers on … Continue reading →

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | 7 Comments