Taking advantage of Sargability

You’ve read about Scalar-Valued functions and their RBAR(row by agonizing row) cost. You’ve also read about how combining recordsets can be costly. Now, we are going to discuss SARGability and how avoid statements that take the fun out of the seek. Searching! Seek and Destroy! Ok, so we’re not going to seek and destroy, but Read more about Taking advantage of Sargability[…]