Troubleshooting a SQL Server Implicit Conversion Issue
Over the last couple of weeks, I have been spending some time troubleshooting performance issues in some of our Java-based RESTful services. This week I came across one that required some different steps to troubleshoot. First, the tl;dr – our JDBC driver (jTDS) converts CHAR to NCHAR, which causes an index SCAN on a CHAR …
Troubleshooting a SQL Server Implicit Conversion Issue Read More »