Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by bg716
-
LIKE in where won't use Indexes??
Indexes are not used when there is an ineqality, like operator and searching for null in a record set. This goes to the nature of an index which puts a feild in sorted order and when the value is found the engine knows it can stop searching. With the conditions given above it makes sence that an...- bg716
- Post #5
- Forum: Microsoft SQL Server: Programming
