...
[11:29:37 CDT(-0500)] <dmccallum54> that's from our Wins CI db
[11:30:27 CDT(-0500)] <dmccallum54> if that's true, then the only reason we'd need derived columns in SQLServer would be if the application or the views will generate lower() queries and that would cause SQLServer to skip indexes