Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

[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

  • No labels