Viewing 15 posts - 17,056 through 17,070 (of 19,560 total)
Lynn Pettis (2/23/2010)
On a count down to 12,000 posts on The Thread!
Only 14 more posts
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
February 23, 2010 at 9:00 am
I like Nigel's suggestion, comments. Check out the stuff by Jeff.
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
February 23, 2010 at 8:54 am
Suresh B. (2/22/2010)
Joe-420121 (2/22/2010)
update i set i.name= 'MR Y' from inventory 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
February 22, 2010 at 11:14 pm
full double full full double (freestyle aerials)
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
February 22, 2010 at 10:59 pm
Paul White (2/22/2010)
CirquedeSQLeil (2/22/2010)
With him becoming famous, we're starting the push for him to be MVP.
Well I don't know exactly what the criteria are, but Barry strikes me as a...
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
February 22, 2010 at 10:55 pm
Paul White (2/22/2010)
RBarryYoung (2/22/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
February 22, 2010 at 10:41 pm
You can try one of the sysinternals tools
http://technet.microsoft.com/en-us/sysinternals/bb795533.aspx
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
February 22, 2010 at 10:00 pm
RBarryYoung (2/22/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
February 22, 2010 at 6:58 pm
Steve Jones - Editor (2/22/2010)
Ahh, the Thread is quiet. Or are we waiting for Paul's answer?
Nah, we're just playing hide 'n seek. We hid it, now you find 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
February 22, 2010 at 4:43 pm
John Burris (2/22/2010)
I posted earlier that for 1,000,000 records I ran my first solution at 1:30 and Jeff's solution at 10 seconds. I ran the GSquared "ultimate version" on...
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
February 22, 2010 at 3:38 pm
Jeff Moden (2/22/2010)
BTW, the version that I've not shown you will take an INT to the max and it does it without referencing any tables at all.
I have to...
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
February 22, 2010 at 3:33 pm
reidres (2/22/2010)
Well I have to dispute the scalability of Jeff's implied solution and also think it is clunky and not intuitive.
Why do you think it is clunky?
I cringe...
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
February 22, 2010 at 2:27 pm
No. Did not know it was a kids game. Interesting insight.
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
February 22, 2010 at 12:44 pm
Jeff Moden (2/22/2010)
FizzBuzz 😛
Which sparks a question - why is it called FIZZBUZZ?
Is it because you get a Buzz from the Fizz of a Cola?
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
February 22, 2010 at 12:25 pm
Comeback (as in NBA action yesterday)
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
February 22, 2010 at 12:14 pm
Viewing 15 posts - 17,056 through 17,070 (of 19,560 total)