Tag Info

New answers tagged

3

In this context, you should consider "hotfix" to mean any fix that ended up in a Service Pack, Cumulative Update, or on-demand hotfix and falls under the jurisdiction of this trace flag. These fixes are all in the most recent builds of each major supported version, but they are not used unless the trace flag is turned on. This is because, in some cases, the ...


9

I guess you are comparing the estimated costs for the queries. Those are just estimates based on (among other things) the estimated number of rows returned by the query. Not the actual number of rows. Your first query estimated that it would return 30 rows and your second query estimated 1000 rows. That is where your difference in query cost comes from. If ...



Top 50 recent answers are included