In the StackOverflow2013 database all users with the DisplayName not equal to ‘alex’ are update with a long location. SQL Server has to fit the data on pages and shuffles data around.
If we do not care about the exact value of the number of records with the DisplayName of ‘alex’ it is 3509 or 3507 or 3503… who cares anyway… but if this a stock values or a financial value .. oeps… use RCSI?
Thank you for the demo Brent Ozar in Veenendaal in the year 2019.
You are free to:
- Share – copy and redistribute the material in any medium or format
- Adapt – remix, transform, and build upon the material for any purpose, even
commercially
Under the following terms:
- Attribution – You must give appropriate credit, provide a link to the license,
and indicate if changes were made. - ShareAlike – If you remix, transform, or build upon the material, you must
distribute your contributions under the same license as the original.