SQL Server vNext (aka 2017) CTP2 Includes Python Scripting

More Analytic Excitement in SQL Server 2017 Last week (the third week in April 2017) Microsoft released its Community Technology Preview 2.0 for SQL Server vNext, more often referred to as simply “SQL Server 2017”. Among the many new features of interest to business intelligence analysts, data scientists, and machine learning aficionados is support for […]
Read More ›

Subqueries, Real and Apparent

Part III – A Look at a “Physical” Subquery Perhaps I am being a little loose in my terminology, since there really isn’t a query operator called “subquery”. When I say “physical subquery” I am referring to those correlated subqueries where the subquery portion must be executed again and again, once for every row returned […]
Read More ›

Subqueries, Real and Apparent

Part II – The Table Spool In the previous installment, we looked at a very simple logical subquery that SQL Server executed as a physical join. We shall now take a look at a somewhat more complicated query and see what SQL Server does with it. In this query, we would like to get a […]
Read More ›

Subqueries, Real and Apparent

As a part of our continuing study of SQL Server query plans, we’re going to take a look at some subqueries. This is particularly important, since subqueries are the subject of some fair amount of folklore, and it is important to separate fact from myth. It’s not uncommon to hear someone say “Joins are better […]
Read More ›

SQL Server: Some Quirks in the Cache, Part II

Some Surprising Traits of SQL Server Query Caching In the previous section<link SQL Server: Some Quirks In the Cache Part 1>, we saw that it is easy to observe query execution plans being entered into the procedure cache by SQL Server. Now that the tools are in place, we will observe some unexpected behavior of […]
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.