Viewing 15 posts - 15,226 through 15,240 (of 19,560 total)
WayneS (4/6/2010)
CirquedeSQLeil (4/6/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 6, 2010 at 9:49 pm
Nicholas Cain (4/6/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 6, 2010 at 9:46 pm
Have any of our suggestions helped you with this query?
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 6, 2010 at 9:43 pm
ianstirk (4/6/2010)
I'm glad you liked the article.
There is an updated version of this script, without the deprecated objects, given in the book I am writing "SQL Server DMVs...
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 6, 2010 at 9:03 pm
dma-669038 (4/6/2010)
http://www.surveymonkey.com/s/HLR8V5S
There is no provision for any extra verbage/introduction on top, or to share survey results with others either ( can only...
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 6, 2010 at 8:39 pm
Paul White NZ (4/6/2010)
CirquedeSQLeil (4/6/2010)
Thanks Paul for this suggested workaround.Hey, thanks for mentioning it! 12th March I posted that - seems much longer ago for some reason...?!
That's not 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
April 6, 2010 at 8:37 pm
john.arnott (4/6/2010)
CirquedeSQLeil (4/6/2010)
My next response will be to use 5.25 floppies. Maybe sneakernet will work.Or 8" floppies for that good old nineteen seventies vibe.
Break out the lava lamp
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 6, 2010 at 8:34 pm
Jeff Moden (4/6/2010)
Steve Jones - Editor (4/6/2010)
Unless someone has a great argument, I am going to choose Gianluca's entry here: http://ask.sqlservercentral.com/questions/4241/whats-the-best-way-to-solve-the-fizzbuzz-question/4631#4631It seemed to perform the fastest on my machine.
I agree......
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 6, 2010 at 6:37 pm
jcrawf02 (4/6/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 6, 2010 at 6:36 pm
Thanks Paul for this suggested workaround.
I had been fiddling with that for a bit, and wasn't getting it right. I was overlooking a key part of my query being...
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 6, 2010 at 6:30 pm
Nice and relevant article. I would have liked to have seen it not use a deprecated object though.
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 6, 2010 at 6:16 pm
Steve Jones - Editor (4/6/2010)
Unless someone has a great argument, I am going to choose Gianluca's entry here: http://ask.sqlservercentral.com/questions/4241/whats-the-best-way-to-solve-the-fizzbuzz-question/4631#4631It seemed to perform the fastest on my machine.
No argument. 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
April 6, 2010 at 6:04 pm
Paul White NZ (4/6/2010)
CirquedeSQLeil (4/6/2010)
Looks like Paul was kind-hearted and provided some information - to the two DW questions.
Well it took me all of 15 seconds to Google it :doze:
He...
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 6, 2010 at 4:59 pm
Trey Staker (4/6/2010)
Sounds like someone is going to fail.
You should of responded to him in the PM that you'd be happy to do it as you do any contract job...
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 6, 2010 at 4:44 pm
John Rowan (4/6/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 6, 2010 at 4:43 pm
Viewing 15 posts - 15,226 through 15,240 (of 19,560 total)