HI ,

you can try indexing and some tweeking in the query for object A to avoid spooling for loop join,

for better help please provide actual plan.

Thanx for the question, its good to refresh memory.:-)

Thanks for the wonderful script.

keep posting such good scripts..

Its a great article, thanks for sharing it.

please check this link its a bug

http://connect.microsoft.com/SQLServer/feedback/details/621330/sum-of-operator-costs-is-more-than-100-in-the-execution-plans

Thanks for notifying,

but please tell us have you got the solution?

T.Ashish (8/25/2013)

---

Dear All,

I have a query that takes 22 seconds.

If I create below index then query finishes in 5 seconds, but I'm told that this type of index can't be...

Update T1

set T1.col2 = T2.co3

From Table1 T1 left join Table2 T2

on T1.Con1 = T2.Col1

Where some condition

IS that you want?

result set of Union and union all can be different based on data

for example :

select 1 union all

select...

With(NOLOCK)

I hope u know everything about it,

and for the query optimization can you chop down your query into Temp tables as this could lead better execution plan as well,

and i...

sub query ? does that means in clause as well please...

vantuan02t1 (7/17/2013)

---

I have sample data as below:

IDActivitySubject ProjectName Fullname CusName

2 ...

NOTED ..

It might be stats, the insert will trigger an auto-update...

Bingo ....

i did`t think about it ...

thanx

Thato (2/8/2011)

---

Good article. Straight to the point. Good examples too. Needs to work a little bit more on presentation,spell check and sort order options for output readability and quick comparison....