Thanks Grant. I've corrected my message to be more convenient.

I've also update my blog post to define what does scan "initialization" mean.

Long time passed…

Do you have a solution so far? Explanation?

Did you read the blog post?

Do you know that this problem is applied even in 2014 sql server?

Did you examined the...

Investigated some detailes here:

http://www.queryprocessor.com/nolock-and-top-optimization/

It still showing sad smiles after fixing and putting plan text into |code| tag instead of |quote|.

Yes, that is sad query =))

One more case when optimizer is not able to decorrelate...

Hi!

If you are interested in how recursive cte is working, you may check out this blog post by Rob Farley

Hi! As far as I understand you need the opposite, Category and random sample project from each one. Then, just change places Project and ProjectCategory in ChrisM@Work example.

Also, consider the...

Dominic_godfrey (9/24/2012)

---

Hi all, thanks again for the replies it worked great, plus it was interesting to see the different ways to approach it. I used Paul's in the end and...

I'm sorry, I missed it!

I know one more add-in SSMSBoost[/url], the developers announced...

Also found this one:

SSMS Tools Pack add-in

As it's said on the utility page:

Query Execution History logs every SQL statement that you run in a file on your disk or in...

What about server side trace? Is it an option or not for some reasons?

You may use output clause to output the affected rows back to client

Smth like this.

with u as (select top(1) * from ATH_SyncEntities where Status = 0 order by EntityType, ID)

update...

Actually it is falling...

You are to optimistic to evaluate. I think our country has left behind 50 years. And...

Please, I am not an authority. Everything I have stated is simply my opinion. Why would Itzik choose Mr.Celko, you'd have to ask him. I have no...