I also think it's 2008, although it doesn't say that in the properties window. But that's when the machine is from.

That is one of the things I am wondering, if...

• This reply was modified 6 years, 10 months ago by pdanes.

Ah, that looks useful. Thank you.

Good call - that works well. With the index on ID disabled, it is roughly a minute, the same as the original 'bad' version. But with the SSMS-suggested index in...

Grant: "The other is the need to filter after the XML is put together."

Do you mean that it materializes the ENTIRE resultset into one giant XML construct, and then checks...

• This reply was modified 6 years, 11 months ago by pdanes.

I'm still unclear about something, though. Grant, you wrote "...all it takes is a single match and EXISTS stops executing...", which is exactly what I thought EXISTS does, which is...

Thank you both for looking at this. Another spanking for me by SQL Server - what else is new? But it's not going to be that much work to make...

1+ seconds for such a thing is not "quickly" nor resource friendly IMHO

True, one second is not great, but for my purposes, in this application, it was good enough -...

Thanks, that explains it. I thought, as you write, that the engine would evaluate the inner select individually, then apply the outer If Exists. But if it's generating an entire...

Certainly, this is not a model of efficiency - I wrote that myself in the initial post.

However, the entire view (either a single "1" or an empty recordset) is materialized...

I looked at the execution plans, and of course, they are different, but I'm not that good at reading them. Or more properly, I can read them okay, but understanding...

Would that have the same effect as what I'm doing? I have studied backup manuals and online tutorials until I'm blue in the face, but I'm still a little vague...

I realize this is a very old thread, but people do read archived posts for information, so I'm going to add my two cents worth. Adjust for inflation as necessary.

Just the schema, then I put object like views and stored procedures into the schema.

Aha. It may be that -I- was able to write to read-only schema, since I have dbo permission on my login. I thought that the more restrictive permission would apply,...

Hm, now I'm really curious. Thanks for the explanation, although I'm still a litttle fuzzy on the details. However, my system is running well enough, so I can afford to...