Performance: Demonstration of Outdated Statistics

standard post
yigitaktan  -  
2 Comments  -  
17/04/2014

Statistics are created when Query Optimizer generates a query plan for getting a better performance. Query Optimizer uses Statistics to estimate how many rows will be returned from a query plan. You can access the statistics under the indexes folder in SSMS. Read More

Understanding Parallelism in SQL Server

standard post
yigitaktan  -  
0 Comments  -  
27/03/2014

When SQL Server runs on a server with more than one processor or CPU, it detects to use all available CPU’s during query execution. SQL Server’s max degree of parallelism (MAXDOP) configuration option controls the number of processors that are used for the execution of a query in a parallel plan. This option determines the computing and thread resources that are used for the query plan operators that perform the work in parallel Read More