Product has been added to your cart.

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.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Performance Tuning in 21 Demos
  7. 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.