January 29, 2013 at 11:26 am
Steve Jones - SSC Editor (1/29/2013)
Stefan Krzywicki (1/29/2013)
You have to print them out and mail them to Steve with qualifying box tops.
Prizes must be redeemed in person at the ranch. Please call ahead to schedule a time.
AHA! A Quest!
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
January 29, 2013 at 11:28 am
wolfkillj (1/29/2013)
jcrawf02 (1/29/2013)I've been farming for post count, and I gotta say, it's really confusing because I can't tell where you're supposed to go cash in all these points for better armor...
Posting on this thread ipso facto equals farming for post count. Anybody know where I can get the "underground post count farmers" hack?
No, but I could provide you with contact information for some of my nephews who'd be glad to post here for you. All for the low, low price of $1 a post.
😀
Hmm, maybe I should just have them post for me...
:hehe:
January 29, 2013 at 3:47 pm
Not as scary as the brain surgery for Stefan's friend but my wife is having total shoulder replacement surgery in the morning. Her mom is coming out for a couple weeks to help around the house and to let me get back to work. I will be out for at least the next day or so. See you all in a couple days.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 29, 2013 at 3:55 pm
Sean Lange (1/29/2013)
Not as scary as the brain surgery for Stefan's friend but my wife is having total shoulder replacement surgery in the morning. Her mom is coming out for a couple weeks to help around the house and to let me get back to work. I will be out for at least the next day or so. See you all in a couple days.
Good luck!
My friend seems to be recovering well so far.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
January 30, 2013 at 1:13 am
They have no idea what a never-ending thread really is...
January 30, 2013 at 7:59 am
BrainDonor (1/30/2013)
http://xkcd.com/1166/They have no idea what a never-ending thread really is...
Heh. Another forum I'm on (game related) had a "never ending thread" that got up into the 10s' of thousands of posts. Which then started crashing the forum software, in part because they also allowed people to attach images...
Now, you want a topic that would *really* generate some responses, start a Star Trek vs Star Wars topic, or go into an RPG forum and start discussing the merits of one edition of game rules vs another edition of the same (Say AD&D v2 vs AD&D v4)
😀
January 30, 2013 at 8:15 am
BrainDonor (1/30/2013)
jasona.work (1/30/2013)
Now, you want a topic that would *really* generate some responses, start a Star Trek vs Star Wars topic,Babylon 5 or nothing.
Aaannnddd we're off!
Newer: Firefly (Browncoats unite!)
Older: Star Trek (TOS)
😛
January 30, 2013 at 9:00 am
jasona.work (1/30/2013)
BrainDonor (1/30/2013)
http://xkcd.com/1166/They have no idea what a never-ending thread really is...
Heh. Another forum I'm on (game related) had a "never ending thread" that got up into the 10s' of thousands of posts. Which then started crashing the forum software, in part because they also allowed people to attach images...
Now, you want a topic that would *really* generate some responses, start a Star Trek vs Star Wars topic, or go into an RPG forum and start discussing the merits of one edition of game rules vs another edition of the same (Say AD&D v2 vs AD&D v4)
😀
Interesting that the very next xkcd strip touched on this very phenomenon:
Jason Wolfkill
January 30, 2013 at 11:12 am
I have to share my excitement. I taught a class here at work to help employees prepare for the Microsoft 70-461 test. So far 6 people have taken it... and all 6 passed! The perfect streak won't last forever, but wow I am so stoked! I know it doesn't mean I'm a good teacher (correlation<>causation, particularly in THIS CASE!), some of them only needed the motivation to study a little and actually take the test, but it probably means I'm not a BAD teacher! And I'm way happy for them. Certification hasn't been a goal for anyone up until this, now it is generating some excitement and interest. I've been telling them how good they are (at SQL and working with SQL Server), now they can no longer deny it. WOO HOO! Time to come up with a good party.
Chad
January 30, 2013 at 1:48 pm
Chad Crawford (1/30/2013)
I have to share my excitement. I taught a class here at work to help employees prepare for the Microsoft 70-461 test. So far 6 people have taken it... and all 6 passed! The perfect streak won't last forever, but wow I am so stoked! I know it doesn't mean I'm a good teacher (correlation<>causation, particularly in THIS CASE!), some of them only needed the motivation to study a little and actually take the test, but it probably means I'm not a BAD teacher! And I'm way happy for them. Certification hasn't been a goal for anyone up until this, now it is generating some excitement and interest. I've been telling them how good they are (at SQL and working with SQL Server), now they can no longer deny it. WOO HOO! Time to come up with a good party.Chad
Hmmm, taking students? I'd love to work on getting the SQL2012 certification soon.
Although the drive from Detroit to Utah would be a bit much...
😀
January 30, 2013 at 3:47 pm
Chad Crawford (1/30/2013)
I have to share my excitement. I taught a class here at work to help employees prepare for the Microsoft 70-461 test. So far 6 people have taken it... and all 6 passed! The perfect streak won't last forever, but wow I am so stoked! I know it doesn't mean I'm a good teacher (correlation<>causation, particularly in THIS CASE!), some of them only needed the motivation to study a little and actually take the test, but it probably means I'm not a BAD teacher! And I'm way happy for them. Certification hasn't been a goal for anyone up until this, now it is generating some excitement and interest. I've been telling them how good they are (at SQL and working with SQL Server), now they can no longer deny it. WOO HOO! Time to come up with a good party.Chad
Congrats, Chad!
Have one one me! 😀
January 30, 2013 at 4:22 pm
jasona.work (1/30/2013)
Chad Crawford (1/30/2013)
I have to share my excitement. I taught a class here at work to help employees prepare for the Microsoft 70-461 test. So far 6 people have taken it... and all 6 passed! The perfect streak won't last forever, but wow I am so stoked! I know it doesn't mean I'm a good teacher (correlation<>causation, particularly in THIS CASE!), some of them only needed the motivation to study a little and actually take the test, but it probably means I'm not a BAD teacher! And I'm way happy for them. Certification hasn't been a goal for anyone up until this, now it is generating some excitement and interest. I've been telling them how good they are (at SQL and working with SQL Server), now they can no longer deny it. WOO HOO! Time to come up with a good party.Chad
Hmmm, taking students? I'd love to work on getting the SQL2012 certification soon.
Although the drive from Detroit to Utah would be a bit much...
😀
Detroit? Do you attend the local PASS meetings? Do I know you and am just missing the connection?
--Jeff Moden
Change is inevitable... Change for the better is not.
January 30, 2013 at 4:35 pm
jasona.work (1/30/2013)
Chad Crawford (1/30/2013)
I have to share my excitement. I taught a class here at work to help employees prepare for the Microsoft 70-461 test. So far 6 people have taken it... and all 6 passed! The perfect streak won't last forever, but wow I am so stoked! I know it doesn't mean I'm a good teacher (correlation<>causation, particularly in THIS CASE!), some of them only needed the motivation to study a little and actually take the test, but it probably means I'm not a BAD teacher! And I'm way happy for them. Certification hasn't been a goal for anyone up until this, now it is generating some excitement and interest. I've been telling them how good they are (at SQL and working with SQL Server), now they can no longer deny it. WOO HOO! Time to come up with a good party.Chad
Hmmm, taking students? I'd love to work on getting the SQL2012 certification soon.
Although the drive from Detroit to Utah would be a bit much...
😀
That would be awesome, but I don't think I'm quite the caliber to travel for though.
January 30, 2013 at 5:18 pm
Has the world just come to an end and no one told me?
Overnight for me in Bangkok and I received not a single notification from SSC, not even from The Thread!
First time in recorded memory I think. 😛
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
Viewing 15 posts - 38,851 through 38,865 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply