Cardinality Estimation is one of the hidden gems in SQL Server. In general, Cardinality Estimation means that the Query Optimizer tries to find out during the query compilation, how many rows – on average – are returned from the various operators in the Execution Plan. This estimation is used to drive the plan generation itself …
Fixing Cardinality Estimation Errors with Filtered Statistics + read more
Over the next weeks and months I have a lot of various speaking engagements where I’m talking about various aspects of SQL Server Performance Tuning & Troubleshooting. SQLSaturday #258, Istanbul/Turkey, October 5 It’s the first time that I’m in Istanbul, and even in Turkey, so I’m really looking forward to this event. I’m presenting here my …
Do you have enough from watching online Web Casts about SQL Server with a bad video quality? Do you have enough from looking a whole hour on a massive amount of PowerPoint slides? Do you have enough by just hearing the presenter in the background through a bad audio quality? Do you want to attend …
People are sometimes asking me, how to become a better, well-rounded SQL Server DBA. Of course, the first reason with which I’m responding is “Experience, Experience, Experience”. Nothing helps you more than a daily experience with SQL Server. But on the other hand you also need to know how SQL Server works internally, how you …
How to become a better, well-rounded SQL Server DBA + read more
My complete last week was dedicated to XTP (Extreme Transaction Processing), better known as Hekaton, that is introduced with SQL Server 2014. My main goal of the week was to get a better understanding of Hekaton, the current limitations, and the scalability of this amazing new In-Memory technology. This blog posting covers the following things …
Extreme Transaction Processing (XTP, Hekaton) – the solution to everything? + read more
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
