Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Indexing, SARGability Rss

   Items 1 to 2 of 2   
 

SQL Server Sargability - Queries on an Indexed Table Sometimes have Slow Performance

The solution here was to slightly modify the slow queries, so the index could be fully used. We made the queries Search Argumentable, or "SARGABLE."  Read more...
By Additional Articles 2016/06/28 | Source: MSSQLTips.com | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,808 reads

Query Tuning

By Jeff Moden 2011/12/27 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,123 reads
   Items 1 to 2 of 2   
 
Tags
check constraints (1)    
implicit conversions (1)