Did You Know? Forcing a nonclustered index scan to avoid sorting

(Kalen Delaney) Hopefully, if you know enough about SQL Server to understand most of my posts here, you’re aware of the fact that using a nonclustered index is not always an optimal choice for accessing data, particularly if there are thousands (or more) rows of data you need to retrieve. However,

Read More - Register for Free Membership