[11:29:08 CDT(-0500)] <dmccallum54> TonyUnicon re SQLServer case (in)sensitivity
[11:29:20 CDT(-0500)] <dmccallum54> – B2D05919-5056-A51A-80BD-03E5288DE771, CAP
[11:29:20 CDT(-0500)] <dmccallum54> select top 1 id, name from student_type
[11:29:20 CDT(-0500)] <dmccallum54> – B2D05919-5056-A51A-80BD-03E5288DE771
[11:29:20 CDT(-0500)] <dmccallum54> select id from student_type where name = 'cap'
[11:29:20 CDT(-0500)] <dmccallum54> – B2D05919-5056-A51A-80BD-03E5288DE771
[11:29:21 CDT(-0500)] <dmccallum54> select id from student_type where name = 'CAP'
[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
[11:33:20 CDT(-0500)] <dmccallum54> jumping on the phone for another call...
[11:33:25 CDT(-0500)] <TonyUnicon> yep
[14:27:27 CDT(-0500)] <TonyUnicon> Paul, just to finish our conversation from this morning
[14:27:30 CDT(-0500)] <TonyUnicon> I was going to mention
[14:27:44 CDT(-0500)] <TonyUnicon> that there is an unusually large amount of Wisconsonites here in Colorado
[14:27:49 CDT(-0500)] <TonyUnicon> so packer fans are everywhere
[14:28:09 CDT(-0500)] <TonyUnicon> I'm convinced there are more people born in Wisconsin living outside the state
[14:28:11 CDT(-0500)] <TonyUnicon> than inside