Viewing 15 posts - 18,871 through 18,885 (of 19,560 total)
I agree with Andrew here. There is at least one table causing your results to grow. Narrow it down as Andrew explained and work on the select statement...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 5:40 pm
BTW, thanks for posting that information.
The tsql to change the parameterization is:
ALTER DATABASE [TestC] SET PARAMETERIZATION FORCED
GO
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 5:20 pm
Ah now I see what the issue is.
I was able to get both to use the same execution plan by changing the Parameterization option in TestC db to 'Forced'
In the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 5:18 pm
Now that I read the rest of the thread - after my last post - it seems a bit late.
Happy Birthday again anyway.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 3:44 pm
GilaMonster (12/7/2009)
CirquedeSQLeil (12/7/2009)
AntiquatedI take exception to that. 😉 :hehe:
Good thing I got it in there before you posted Birthday.
And if it is your birthday - Have a Happy Birthday.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 3:43 pm
RBarryYoung (12/7/2009)
Here's one that reminded me of many of the questions the we get: http://dilbert.com/strips/comic/2009-12-07/
Very accurately depicted
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 3:15 pm
DBADave (12/7/2009)
SORT_IN_TEMPDB is used, but...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 3:08 pm
I would let it run to completion if at all possible.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 2:40 pm
I think you will find that the advice given by the experts here has been generous.
Many of the people that have responded to you post are Interviewers and influential in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 2:27 pm
GilaMonster (12/7/2009)
CirquedeSQLeil (12/7/2009)
GilaMonster (12/7/2009)
Grant Fritchey (12/7/2009)
Nah, I'm just peeved because of... well, read for yourself.
Oh man. Bob, I LOVE your reply to that thread. What I was thinking, but too...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 2:21 pm
DBADave (12/7/2009)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 2:19 pm
bpowers (12/7/2009)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 1:54 pm
sql_lock (12/7/2009)
If you do change the model then be sure to backup the db (after you set back...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 1:48 pm
Please post sample data and table schema.
The two should return the same results. It seems that some data may be amiss, or maybe a setting in the linkedserver setup.
It...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 1:27 pm
NewBeeSQL has hit it on the head.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 12:46 pm
Viewing 15 posts - 18,871 through 18,885 (of 19,560 total)