SQL Server Data Type Precedence

Posted on SQL Server Central See other posts from SQL Server Central
Published on Tue, 04 Sep 2012 06:00:00 UT Indexed on 2012/09/06 9:45 UTC
Read the original article Hit count: 169

Filed under:

I am executing a simple query/stored procedure from my application against a large table and it's taking a long time to execute. The column I'm using in my WHERE clause is indexed and it's very selective. The search column is not wrapped in a function so that's not the issue. What could be going wrong?

Cloud Services Schedule Azure backups
Red Gate’s Cloud Services makes it simple to create and schedule backups of your SQL Azure databases to Azure blob storage or Amazon S3. Try it for free today.

© SQL Server Central or respective owner