Presentation Materials: The APPLY Operator
Abstract
The APPLY operator was introduced with SQL Server 2005. It is an extension to the SQL Standard with the main purpose to allow us to join to a table valued function. But there is more to discover...
In this talk I am going to introduce this SQL operator and show how it can be used. After attending you will be able to write your own queries that utilize this powerful SQL Server only extension to the SQL Standard. You will also see how some queries might be re-written without it. Finally, the closing real world examples show queries that you can take home and immediately use in your own environment.
Prerequisites
This is a 100 level No-Slide-Demo-Only talk. To get the most out of it you should feel comfortable using the INSERT, UPDATE and DELETE statements and write simple join queries.
Downloads
Newsletter Sign Up
We know how to make a database fast. We’ll help you do the same.
From the sqlity.net blog
-
How to identify the SQL Server Service Account in T-SQL
-
How to Change a SQL Login’s Password
-
Hash Algorithms – How does SQL Server store Passwords?
-
How to Re-Create a Login with only a Hashed Password
-
B+Trees – How SQL Server Indexes are Stored on Disk
-
The Hidden SQL Server Gem: UPDATE from SELECT
-
A Join A Day – Nested Joins
-
Determine the Uptime of a SQL Server Instance
-
A Join A Day – The Left Anti Semi Join
-
Log Reuse Waits Explained: LOG_BACKUP
