September 25, 2015 at 1:43 am
BWFC (9/25/2015)
Thanks for the congratulations everybody. I think the scariest thing about how far I've come in the last two and half years is realising how far I've got to go :ermm:I don't think I'm going to look too far in to Jet though.
Congratulations geezer, and happy Friday π
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 25, 2015 at 5:25 am
SQLRNNR (9/24/2015)
Lynn Pettis (9/24/2015)
Alvin Ramard (9/24/2015)
Matt Miller (#4) (9/23/2015)
Alvin Ramard (9/23/2015)
Steve Jones - SSC Editor (9/23/2015)
Lynn Pettis (9/23/2015)
I assume you are talking about the Jet thread. Do you think any of us have gotten out line?
Well, since I'm about 2 days out of touch and 40 posts, I can't say for sure. I don't think I've seen anything in there, but I sense frustration with some of you, including you, Lynn, which is the time to stop posting.
I'd hope you can rationally and calmly ask for something. There is some legitimate debate in what the OP noted, though he/she continues to change directions and use new examples instead of being able to explain themselves. I sense some struggle with English in there as well.
I haven't caught up, but I'd prefer to see someone actually debate the census example, give some idea of costs of building this. Look at how many people have Perl or ODBC programming skills. I think that might explain some of the rational for choosing, or not choosing the method.
Certainly if you have time and skill, but no money, creating solutions can be found. I've seen companies do well on Acess/MDB up to a point.
Steve, the OP made is clear. There is NO cost to implementing this.
I'm guessing at least a few of us don't agree.
There are also some fairly clear false statements in what he claims to be able to do with it, and none of valid points being advanced hold any weight whatsoever. After 3 or 4 posts early on in there, it felt more like banter or fish stories from OP than a true debate. If he is really building this out in a real professional setting, this borders on prof misconduct in my book, so I bowed out. no backup, no DR, security is a fantasy, and zero concurrency to speak of.
If or rather when that gem blows up, the customer/user he built this for will be SOL with a lot of data up in smoke.
In one of his responses, he says something about a bank. OMG!!!! That's scary!!!!
Not as bad as what he said about me, and I am not talking about the "she" comment.
I tend to agree. That one was a bit over the top. But then I think "TROLL"
Yeah, I saw that and it was pretty rude. Again, I had to fight the urge to post because I knew that thread would suck me in.
September 25, 2015 at 5:49 am
I've been wanting to pile into that topic, but keep restraining myself...
Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow to the Fuehrer? Try to finally shut it down...
Steve: That topic lead me to wish there was an "ignore topic" option, something to "hide" topics that have gone off the rails like that. I'm sure it sounds like a nice idea, but I'd also bet that:
A) The site Devs have much more important things to work on
B) It's nowhere *near* as easy as it sounds
Unrelated and getting back off-topic here...
Which do you folks think I should try to get the wife to do this Sunday? Michigan Renaissance Festival (ends next weekend) for which we have free passes, or Michigan Gun and Knife show out in Novi? Both are probably about an hour drive...
September 25, 2015 at 6:00 am
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
WayneS (9/23/2015)
Eirikur Eiriksson (9/23/2015)
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
This made me giggle*cough*:cool:
Come on Jason, don't be shy, pitch one of your good comments:-P in here, I've only done few millions (Β£) worth of licensing deals with MS;-)
π
Now now... we don't need to be encouraging him.
Wayne, you know that sometimes a little push is enough to make things happen...
π
..and normally we don't need to be encouraging him π
Where is the devil emoji?
Apparently now you are an angel:-P
π
September 25, 2015 at 6:26 am
jasona.work (9/25/2015)
I've been wanting to pile into that topic, but keep restraining myself...Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow to the Fuehrer? Try to finally shut it down...
Steve: That topic lead me to wish there was an "ignore topic" option, something to "hide" topics that have gone off the rails like that. I'm sure it sounds like a nice idea, but I'd also bet that:
A) The site Devs have much more important things to work on
B) It's nowhere *near* as easy as it sounds
Unrelated and getting back off-topic here...
Which do you folks think I should try to get the wife to do this Sunday? Michigan Renaissance Festival (ends next weekend) for which we have free passes, or Michigan Gun and Knife show out in Novi? Both are probably about an hour drive...
I vote Fun Show!
"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 25, 2015 at 6:28 am
Grant Fritchey (9/25/2015)
jasona.work (9/25/2015)
I've been wanting to pile into that topic, but keep restraining myself...Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow to the Fuehrer? Try to finally shut it down...
Steve: That topic lead me to wish there was an "ignore topic" option, something to "hide" topics that have gone off the rails like that. I'm sure it sounds like a nice idea, but I'd also bet that:
A) The site Devs have much more important things to work on
B) It's nowhere *near* as easy as it sounds
Unrelated and getting back off-topic here...
Which do you folks think I should try to get the wife to do this Sunday? Michigan Renaissance Festival (ends next weekend) for which we have free passes, or Michigan Gun and Knife show out in Novi? Both are probably about an hour drive...
I vote Fun Show!
Well that's helpful...
I actually enjoy both...
The frauleins at the Ren Fest with beer mugs in their hands...
The fun "toys" at the Gun show...
Hmmm...
September 25, 2015 at 6:42 am
jasona.work (9/25/2015)
Grant Fritchey (9/25/2015)
jasona.work (9/25/2015)
I've been wanting to pile into that topic, but keep restraining myself...Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow to the Fuehrer? Try to finally shut it down...
Steve: That topic lead me to wish there was an "ignore topic" option, something to "hide" topics that have gone off the rails like that. I'm sure it sounds like a nice idea, but I'd also bet that:
A) The site Devs have much more important things to work on
B) It's nowhere *near* as easy as it sounds
Unrelated and getting back off-topic here...
Which do you folks think I should try to get the wife to do this Sunday? Michigan Renaissance Festival (ends next weekend) for which we have free passes, or Michigan Gun and Knife show out in Novi? Both are probably about an hour drive...
I vote Fun Show!
Well that's helpful...
I actually enjoy both...
The frauleins at the Ren Fest with beer mugs in their hands...
The fun "toys" at the Gun show...
Hmmm...
FUUUNNN Show!
"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 25, 2015 at 6:42 am
jasona.work (9/25/2015)
Grant Fritchey (9/25/2015)
jasona.work (9/25/2015)
I've been wanting to pile into that topic, but keep restraining myself...Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow to the Fuehrer? Try to finally shut it down...
Steve: That topic lead me to wish there was an "ignore topic" option, something to "hide" topics that have gone off the rails like that. I'm sure it sounds like a nice idea, but I'd also bet that:
A) The site Devs have much more important things to work on
B) It's nowhere *near* as easy as it sounds
Unrelated and getting back off-topic here...
Which do you folks think I should try to get the wife to do this Sunday? Michigan Renaissance Festival (ends next weekend) for which we have free passes, or Michigan Gun and Knife show out in Novi? Both are probably about an hour drive...
I vote Fun Show!
Well that's helpful...
I actually enjoy both...
The frauleins at the Ren Fest with beer mugs in their hands...
The fun "toys" at the Gun show...
Hmmm...
I'd go for the Renaissance festival. However, I guess it's more important what she would enjoy.
September 25, 2015 at 6:58 am
Dang...
Now I'm going to have to leave it to the wife which one we go to Sunday (Saturday is booked.)
Of course, the Ren Fest last weekend is next weekend, the Gun (Fun!) show is this weekend only. So maybe some gentle nudging is in order...
September 25, 2015 at 8:03 am
jasona.work (9/25/2015)
Dang...Now I'm going to have to leave it to the wife which one we go to Sunday (Saturday is booked.)
Of course, the Ren Fest last weekend is next weekend, the Gun (Fun!) show is this weekend only. So maybe some gentle nudging is in order...
If it were me, I'd go to the gun show. It doesn't come to Novi all that often and it's usually a big one, so it's worth the trip. I think that one has about 900 tables, which is bigger than just about any other one around. You do have one more weekend for Ren Fest.
Thank you, Jason, for making me aware of the gun show in Novi. My wife is going up north for a women's retreat, so it's just my daughter and I think weekend. We had already planned a trip to the range, which is just north of Novi, so it's only logical that we go to the show. Hmmm...me at a gun show and no wife to tell me "no" to anything. This could turn into a very fun and expensive weekend. :-D:-D:-D
September 25, 2015 at 8:04 am
jasona.work (9/25/2015)
I've been wanting to pile into that topic, but keep restraining myself...Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow to the Fuehrer? Try to finally shut it down...
Steve: That topic lead me to wish there was an "ignore topic" option, something to "hide" topics that have gone off the rails like that. I'm sure it sounds like a nice idea, but I'd also bet that:
A) The site Devs have much more important things to work on
B) It's nowhere *near* as easy as it sounds
Unrelated and getting back off-topic here...
Which do you folks think I should try to get the wife to do this Sunday? Michigan Renaissance Festival (ends next weekend) for which we have free passes, or Michigan Gun and Knife show out in Novi? Both are probably about an hour drive...
Yeah, for heavy posters, removing a thread can be painful. I wish there was an ignore as well.
September 25, 2015 at 8:06 am
Steve Jones - SSC Editor (9/25/2015)
jasona.work (9/25/2015)
I've been wanting to pile into that topic, but keep restraining myself...Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow to the Fuehrer? Try to finally shut it down...
Steve: That topic lead me to wish there was an "ignore topic" option, something to "hide" topics that have gone off the rails like that. I'm sure it sounds like a nice idea, but I'd also bet that:
A) The site Devs have much more important things to work on
B) It's nowhere *near* as easy as it sounds
Unrelated and getting back off-topic here...
Which do you folks think I should try to get the wife to do this Sunday? Michigan Renaissance Festival (ends next weekend) for which we have free passes, or Michigan Gun and Knife show out in Novi? Both are probably about an hour drive...
Yeah, for heavy posters, removing a thread can be painful. I wish there was an ignore as well.
I can lose some weight if it will help. π
_______________________________________________________________
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/
September 25, 2015 at 8:26 am
Ed Wagner (9/25/2015)
jasona.work (9/25/2015)
Dang...Now I'm going to have to leave it to the wife which one we go to Sunday (Saturday is booked.)
Of course, the Ren Fest last weekend is next weekend, the Gun (Fun!) show is this weekend only. So maybe some gentle nudging is in order...
If it were me, I'd go to the gun show. It doesn't come to Novi all that often and it's usually a big one, so it's worth the trip. I think that one has about 900 tables, which is bigger than just about any other one around. You do have one more weekend for Ren Fest.
Thank you, Jason, for making me aware of the gun show in Novi. My wife is going up north for a women's retreat, so it's just my daughter and I think weekend. We had already planned a trip to the range, which is just north of Novi, so it's only logical that we go to the show. Hmmm...me at a gun show and no wife to tell me "no" to anything. This could turn into a very fun and expensive weekend. :-D:-D:-D
Ooohhh! Now I need to figure out a way to keep the wife from going!
Maybe finally get the other range-queen gun I've been wanting...
But, yeah, we've decided to do the gun show Sunday, Ren Fest next weekend.
September 25, 2015 at 8:28 am
Steve Jones - SSC Editor (9/25/2015)
jasona.work (9/25/2015)
I've been wanting to pile into that topic, but keep restraining myself...Hmm. Maybe we need to Godwin that topic, and bring in a comparison somehow to the Fuehrer? Try to finally shut it down...
Steve: That topic lead me to wish there was an "ignore topic" option, something to "hide" topics that have gone off the rails like that. I'm sure it sounds like a nice idea, but I'd also bet that:
A) The site Devs have much more important things to work on
B) It's nowhere *near* as easy as it sounds
Unrelated and getting back off-topic here...
Which do you folks think I should try to get the wife to do this Sunday? Michigan Renaissance Festival (ends next weekend) for which we have free passes, or Michigan Gun and Knife show out in Novi? Both are probably about an hour drive...
Yeah, for heavy posters, removing a thread can be painful. I wish there was an ignore as well.
I'm not even subscribed to it, but when it pops up in the "new posts for today" list, I just have to click, even though I *know* there's just going to be more "noise" from the OP to dance around actually answering a question...
At this point, that topics turned into an episode of Jerry Springer...
:hehe:
September 25, 2015 at 8:31 am
Eirikur Eiriksson (9/25/2015)
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
WayneS (9/23/2015)
Eirikur Eiriksson (9/23/2015)
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
This made me giggle*cough*:cool:
Come on Jason, don't be shy, pitch one of your good comments:-P in here, I've only done few millions (Β£) worth of licensing deals with MS;-)
π
Now now... we don't need to be encouraging him.
Wayne, you know that sometimes a little push is enough to make things happen...
π
..and normally we don't need to be encouraging him π
Where is the devil emoji?
Apparently now you are an angel:-P
π
SOM
No. No way. Not Jason
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 15 posts - 50,746 through 50,760 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply