Articoli

Approfondimenti tecnici e articoli di riferimento su SQL Server e Data Platform, con estensioni su Azure, analytics/BI e Data Engineering. Qui trovi guide operative, best practice, analisi e casi reali dalla community UGISS, pensati per essere utili anche a distanza di tempo.

Articolo in due parti di Itzik Ben-Gan che analizza in dettaglio diverse tecniche per identificare sequenze all’interno di altre sequenze in T-SQL.

Microsoft Virtual Accademy ha pubblicato un bel webcast fatto da Itzik Ben-Gan dedicato all’uso dell’operatore APPLY, estremamente potente e tipicamente poco utilizzato. Di seguito il link:

“Boost Your T-SQL with the APPLY Operator”

Need creative solutions to T-SQL issues? Get them from Itzik Ben-Gan, one of the world’s foremost authorities, along with Microsoft Program Manager Umachandar Jayachandran. These experts demonstrate the APPLY operator, a T-SQL feature that can be used to solve a wide variety of problems. What’s especially interesting about APPLY is how it can be used in conjunction with many T-SQL features. To demonstrate this aspect of APPLY, the session tracks the operator through time, discussing features that were initially introduced in different versions of SQL Server (7.0, like TOP, through 2012, like OFFSET-FETCH), some of which are widely used today. For each feature, the session describes its shortcomings and then shows how to use APPLY to overcome it and to improve the feature.