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: 183
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?
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