Viewing 15 posts - 14,941 through 14,955 (of 19,560 total)
Nice refresher question.
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
April 12, 2010 at 9:09 pm
nguyennd (4/12/2010)
:-D, in this case, i want to get 2 column with CODE=1 but case when CODE=1 one time, huhu
I'm not sure I understand. Your statement is self-contradicting.
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
April 12, 2010 at 8:44 pm
Are all instances running the same version of SQL server (same patch level)?
I have seen where the patch level has an impact on query performance - very similar description as...
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
April 12, 2010 at 8:42 pm
Are you sure you want to do that?
As you have it setup now, each on would display as a different column. Rewriting the query would change it so that...
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
April 12, 2010 at 8:35 pm
RBarryYoung (4/12/2010)
Doggoneit! Does everyone one this site have better graphics than me? :angry:
The job on the graphics was quite good. A lot of kudos are deserved for...
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
April 12, 2010 at 8:24 pm
To the original topic - I think it boils down to a matter of preference and "It Depends." Both are very good platforms and both perform very well when...
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
April 12, 2010 at 5:10 pm
I have considered the masters degree a few times as well. Personally, I don't see the benefit as it relates to cost. I think I would rather do...
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
April 12, 2010 at 3:53 pm
MCDST seems to be a very high paying salary compared to what I have seen.
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
April 12, 2010 at 3:50 pm
TAMMYAUDETTE (4/12/2010)
I am genuinely grateful for the help I've received so far, and I look forward to the point where I can take what I've learned...
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
April 12, 2010 at 3:46 pm
jcrawf02 (4/12/2010)
CirquedeSQLeil (4/12/2010)
Jason Shadonix (4/12/2010)
Lynn Pettis (4/12/2010)
CirquedeSQLeil (4/12/2010)
GSquared (4/12/2010)
Just had a guy today who posted a whole exam, which he says "a friend needs for his masters program".
Where is...
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
April 12, 2010 at 2:40 pm
jcrawf02 (4/12/2010)
CirquedeSQLeil (4/12/2010)
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
April 12, 2010 at 2:39 pm
You're welcome. Just keep in mind that that information is based on the release of R2. Microsoft can change that as well as implement licensing procedures for 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
April 12, 2010 at 2:32 pm
Nice solution by ColdCoffee. This will work for your needs.
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
April 12, 2010 at 2:30 pm
Jason Shadonix (4/12/2010)
Lynn Pettis (4/12/2010)
CirquedeSQLeil (4/12/2010)
GSquared (4/12/2010)
Just had a guy today who posted a whole exam, which he says "a friend needs for his masters program".
Where is that one?...
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
April 12, 2010 at 2:28 pm
Thanks Lynn.
I have to agree with the others in that thread - I don't see the relevance to a Masters Degree and I don't see why the person would need...
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
April 12, 2010 at 2:12 pm
Viewing 15 posts - 14,941 through 14,955 (of 19,560 total)