October 8, 2019 at 12:00 am
Comments posted to this topic are about the item Indexing A Numeric Computed Column
October 8, 2019 at 8:16 am
Nice question, thanks Steve. i like the red herrings....
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
October 8, 2019 at 12:53 pm
Good question. I am curious though why would somebody think this wouldn't work.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 8, 2019 at 2:55 pm
I've run into people that were sure you couldn't index unless this was persisted.
October 9, 2019 at 8:53 am
I've run into people that were sure you couldn't index unless this was persisted.
used to work with one - he would always reject code reviews where were indexes created on computed columns unless said column was persisted....
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply