Are the posted questions getting worse?
-
GilaMonster (1/13/2011)
Happened here a few years back. The 1c and 2c coins were discontinued and are no longer legal tender. Shops are required to round down a customer's total bill to the 5c.We lost 1¢ and 2¢ coins around 1990, and the 5¢ coin bit the dust 5 years ago or so.
Electronic transactions (e.g. EFTPOS) go through completely unrounded, but cash transactions use Swedish rounding: 1,2,3,4¢ is rounded down; 6,7,8,9¢ is rounded up; and individuals can decide which way to round 5¢. Most places round down.
We don't have $1 notes either: the $1 and $2 coins are golden in colour - so charity events often ask for a 'gold coin' donation e.g. at a sausage sizzle. I also dislike boring currency notes (though Australia's are a bit garish IMH and unbiased O).
-
WayneS (1/12/2011)
Stefan Krzywicki (1/12/2011)
I'm just outside Boston, we're certainly snowed in here.How much did you get?
Grant / Adam - how much did you'll get?
I don't know what the official number is, but walking around the paths I've shoveled from the house to the furnace, I'd say it's about 18 inches. Certainly more than a foot.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
SQLkiwi (1/12/2011)
Grant Fritchey (1/12/2011)
Anyone interested in reading a short blog post? I'm a little nervous about putting this one up. I'm talking about how heaps are stored and I've made mistakes there in the past.I see Gail has already offered, but if you want a second set of eyes, post a link or mail the text to SQLkiwi@gmail.com
Thank you very much. I've already shot this one in the head. I was working off a bad notion of how heaps are stored, so the whole thing was completely flawed. I'm just glad I had enough discomfort to wait on publishing it. I'd come off sound a little more stupid than usual.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
I was monitoring the snowfall in New England with interest yesterday for a few reasons:
1. Originally from there so I'm always interested.
2. Relatives and friends there so I like to give them grief when it's bad there and sunny here in FL. Not real warm yesterday or today here, but not snowing:-D
3. Could be heading back for a visit at any time because of family health.
4. Considering re-locating back there and events like 2 feet of snow help reduce that urge;-)
Edit: Fixed typo and grammar
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 -
Grant Fritchey (1/13/2011)
Thank you very much. I've already shot this one in the head. I was working off a bad notion of how heaps are stored, so the whole thing was completely flawed. I'm just glad I had enough discomfort to wait on publishing it. I'd come off sound a little more stupid than usual.I've written more than one entry based on a faulty assumption I had made to begin with. The learning experience is often worth writing about - I doubt you are the only person in the world with that notion, whatever it was.
-
Ray K (1/12/2011)
Hey Threadizens -- I could use some advice on what I hope is a quick and easy question!Thank you, fellow Threadizens, for coming to my rescue -- and I'm not just talking about getting my simple question answered.
I've been Celkoed again.
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/ -
Ray K (1/13/2011)
Ray K (1/12/2011)
Hey Threadizens -- I could use some advice on what I hope is a quick and easy question!Thank you, fellow Threadizens, for coming to my rescue -- and I'm not just talking about getting my simple question answered.
I've been Celkoed again.
In Celko's defense, I actually learned something from it for a change. I had never seen the "MERGE INTO" construct :w00t:
-
Steve Jones - SSC Editor (1/12/2011)
I can't afford Benjamins. We're in a recession, so you have to make do with Jacksons.If you want to work for a half hour, I am happy to email some more Jacksons to you. How many .jpgs do you want?
LOL!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
SQLkiwi (1/13/2011)
Grant Fritchey (1/13/2011)
Thank you very much. I've already shot this one in the head. I was working off a bad notion of how heaps are stored, so the whole thing was completely flawed. I'm just glad I had enough discomfort to wait on publishing it. I'd come off sound a little more stupid than usual.I've written more than one entry based on a faulty assumption I had made to begin with. The learning experience is often worth writing about - I doubt you are the only person in the world with that notion, whatever it was.
I'm putting together a blog post on failed blog posts. So it's not a complete loss.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Grant Fritchey (1/13/2011)
SQLkiwi (1/13/2011)
Grant Fritchey (1/13/2011)
Thank you very much. I've already shot this one in the head. I was working off a bad notion of how heaps are stored, so the whole thing was completely flawed. I'm just glad I had enough discomfort to wait on publishing it. I'd come off sound a little more stupid than usual.I've written more than one entry based on a faulty assumption I had made to begin with. The learning experience is often worth writing about - I doubt you are the only person in the world with that notion, whatever it was.
I'm putting together a blog post on failed blog posts. So it's not a complete loss.
I already put together such a post but it failed too so you can't read it!! 😛
Alvin Ramard
Memphis PASS Chapter[/url]All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.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]
-
Ray K (1/13/2011)
Ray K (1/12/2011)
Hey Threadizens -- I could use some advice on what I hope is a quick and easy question!Thank you, fellow Threadizens, for coming to my rescue -- and I'm not just talking about getting my simple question answered.
I've been Celkoed again.
Join the club. Most of us have been. 🙁
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2 -
Jeff Moden (1/12/2011)
Steve Jones - SSC Editor (1/12/2011)
I think that green is an appropriate color for the USIt would be nice if they kept them Green. Have you seen how much Red there actually is in the "new" Tens? Looks almost like Monopoly money.
Also, have you "felt" the new pennies? They don't even weigh as much as a penny should. I know they're not worth much to begin with but my word!
They're trash money at this point. If people see money on the ground, they stop and pick it up. If they see a penny on the ground, they leave it there. No-one wants them. People are happy for tip cups or "have a penny/take a penny" cups because it means they don't have to take the pennies with them. Charities are willing to take them because of the volume they get. People who get tips tolerate it for the same reason, plus the fact that they're severly underpaid, but that's about it.
--------------------------------------
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 -
GilaMonster (1/13/2011)
Steve Jones - SSC Editor (1/12/2011)
They are hoping that pennies get EOL'd. We'll see if it ever happens.Happened here a few years back. The 1c and 2c coins were discontinued and are no longer legal tender. Shops are required to round down a customer's total bill to the 5c.
So if my shopping bill comes to R148.88, I pay R148.85.
Ok, our 5c is worth less than one US cent, but still...
I have so much trouble with US money every time I visit, because all the notes are same size, same colour. Here the size of the notes increase as the value increases and they're all brightly coloured.
There was a legal case here in the US a year or two ago where a judge ruled that the US has to start making different denomination bills different sized because the current system is unfair to the blind. I believe that's still going through appeals though.
--------------------------------------
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 -
This place rocks... I ask for help and I get tons of help. This is the second time I asked for help here and both the times I was pointed to the right direction. 🙂
I have been noticing that the twitter #sqlhelp tag is over rated. SSC rocks... !!!!!
-Roy
-
Just after getting in to work today, one of our servers died. Completely. Might be a long night. Luckily, it only has replicated data on it, but still... 🙁
Investigating options.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2
Viewing 15 posts - 23,146 through 23,160 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply