SQL Server 2019: Can Dr. Froid Help Your User Defined Functions?

User-defined scalar functions (scalar UDFs) provide SQL Server developers with an excellent means to organizer and re-use code. Unfortunately, these benefits often come at the price of poor, and in many cases horrendous, performance. Froid is a technology arising from Microsoft Research that addresses these performance problems with novel optimization techniques. In SQL Server 2019, […]
Read More ›

Exploring SQL Server CPU Usage with Xperf

In previous blogs, we took a look at how to install Xperf, and how to use it to look at file I/O. For SQL Server administrators, a potentially important use of Xperf is to examine the consumption of CPU cycles, particularly when tools like the performance counters are showing high CPU use, but the reason […]
Read More ›


SQL Server 2016 enables the creation of natively compiled user-defined functions (UDFs). Since natively compiled UDFs can be used anywhere a function written in TSQL can be used, many people assumed that this would provide an easy route to faster functions. This is not quite the case. Some people even wrote compiled functions that called […]
Read More ›

SQL Server 2014 New Features: Cardinality Estimation in the Query Optimizer

Is it Better or Worse? What is Cardinality Estimation A fancy-sounding phrase, “cardinality estimation” basically means “guessing how many”. The ability of the query optimizer to select a superior query plan from among many possibilities requires the estimation of how many rows will be extracted from the participating tables and how these rows will be […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.