Viewing 15 posts - 1 through 15 (of 66 total)
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.
Neeraj Prasad Sharma
Sql Server Tutorials
August 3, 2015 at 12:29 am
Thanx for the question, its good to refresh memory.:-)
Neeraj Prasad Sharma
Sql Server Tutorials
September 16, 2013 at 3:46 am
Thanks for the wonderful script.
keep posting such good scripts..
Neeraj Prasad Sharma
Sql Server Tutorials
September 7, 2013 at 2:18 am
Its a great article, thanks for sharing it.
Neeraj Prasad Sharma
Sql Server Tutorials
September 7, 2013 at 2:16 am
please check this link its a bug
Neeraj Prasad Sharma
Sql Server Tutorials
September 3, 2013 at 2:43 am
Thanks for notifying,
but please tell us have you got the solution?
Neeraj Prasad Sharma
Sql Server Tutorials
September 3, 2013 at 1:10 am
T.Ashish (8/25/2013)
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...
Neeraj Prasad Sharma
Sql Server Tutorials
September 3, 2013 at 1:03 am
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?
Neeraj Prasad Sharma
Sql Server Tutorials
September 3, 2013 at 12:53 am
Junglee_George (9/3/2013)
Is it better to use union or union all
result set of Union and union all can be different based on data
for example :
select 1 union all
select...
Neeraj Prasad Sharma
Sql Server Tutorials
September 3, 2013 at 12:33 am
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...
Neeraj Prasad Sharma
Sql Server Tutorials
August 28, 2013 at 12:21 am
Danny Ocean (8/6/2013)
Most of time i try to avoid Exists clause. I will prefer join or sub query.Good question 🙂
sub query ? does that means in clause as well please...
Neeraj Prasad Sharma
Sql Server Tutorials
August 7, 2013 at 1:11 am
vantuan02t1 (7/17/2013)
IDActivitySubject ProjectName Fullname CusName
2 ...
Neeraj Prasad Sharma
Sql Server Tutorials
July 18, 2013 at 12:14 am
GilaMonster (7/12/2013)
It won't be fragmentation as the query optimiser does not take fragmentation into account when costing the queries.
NOTED ..
It might be stats, the insert will trigger an auto-update...
Neeraj Prasad Sharma
Sql Server Tutorials
July 15, 2013 at 12:31 am
July 12, 2013 at 5:49 am
Thato (2/8/2011)
Neeraj Prasad Sharma
Sql Server Tutorials
July 10, 2013 at 12:57 am
Viewing 15 posts - 1 through 15 (of 66 total)