sqlugb

SQL Server UG Belgrade is Now an Offical SQL PASS Chapter

Very pleased to shared with you the info that SQL UG Belgrade is now an official PASS Chapter! Cogratulations to the user group leaders Goran Milanov and Dragoslav Ogar and  all SQL UG Serbia … [Read More...]

Figure7_1

New Cardinality Estimator Part 7 – Single Table, Multiple Predicates and Trace Flags

This week I have got a question regarding my post New Cardinality Estimator Part 4 – Single Table and Multiple Predicates. The question was about possibilities to affect the estimation with multiple … [Read More...]

Figure7_1

New Cardinality Estimator Part 7 – Single Table, Multiple Predicates and Trace Flags

This week I have got a question regarding my post New Cardinality Estimator Part 4 – Single Table and Multiple Predicates. The question was about possibilities to affect the estimation with multiple … [Read More...]

RECENT ARTICLES

Figure7_1

New Cardinality Estimator Part 7 – Single Table, Multiple Predicates and Trace Flags

This week I have got a question regarding my post New Cardinality Estimator Part 4 – Single Table and Multiple Predicates. The question was about possibilities to affect the estimation with multiple … [Read More...]

t6

New Cardinality Estimator Part 6 – Simple JOIN And Foreign Key

In this article we will check if PK-FK relationship is respected by new cardinality optimizer in case of a simple JOIN with tables in the mentioned relation. The old CE did not meet expectations, we … [Read More...]

Figure5_1

New Cardinality Estimator Part 5 – Bug?

In this article I will describe a case which is not properly handled by the new cardinality estimator, introduced in SQL Server 2014 CTP2. The discrepancy between estimated and actual values is … [Read More...]

Figure4_17

New Cardinality Estimator Part 4 – Single Table and Multiple Predicates

In this article I will explore changes in new CE related to column correlation. As mentioned in my first article about new CE, this change is announced in the paper Testing Cardinality Estimation … [Read More...]

Figure2_2

New Cardinality Estimator Part 3 – Single Table And One Predicate

In this article I will try to find out is there any change in cardinality estimation in a very simple case of querying a single table with a single predicate with the equal operator (i.e. SELECT * … [Read More...]

More Articles

Follow

Get every new post delivered to your Inbox.