Fundamentals of Table Expressions, Part 13 – Inline Table-Valued Functions, Continued Itzik Ben-Gan concludes his series on table expressions in SQL Server, explaining more internals of inline table-valued functions. Itzik Ben-Gan ◆ November 10, 2021 2
Fundamentals of Table Expressions, Part 12 – Inline Table-Valued Functions Itzik Ben-Gan continues his blog series on table expressions in SQL Server, this time digging into inline table-valued functions (iTVFs). Itzik Ben-Gan ◆ October 13, 2021 4
Fundamentals of Table Expressions, Part 11 – Views, Modification Considerations Itzik Ben-Gan returns to his table expressions series, covering what you need to think about when using a view to modify its underlying table(s). Itzik Ben-Gan ◆ September 8, 2021 0
Split strings the right way – or the next best way Aaron Bertrand (@AaronBertrand) explores some common approaches people use to split strings, complete with performance analysis. Aaron Bertrand ◆ September 2, 2021 25
Bucketizing date and time data Itzik Ben-Gan shows us a new function in Azure SQL Edge, DATE_BUCKET, explains some use cases, and gives us alternative syntax until it is supported in all SQL Server platforms. Itzik Ben-Gan ◆ August 11, 2021 8
Fundamentals of table expressions, Part 10 – Views, SELECT *, and DDL changes Continuing his series on table expressions, Itzik Ben-Gan explains why it is a bad idea to use SELECT * in views. Itzik Ben-Gan ◆ July 14, 2021 0
Fundamentals of table expressions, Part 9 – Views, compared with derived tables and CTEs Itzik resumes his series on table expression fundamentals, this time comparing views to CTEs and derived tables. Itzik Ben-Gan ◆ June 9, 2021 2
Number series generator challenge solutions – Part 5 Itzik closes out his series exploring user-submitted functions for the number generator challenge, with two recommended solutions. Itzik Ben-Gan ◆ May 12, 2021 8
Number series generator challenge solutions – Part 4 Itzik Ben-Gan continues collaborating with readers to squeeze every ounce of performance out of a number series generator function. Itzik Ben-Gan ◆ April 14, 2021 13
Number series generator challenge solutions – Part 3 Itzik Ben-Gan continues working with several readers to squeeze all the performance he can out of a number series generator. Itzik Ben-Gan ◆ March 10, 2021 10
Number series generator challenge solutions – Part 2 Itzik Ben-Gan digs deeper into reader submissions to a recent challenge for an efficient number series generator. Itzik Ben-Gan ◆ February 10, 2021 13
