Tag Info

correct not necessarily - it depends on whether a suitable index exists and whether the CBO decides to use it. For example if the table is small or the the statistics lead the optimizer to believe that the filter will be true for a large percentage of the results, it may consider the cost of a FTS to be lower this is not guaranteed - it is even possible ...

Jack's right, so I won't repeat that. I'll just add some articles I kind of like regarding sargability of an expression: Sargability: Why %string% Is Slow - by (my all time favorite) Brent Ozar Low-Hanging Fruit of Sargable Expressions - by Dan Guzman SQL Server Transact-SQL WHERE - by Brad McGehee Sargable Predicates - by Jeff Wharton Indexing for ORs - ...

I'm not 100% sure about LINQ but i would say that the seperation is based on transaction control. You apply any number of updates, inserts or deletes. That are then held as a unit of work, then once you've finished your changes you simply commit them to the database as a single action or roll all of the changes back, maintaining the integrity of your ...