When your users insist on running functions like LTRIM/RTRIM/UPPER/etc, but can’t store that data in the database, you should check out computed columns. Demo script: Transact-SQL /* COMPUTED COLUMNS v1.1 – 2019-04-09 Here’s what you’re going to learn in this demo: * How to get better estimates on single-table calculations * Why you don’t need…
18 – Computed Columns (14m)
When your users insist on running functions like LTRIM/RTRIM/UPPER/etc, but can’t store that data in the database, you should check out computed columns. Demo script: Transact-SQL /* COMPUTED COLUMNS v1.1 - 2019-04-09 Here's what you're going to learn in this demo: * How to get better estimates on single-table calculations * Why you don't need...
To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.
- 01 – How NOLOCK Can Show Incorrect Results (10m)
- 02 – Locking and Blocking (29m)
- 03 – Deadlocks (18m)
- 04 – Trivial Plans (17m)
- 05 – Picking Index Key Order (34m)
- 06 – Missing Index Column Order (21m)
- 07 – Execution Plans are Lying Liars (24m)
- 08 – Estimates vs Actuals (48m)
- 09 – Table Variables vs Temp Tables: The 2019 Rematch (10m)
- 10 – How Plans Are Cached (10m)
- 11 – Parameter Sniffing (19m)
- 12 – The Problem with Multi-Parameter Stored Procedures (21m)
- 13 – Dynamic SQL Pro Tips (34m)
- 14 – Parallelism (38m)
- 15 – Simplification (14m)
- 16 – Filtered Indexes (23m)
- 17 – Indexed Views (22m)
- 19 – Heaps of Sadness (11m)
- 20 – Index Usage DMVs are Lying Liars (26m)
- 21 – Resource Semaphore (37m)
- 22 – Questions (17m)
- Bonus – Building a Fork Bomb in T-SQL (11m)
- Bonus – Managed Instance DTUs (4m)
- Bonus – Memory Usage by Different Operators (15m)
- Bonus: Numbers Tables (18m)