Viewing 15 posts - 1 through 15 (of 79 total)
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.
January 8, 2015 at 1:38 am
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...
January 7, 2015 at 1:06 pm
Investigated some detailes here:
http://www.queryprocessor.com/nolock-and-top-optimization/
January 7, 2015 at 10:04 am
It still showing sad smiles after fixing and putting plan text into |code| tag instead of |quote|.
Yes, that is sad query =))
October 26, 2012 at 9:40 am
GilaMonster (10/25/2012)
Correlated subqueries do not run per row of the outer query (unless triangular joins or top 1 ... order by).
One more case when optimizer is not able to decorrelate...
October 26, 2012 at 9:36 am
Hi!
If you are interested in how recursive cte is working, you may check out this blog post by Rob Farley
September 25, 2012 at 8:54 am
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...
September 25, 2012 at 2:58 am
Dominic_godfrey (9/24/2012)
September 25, 2012 at 1:46 am
Phil Parkin (9/24/2012)
If you re-read my first post you'll see that I've tried this, but thanks anyway 🙂
I'm sorry, I missed it!
I know one more add-in SSMSBoost[/url], the developers announced...
September 24, 2012 at 11:39 pm
Also found this one:
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...
September 24, 2012 at 9:05 am
What about server side trace? Is it an option or not for some reasons?
September 24, 2012 at 3:44 am
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...
September 24, 2012 at 3:36 am
Evil Kraig F (9/20/2012)
Perhaps, I've been accused of optimism before... rarely, but it's happened. I'm sorry to hear your political system is falling apart however.
Actually it is falling...
September 20, 2012 at 3:59 pm
Evil Kraig F (9/20/2012)
We don't, not in this. You're about 10 years behind us
You are to optimistic to evaluate. I think our country has left behind 50 years. And...
September 20, 2012 at 3:19 pm
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...
September 20, 2012 at 2:32 pm
Viewing 15 posts - 1 through 15 (of 79 total)