Viewing 15 posts - 18,736 through 18,750 (of 19,560 total)
I was leaning toward the Correct answer until I re-read the question and convinced myself that it was asking for server performance. I would have to agree with Peter...
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 14, 2009 at 1:59 pm
It seems similar to this other thread.
Specifically look into xp_servicecontrol
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 14, 2009 at 1:14 pm
What version of SQL and OS are you running?
When you installed DTC, what was your procedure?
Where do you see that DTC is running/not running (Service control panel or Cluster Administrator)?
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 14, 2009 at 12:39 pm
WayneS (12/14/2009)
Alvin Ramard (12/14/2009)
GSquared (12/14/2009)
CirquedeSQLeil (12/11/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 14, 2009 at 12:29 pm
jcrawf02 (12/14/2009)
crookj (12/14/2009)
CirquedeSQLeil (12/11/2009)
crookj (12/11/2009)
Humorous(Watching the single winning Cleveland Browns defeat the so called World Champions - Pittsburgh Steelers.) 😛
Yes, yes indeed that is humorous:-D. Too bad my...
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 14, 2009 at 12:27 pm
OK - I disagree with the current answer. Though there are 3 select queries to retrieve the results - the recursive query is two select statements.
Maybe it is nitpicking....
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 14, 2009 at 11:35 am
Lucky guess - Image would not display.
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 14, 2009 at 11:18 am
What is the difference between this question and the question for 12/27/2004?
Different answers are correct, so which of the two is more correct?
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 14, 2009 at 11:08 am
What is the difference between this question and that of Feb. 16, 2005?
One says that you must use a wrapper, the other says that the wrapper already exists and nothing...
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 14, 2009 at 11:07 am
Just tested the query in SSMS 2008 and it produced the same results as 2000 QA.
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 14, 2009 at 10:51 am
What is your disk configuration and tempdb configuration?
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 14, 2009 at 10:47 am
Thanks Paul for clarifying.
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 14, 2009 at 10:33 am
TheSQLGuru (12/12/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 14, 2009 at 10:30 am
Christian Buettner-167247 (12/14/2009)
Same code as before, but positioned order by (1 instead of i) and "-" as separator for better readability.
SET NOCOUNT ON
create table...
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 14, 2009 at 10:27 am
jcrawf02 (12/14/2009)
CirquedeSQLeil (12/14/2009)
BEARyou spelled Beer wrong...
**Edit - I am officially declaring myself un-funny, as I (shockingly :w00t:) neglected to read up on my Thread before seeing this one. 😀
LOL
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 14, 2009 at 10:12 am
Viewing 15 posts - 18,736 through 18,750 (of 19,560 total)