Tag Archives: performance tuning

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

Implicit Conversion Performance Impact in SQL Server

Posted on May 29, 2017 by uday arumilli

Implicit Conversion Performance Impact in SQL Server This post can help you to understand Implicit Conversion Performance Impact in SQL Server. First let’s understand the implicit conversion and then we’ll see how it impacts the performance. Q. Why Conversion Required? … Continue reading →

Posted in Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , | Leave a comment

SQL Server Update Statistics Performance Impact

Posted on May 29, 2017 by uday arumilli

SQL Server Update Statistics Performance Impact The post “SQL Server Update Statistics Performance Impact” shows some interesting points on how statistics impact the query performance in SQL Server. Now before look into the impact we’ll quickly go through the essential … Continue reading →

Posted in Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , | Leave a comment