February 20, 2009 at 10:34 pm
Lynn Pettis (2/20/2009)
I'm at an AFA v Holy Cross Hockey game (4 - 1 AFA after 2 periods) and reading this thread on my BlackBerry. Talk about needing to get a life!
That's why they're called "CrackBerry". 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2009 at 10:50 pm
Jeff Moden (2/20/2009)
Lynn Pettis (2/20/2009)
I'm at an AFA v Holy Cross Hockey game (4 - 1 AFA after 2 periods) and reading this thread on my BlackBerry. Talk about needing to get a life!That's why they're called "CrackBerry". 😉
Well, there wasn't a whole lot to do during the break between the 2nd and 3rd periods. Air Force won 4 - 3. Holy Cross tried to tie it in the end.
February 21, 2009 at 2:04 am
Lynn Pettis (2/20/2009)
Nope. Check your profile.
:blush: I forgot that was in there.
So much for that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 21, 2009 at 3:56 am
Lynn Pettis (2/20/2009)
Grant Fritchey (2/20/2009)
Lynn Pettis (2/20/2009)
Alvin Ramard (2/20/2009)
He's gone multi-threaded!!!!Is it contagious???
I quit. He's on his own. Total failure.
Uh oh. I think you helped him with your last post.
Nah, twas GSquared (Gus?). His new bestest buddy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2009 at 4:00 am
Lynn Pettis (2/20/2009)
David Webb (2/20/2009)
Hmmmmm...So many AD&D players.
DM: The OP has just sprung from behind a large pile of unread MSDN Library DVDs, wielding an update query with no qualifiers.
Cardinal Moden (15th level Palladin): I raise the Holy Porkchop catapult and fire.
Well, you can see where that could go...
Though playing only on the forum might stretch the game out quite a bit...
I actually started playing D&D with the original 3 books back in high school. Does that give away my age as well?
I was in Jr. High. I saw the original three books, but back then I was a war-gamer and looked down my nose at those silly role playing freaks... till I played once...
Anyone remember Squad Leader? City Fight? Air War? Anyone else lose three entire days of their lives to Wacht Am Rein fueled by quart cokes and packs of sweetarts from the Quick Trip or was that just me?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2009 at 4:30 am
And now I've spammed the endless thread.
Sorry everyone, sorry, I just got carried away.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2009 at 7:10 am
Grant Fritchey (2/21/2009)
I was in Jr. High. I saw the original three books, but back then I was a war-gamer and looked down my nose at those silly role playing freaks... till I played once...
Anyone remember Squad Leader? City Fight? Air War? Anyone else lose three entire days of their lives to Wacht Am Rein fueled by quart cokes and packs of sweetarts from the Quick Trip or was that just me?
I got hooked in high school, played in college and have kept it up sporatically afterwards. And while I can't say that I lost any days... I do remember one evening to the next morning session fueled by a liter of coke and a two pound bag of peanut M&Ms. It's amazing I didn't just self-combust from the caffiene and the sugar or go diabetic. But then, my metabolism could take a lot more punishment back then.
-- Kit
February 21, 2009 at 7:31 am
Kit G (2/21/2009)
I got hooked in high school, played in college and have kept it up sporatically afterwards. And while I can't say that I lost any days... I do remember one evening to the next morning session fueled by a liter of coke and a two pound bag of peanut M&Ms. It's amazing I didn't just self-combust from the caffiene and the sugar or go diabetic. But then, my metabolism could take a lot more punishment back then.
Yeah, now adays my teeth would start to hurt, I'd pass out and wake up in the morning 10 pounds heavier.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 21, 2009 at 7:39 am
After yet another case of someone just posting a query and asking why it was slow (If I could tell, I'd have some really, really happy clients), I'm contemplating writing a sequel to Jeff's "Forum etiquette" article on what and how to post performance problems.
Thoughts, comments, suggestions, contributions, ... ?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 21, 2009 at 7:41 am
Kit G (2/21/2009)
I got hooked in high school, played in college and have kept it up sporatically afterwards. And while I can't say that I lost any days... I do remember one evening to the next morning session fueled by a liter of coke and a two pound bag of peanut M&Ms. It's amazing I didn't just self-combust from the caffiene and the sugar or go diabetic. But then, my metabolism could take a lot more punishment back then.
The longest I've played in one go was 3pm to about 10pm. We were supposed to finish at 8, but the guys were enjoying the haunted house so much they wanted to finish it that game.
Lotsa chips and coffee, I don't drink coke.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 21, 2009 at 7:46 am
GilaMonster (2/21/2009)
After yet another case of someone just posting a query and asking why it was slow (If I could tell, I'd have some really, really happy clients), I'm contemplating writing a sequel to Jeff's "Forum etiquette" article on what and how to post performance problems.Thoughts, comments, suggestions, contributions, ... ?
It's a good idea... but how will that solve the problem of poeple just asking a question without doing research or even wondering hwo to ask the question the best way possible.
Short of having the forum software modified to require and VALIDATE DDL AND DML code for data, I don't see a way out of this.
February 21, 2009 at 7:54 am
GilaMonster (2/21/2009)
After yet another case of someone just posting a query and asking why it was slow (If I could tell, I'd have some really, really happy clients), I'm contemplating writing a sequel to Jeff's "Forum etiquette" article on what and how to post performance problems.Thoughts, comments, suggestions, contributions, ... ?
Good idea, Gail. A "Slow SQL Server" is really a different problem from a "Slow Query".
You know my checklist: 1) use Perfmon/Task Manager to make sure there isn't something else running on the server, 2) what's the server config, esp. the disks, 3) if you're using a SAN/NAS, what's it's configuration, 4) always get Perfmon %idle on the disks.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2009 at 8:00 am
RBarryYoung (2/21/2009)
GilaMonster (2/21/2009)
After yet another case of someone just posting a query and asking why it was slow (If I could tell, I'd have some really, really happy clients), I'm contemplating writing a sequel to Jeff's "Forum etiquette" article on what and how to post performance problems.Thoughts, comments, suggestions, contributions, ... ?
Good idea, Gail. A "Slow SQL Server" is really a different problem from a "Slow Query".
You know my checklist: 1) use Perfmon/Task Manager to make sure there isn't something else running on the server, 2) what's the server config, esp. the disks, 3) if you're using a SAN/NAS, what's it's configuration, 4) always get Perfmon %idle on the disks.
I'd love to read THAT article. I was at a client yesterday and something was fishy on the server... they immediatly wanted to reboot the server without any investigations. Now keep in mind that this is a 24/7 shop with 100s of employees and at least 50 on staff outside of production employees.
My first reaction was wtf??? You don't even know what's running on that server besides your application. They rebooted anyways and nothing broke (as far as I know).
I just didn't know what to run beyond sp_who2 to make sure the statement was not blocked and then task manager to make sure it wasn't another process.
In case you're wondering, No! I'm not consulting as a prod DBA on that site but as a report dev.
February 21, 2009 at 8:02 am
Ninja's_RGR'us (2/21/2009)
It's a good idea... but how will that solve the problem of poeple just asking a question without doing research or even wondering hwo to ask the question the best way possible.
It won't, no more than Jeff's does. Can't force people to read. Can't force them to follow a recommendation.
At best it means some people might read, remember and post stuff in a useful way. At worst it gives me something to reference instead of typing out in each and every applicable thread "Please post execution plan, please post table and index definitions,...."
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 21, 2009 at 8:04 am
RBarryYoung (2/21/2009)
Good idea, Gail. A "Slow SQL Server" is really a different problem from a "Slow Query".
I'm thinking of the "Slow Query" scenario here.
You know my checklist: 1) use Perfmon/Task Manager to make sure there isn't something else running on the server, 2) what's the server config, esp. the disks, 3) if you're using a SAN/NAS, what's it's configuration, 4) always get Perfmon %idle on the disks.
Why don't you write an article on debugging slow server performance? It'll save a lot of people a lot of problems (if they bother reading it, that is)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 1,726 through 1,740 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply