Also:

DECLARE @Table

TABLE (

col1 INTEGER NOT NULL,

col2 ...

There's a good explanation of the issues in the following Knowledge Base article:

http://support.microsoft.com/kb/263889

tacy.highland (5/19/2010)

---

Excellent! Thank you! It's making more and more sense. Yet, there's so much more for me to learn...Since I'm picking up so many great things from you, I...

As far as I can remember, this will work in SQL Server 2000. I don't have it installed any more, so no guarantees!

DECLARE @Sample

TABLE (

...

tacy.highland (5/19/2010)

---

So, tell me if I'm getting this right: I'd use the Booking/ldate as a derived table due to the fact that the WHERE clause has to parse out the...

Demonstrating the derived table:

SELECT C.ClientId,

C.ClientCode,

C.LastName

C.FirstName,

...

:blink: :blink: :blink: :blink: :blink:

😀

tacy.highland (5/19/2010)

---

Thank you Paul! Very interesting and very well explained. It seems my suspicions were justified. I guess it does make some kind of sense to have...

On the question of statistics:

These seem pretty good to me, in general, with one exception: the optimiser does not have good information about the correlation of SchId with LDate. ...

tacy.highland (5/18/2010)

---

Same exact queries, only Query1 runs 1 second and has 2 columns which happen to be primary keys on the Events table, Query2 runs 20 seconds and does not...

Awesome :doze:

That sort on SchID is an optimisation for sequential I/O.

Look at the loop join after the sort operator - the clustered...

DECLARE @Sample

TABLE (

ID INTEGER NOT NULL PRIMARY...

One way is via the Help menu in SSMS.

Another is the Error and Usage Report Setting application in the Configuration Tools sub group of the Microsoft SQL Server program folder.

No worries. Good luck!