Viewing 15 posts - 19,246 through 19,260 (of 19,560 total)
Peter's latest submission is quite the trick. Though not significantly different, it does have improvement in execution plan and client statistics over the others.
Again, surprising is the amazing similarity...
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
October 29, 2009 at 10:33 am
Paul White (10/29/2009)
CirquedeSQLeil (10/28/2009)
I really like the PointlessAlias as the table alias Emperor PaulPatine.
:laugh: Thanks Jason. Good to know that other people find the syntax frustrating at times too.
I...
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
October 29, 2009 at 10:22 am
You will need to export them and use them in conjunction with the source code and solution file that goes with the package.
Example Using SSIS Package:
You would export the Package.dtsx...
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
October 29, 2009 at 10:18 am
This behavior appears to be a connection manager behavior when connecting to Non-SQL sources (have seen that it also happens with sybase - and the fix was to change 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
October 29, 2009 at 10:13 am
Do you have the source for the package? Or just what was imported into the msdb in SQL server?
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
October 29, 2009 at 10:01 am
GilaMonster (10/29/2009)
CirquedeSQLeil (10/28/2009)
Anybody know anything more about it, opinions or otherwise?
If you're going to buy the book (and you won't be at the PASS conference), then rather order from 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
October 29, 2009 at 9:58 am
Steve Jones - Editor (10/29/2009)
Maybe I should run this query as a job? kill the user here that uses the most CPU and memory every 5 minutes?
Ummm... couldn't that be...
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
October 29, 2009 at 9:52 am
Steve Jones - Editor (10/29/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
October 29, 2009 at 9:50 am
Congrats Steve on the streak. Being an Avid Runner myself - I'm just trying to get back to it after having had knee surgery earlier this year.
Different topic:
We had...
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
October 29, 2009 at 9:47 am
dbl post
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
October 28, 2009 at 10:16 pm
Bob Hovious 24601 (10/28/2009)
I didn't go there either, Jason.
Nope - I did. It was worth a laugh.
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
October 28, 2009 at 10:08 pm
I may be a joker - but definitely don't fit the rest of criteria
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
October 28, 2009 at 9:38 pm
Bob Hovious 24601 (10/28/2009)
Some people call me the SQL Cowboy.
Some people...
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
October 28, 2009 at 9:01 pm
This has been an interesting problem to follow.
I really like the PointlessAlias as the Table Alias Emperator PaulPatine.
I agree with Wayne that it is interesting that all three solutions create...
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
October 28, 2009 at 6:14 pm
Oh, that is a good idea. Guess that wouldn't work too well with just buying the e-book though:hehe:
A round of Autographs from the Authors in the Thread:w00t:
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
October 28, 2009 at 6:06 pm
Viewing 15 posts - 19,246 through 19,260 (of 19,560 total)