Hi Markus, First of all thanks for providing such a nice study material. It will be helpful if you provide some details of sql memory management and Few examples of complex explain plans like one including HASH JOINS,MERGE JOINS, ITERATOR.

Thanks Anurag

asked Dec 07 '10 at 01:39

SqlExpert's gravatar image

SqlExpert
16112


One Answer:

Dear Anurag,

I will cover joins in chapter 4 - I will definitely say a few words about memory there. Please don't expect this chapter to be published in the next 2 month - I am just finishing "The Where Clause" :)

UPDATE: The hash join section was already published, containing info about memory: Hash join and partial objects

I am writing, and publishing, the material as outlined in the preface.

If you have any real-world SQL problem right now, feel free to post it here, so I can have a look at it.

regards,
-markus

answered Dec 07 '10 at 01:59

Markus%20Winand's gravatar image

Markus Winand ♦♦
93651120

edited Jul 05 '11 at 11:44