MS SQL New functions, syntaxes, tips & tricks
summary
Lists actual new T-SQL features: STRING_SPLIT single-char only (preserves empty fragments, beats XML splitter in tests: ~31ms vs ~60ms and far fewer logical reads), STRING_AGG with WITHIN GROUP (faster than XML method: ~63ms vs ~234ms, needs VARCHAR(MAX) for long results), STRING_ESCAPE/FORMATMESSAGE/TRIM/TRANSLATE/CONCAT_WS behavior notes, UTF‑8 collations (saves space for Cyrillic), improved truncation error now reports table/column/value, and COMPRESS/DECOMPRESS (good for large XML: 156MB→80MB, but inflates tiny strings and makes reads ~10x slower).
AI-written summary · about
chapters (12)
- 0:00Start
- 16:55generate drop statements for all tables in your database
- 18:52aggregate strings
- 21:28aggregate by using the space between these letters
- 22:40using the string aggregate with aggregating and virtual max
- 24:20aggregate the invoice id
- 26:34replace some character with an empty string
- 29:00concatenate the same drop statements for every table in the databases
- 35:09supports utf-8 collation
- 39:44compress and decompress
- 42:34show you the compartment between row and page compression
- 46:15look at the execution plan
related talks
49mHidden Gems in SQL Server 2022 Database Engine- 49mHidden Gems in SQL Server 2022 Database Engine
48mSQL Server 2022 hidden gems
20mStoring strings in SQL Server and Azure SQL DB
56mExciting new features in SQL Server for developers
52mWriting T-SQL code for the engine, not for you "more demos" by popular demand- 52mWriting T-SQL code for the engine, not for you "more demos" by popular demand
- 52mWriting T-SQL code for the engine, not for you "more demos" by popular demand