It would still help to see an execution plan.

First, you don't have a where clause, so you're returing all the data from all the tables (not counting the DISTINCT statement, which, we'll get to). This will pretty much...

It's probably doing a table scan, which will certainly cause a lot of reads. Are there any triggers on the table? Is that field a part of a primary or...

The Books Onliine are usually part of the client install, although you can choose to not install them.

They're also available online at Microsoft:

http://msdn.microsoft.com/en-us/library/ms130214.aspx

OK. That was more helpful.

Well, for a select from the key and the key only, A would probably be faster than B. However, as soon as you decide you want...

I would guess that I've seen data corruption about twice a year for... quite a while. That includes development and QA systems where silly and crazy stuff occurs just a...

I agree with Jack. You're just not going to be able to learn things in a detailed way that you don't work with daily.

That said, you should have a good...

Execution plans so we can understand which indexes are used, not used, etc., would be very helpful.

The only thing I'd add to the "must have" list is:

a method for monitoring performance

a process for updating structures/code/procedures based on...

How many rows are in the table and how wide are they? If the data can fit on only a few pages, you're probably looking at maximum defrag now.

I'd have to see an execution plan for the good execution and one from the bad execution to even make a guess as to what's going on.

As to the locking,...

You'll get the joins between tables because of the referential integrity checks that are a necessary part of any delete. However, putting an index on a column like DeleteId will...

The principal difference between the two is that the inline table valued function can be built with a parameter where a view cannot. Most of the time, but not all...

It sounds like you're debating normalized vs. denormalized data.

For very simple select statements that don't involve much in the way of filtering, but simply pull data based on a key...

No kidding, drop the grenade & run...

They could be doing something silly with reseed?