August 6, 2010 at 4:26 am
Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!Wish me luck!!
ACK! Lynn has Shorttimers Disease!
Much luck on your new position. @=)
August 6, 2010 at 4:29 am
Good luck to Steve on the PASS interview. Jack, I'm sure yours went fine.
And I'm glad my taboo tech discussion helped someone and spawned even further interesting discussions. @=) Thanks for that code, Jack. It's not how I usually code because I hate having to figure out which ON clause goes with which JOIN clause, but it does bring up an interesting point.
August 6, 2010 at 5:15 am
Steve Jones - Editor (8/5/2010)
Wish me luck. My PASS Board interview is tomorrow. We'll see if I'm still in the running after that.
Best of luck Steve. I don't think you need it, but you have it anyway.
"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
August 6, 2010 at 5:16 am
Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!Wish me luck!!
Excellent! Have fun at the new place and best of luck to you.
"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
August 6, 2010 at 6:36 am
In a total change of topic.
Out of the blue this a.m., I suddenly wanted Circus Peanuts. So, what is the one candy that you want right now?
August 6, 2010 at 6:40 am
Brandie Tarvin (8/6/2010)
In a total change of topic.Out of the blue this a.m., I suddenly wanted Circus Peanuts. So, what is the one candy that you want right now?
Today's Random Confectionery!
Jelly Belly jelly beans. Yum! Sorry, did you say something?
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
August 6, 2010 at 6:42 am
Whispers.
What are circus peanuts?
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
August 6, 2010 at 6:43 am
GilaMonster (8/6/2010)
Gianluca Sartori (8/6/2010)
GilaMonster (8/6/2010)
Jack Corbett (8/5/2010)
AHHHHHH! You said a swear word!!! Access.There's nothing wrong with Access when used appropriately. The problem is it's seldom used appropriately.
Access is often a trojan horse that allows non-tech people to create small data-driven applications outside the IT department.
It almost always means it's horribly designed, horribly coded and sooner or later it will run out of control.
See 'used appropriately'. If they didn't have Access, they'd be creating their databases in Excel.
cue powerpivot...
---------------------------------------------------------
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."
August 6, 2010 at 6:43 am
GilaMonster (8/6/2010)
Jack Corbett (8/5/2010)
AHHHHHH! You said a swear word!!! Access.
There's nothing wrong with Access when used appropriately. The problem is it's seldom used appropriately.[/q
I agree that there is a place for Access, but the issue is that typically Access databases become mission critical and IT doesn't even know about it until it is corrupted, etc...
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
August 6, 2010 at 6:45 am
Chris Morris-439714 (8/6/2010)
Brandie Tarvin (8/6/2010)
In a total change of topic.Out of the blue this a.m., I suddenly wanted Circus Peanuts. So, what is the one candy that you want right now?
Today's Random Confectionery!
Jelly Belly jelly beans. Yum! Sorry, did you say something?
I've been enamored of Aero bars lately, but what I really want is Turkish Delight. There's a little farmer's market joint up by Niagara-on-the-lake that has a whole table covered with the stuff that they make out of fruit juices....heaven....
---------------------------------------------------------
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."
August 6, 2010 at 6:46 am
GilaMonster (8/6/2010)
Gianluca Sartori (8/6/2010)
GilaMonster (8/6/2010)
Jack Corbett (8/5/2010)
AHHHHHH! You said a swear word!!! Access.There's nothing wrong with Access when used appropriately. The problem is it's seldom used appropriately.
Access is often a trojan horse that allows non-tech people to create small data-driven applications outside the IT department.
It almost always means it's horribly designed, horribly coded and sooner or later it will run out of control.
See 'used appropriately'. If they didn't have Access, they'd be creating their databases in Excel.
You must have stopped in at my place of work. :w00t:
They quit putting Access in the Std image, so we have more done in Excel.
But some still 'request' Access, and then the ripple starts as other users need it to use the db.
You can do horrible things in SQL or SQL Express just the same, it's probably just people get creative with what they have available.
And usually someone who has SQL server has some training.
Greg E
August 6, 2010 at 6:51 am
Steve, Wish you the best with the Interview. I do not think you need it. I am sure you will do good.
Lynn, Wish you the very best at your new Gig.
-Roy
August 6, 2010 at 6:53 am
GilaMonster (8/6/2010)
What are circus peanuts?
A marshmallow-like lump of sugar shaped into a peanut shape.
Here are links to some images.
August 6, 2010 at 6:54 am
GilaMonster (8/6/2010)
Whispers.What are circus peanuts?
An orange marshmellowy type makeup shaped like a peanut - a child's delight.
Anyway, I am fond of "gummy" anything at the moment. New little candy store downtown in my hometown that has unique and long-forgotten sweets. My favorites are "gummy" butterflies and "gummy" cola bottles.
-- You can't be late until you show up.
August 6, 2010 at 6:56 am
Jack Corbett (8/6/2010)
I agree that there is a place for Access, but the issue is that typically Access databases become mission critical and IT doesn't even know about it until it is corrupted, etc...
Tell me about it. I've seen it happens when people don't want to wait for official IT development or when they decide they don't want to trust the numbers coming out of the DB (hey, we can fudge this number any way we want if we use our own database).
And then they wonder why they can't recover their data when it gets hosed. Because it never occurred to them to back it up.
Viewing 15 posts - 17,191 through 17,205 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply