September 15, 2010 at 9:49 am
CirquedeSQLeil (9/15/2010)
Brandie Tarvin (9/15/2010)
[font="Verdana"]We're sorry. The user you are attempting to contact has been smited for biltong blasphemy. Please try your post again later.[/font][font="Verdana"]We're sorry. The user you are attempting to contact has been smited for biltong blasphemy. Please try your post again later.[/font]
[font="Verdana"]We're sorry. The user you are attempting to contact has been smited for biltong blasphemy. Please try your post again later.[/font]
Isn't that the chevy counter ploy for the Ford Built Tough slogan
Chevy - Bilt Ong Ogre power!!
Groan!
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
September 15, 2010 at 11:02 am
Chris Morris-439714 (9/15/2010)
SELECT [No biltong = ] = CAST('Þ¾ï' AS VARBINARY)
Very clever 😎
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
September 15, 2010 at 11:07 am
Hey you'll...
I know a lot of people don't like Joe Celko's online personna. You might be interested in how his tone changed in this thread after it was discovered the OP is a pharmacist with no sql knowledge. Shows he has a decent side after all.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 15, 2010 at 11:13 am
Gianluca Sartori (9/15/2010)
Alvin Ramard (9/15/2010)
Steve Jones - Editor (9/15/2010)
And on an unrelated note. Who wants this job?Not the kind of job I'd want.
I had to stop it after 2 minutes. :sick:
2:30min :sick: + I don't need dinner anymore + I need some medicine to stop my shudder and bring down my adrenaline
September 15, 2010 at 11:30 am
Once that guy got outside the caged area, my stomach was flip flopping. Struggled to watch, and then was stunned again when he reached that orange pole and still had 60ft to go.
Wow.
September 15, 2010 at 12:46 pm
Tom.Thomson (9/15/2010)
Stefan Krzywicki (9/14/2010)
CirquedeSQLeil (9/14/2010)
Alvin Ramard (9/14/2010)
GilaMonster (9/14/2010)
Grant Fritchey (9/14/2010)
GilaMonster (9/14/2010)
Lynn Pettis (9/14/2010)
The key to arguing with GilaMonster (or anyone for that matter) is:A) Admit when you are wrong.
B) If not A, agree to disagree.
And
C) If you're right, don't gloat.
Much.
Ok...
Gloat as much as you like, in private.
No, come gloat in here! (That way we can all watch. :-D)
Why all the discussion about goats?
Not just goats, "Gloats". Those are fat goats, they get their name from a combination of Bloat and Goat.
Are you saying that Grant is a fat goat? If so I think you should apogolize.
Slightly overweight goat would be more accurate.
"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
September 15, 2010 at 12:48 pm
Steve Jones - Editor (9/15/2010)
Once that guy got outside the caged area, my stomach was flip flopping. Struggled to watch, and then was stunned again when he reached that orange pole and still had 60ft to go.Wow.
Worse was the climax - guy #2 has to sit on top of the light with guy #1.
Anybody up for it now? Sounds fun!!
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
September 15, 2010 at 12:51 pm
CirquedeSQLeil (9/15/2010)
Steve Jones - Editor (9/15/2010)
Once that guy got outside the caged area, my stomach was flip flopping. Struggled to watch, and then was stunned again when he reached that orange pole and still had 60ft to go.Wow.
Worse was the climax - guy #2 has to sit on top of the light with guy #1.
Anybody up for it now? Sounds fun!!
Really wish I wasn't at work so I could see this video, it almost sounds like something fun. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 15, 2010 at 12:53 pm
Craig Farrell (9/15/2010)
CirquedeSQLeil (9/15/2010)
Steve Jones - Editor (9/15/2010)
Once that guy got outside the caged area, my stomach was flip flopping. Struggled to watch, and then was stunned again when he reached that orange pole and still had 60ft to go.Wow.
Worse was the climax - guy #2 has to sit on top of the light with guy #1.
Anybody up for it now? Sounds fun!!
Really wish I wasn't at work so I could see this video, it almost sounds like something fun. 🙂
I had to watch it on my phone - youtube is blocked here at work as well.
Nearly 8 minute climb
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
September 15, 2010 at 1:04 pm
CirquedeSQLeil (9/15/2010)
Craig Farrell (9/15/2010)
CirquedeSQLeil (9/15/2010)
Steve Jones - Editor (9/15/2010)
Once that guy got outside the caged area, my stomach was flip flopping. Struggled to watch, and then was stunned again when he reached that orange pole and still had 60ft to go.Wow.
Worse was the climax - guy #2 has to sit on top of the light with guy #1.
Anybody up for it now? Sounds fun!!
Really wish I wasn't at work so I could see this video, it almost sounds like something fun. 🙂
I had to watch it on my phone - youtube is blocked here at work as well.
Nearly 8 minute climb
IMO you have to be somewhat insane to do that.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 15, 2010 at 1:05 pm
Craig Farrell (9/15/2010)
CirquedeSQLeil (9/15/2010)
Steve Jones - Editor (9/15/2010)
Once that guy got outside the caged area, my stomach was flip flopping. Struggled to watch, and then was stunned again when he reached that orange pole and still had 60ft to go.Wow.
Worse was the climax - guy #2 has to sit on top of the light with guy #1.
Anybody up for it now? Sounds fun!!
Really wish I wasn't at work so I could see this video, it almost sounds like something fun. 🙂
After just over 2min I asked myself: "If he's missing a step and finally reaching the ground, will his tool bag already be there or not?" Followed by: "When did they mention the parachute?" After 2:30min I realized they didn't. After that... just see my prev post.
There's simply not enough money on this globe to make me doing his job for a single day (I wouldn't have any day after that anyway...)
September 15, 2010 at 1:29 pm
Will definitely have to watch that when I get home.
Side note, advice seeking -
53 text files that we want to load into 53 diff tables, all with different file structures.
Should I even be considering one SSIS package to do all that? Or is that ridiculous?
All the files come at once from our regulatory body, and we have to reconcile with our current data and respond under unreasonable deadlines (you know, same old same old), so was hoping to automate at least the load and variance portions.
---------------------------------------------------------
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."
September 15, 2010 at 1:34 pm
jcrawf02 (9/15/2010)
Will definitely have to watch that when I get home.Side note, advice seeking -
53 text files that we want to load into 53 diff tables, all with different file structures.
Should I even be considering one SSIS package to do all that? Or is that ridiculous?
All the files come at once from our regulatory body, and we have to reconcile with our current data and respond under unreasonable deadlines (you know, same old same old), so was hoping to automate at least the load and variance portions.
I would use SSIS.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 15, 2010 at 1:43 pm
Ok, so here's what I'm thinking then:
each filetype has a reportID which will be PART of the name, so
53 ForEachLoop Containers, with a filetype of *<reportID>*.txt - theoretically should look for any occurrences of that type of file in the folder (forgot to mention that we don't get ALL the files all the time)
hard-code the columns from each filetype in the Data Flow to move the data in
...etc
seemed kind of gigrungious, not sure if I'm missing something or if that's actually what I should do.
---------------------------------------------------------
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."
September 15, 2010 at 1:44 pm
Craig Farrell (9/15/2010)
--------------------------------------------------------------------------------
CirquedeSQLeil (9/15/2010)
--------------------------------------------------------------------------------
Steve Jones - Editor (9/15/2010)
--------------------------------------------------------------------------------
Once that guy got outside the caged area, my stomach was flip flopping. Struggled to watch, and then was stunned again when he reached that orange pole and still had 60ft to go.
Wow.
Worse was the climax - guy #2 has to sit on top of the light with guy #1.
Anybody up for it now? Sounds fun!!
Really wish I wasn't at work so I could see this video, it almost sounds like something fun. 🙂
What did not show in that Video, normally the speed of the wind at those heights is much stronger than at ground level, and the climber has to do more than hand over hand climbing, but resist the wind attempting to blow him off the #$%!@ rungs.
The vocal mentioned the fact that the climber took an elevator up to almost the top within the tower structure. In my cases the elevator was one of those lift baskets you see in helicopter rescues and was lifted by a winch, and of course tended to sway inside the tower structure. But once to the top the view is truly spectacular (Having seen Mexico City, San Juan Puerto Rico, Philadelphia Pa. and Fairbanks Alaska).
By the way for some reason going down is always slower and harder than going up.
Viewing 15 posts - 18,646 through 18,660 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply