July 27, 2014 at 11:20 am
Jeff Moden (7/26/2014)
SQLRNNR (7/26/2014)
But the BS around rep just sucks.That might be where the word "Overflow" comes from. 😛
So they named it stack overflow because it is really just Diarrhea?:Whistling:
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
July 28, 2014 at 6:02 am
SQLRNNR (7/27/2014)
Jeff Moden (7/26/2014)
SQLRNNR (7/26/2014)
But the BS around rep just sucks.That might be where the word "Overflow" comes from. 😛
So they named it stack overflow because it is really just Diarrhea?:Whistling:
The last time I checked out stack overflow, it was just that. Maybe it got better since then, but I don't use it for anything so I wouldn't know.
July 28, 2014 at 6:35 am
Ed Wagner (7/28/2014)
SQLRNNR (7/27/2014)
Jeff Moden (7/26/2014)
SQLRNNR (7/26/2014)
But the BS around rep just sucks.That might be where the word "Overflow" comes from. 😛
So they named it stack overflow because it is really just Diarrhea?:Whistling:
The last time I checked out stack overflow, it was just that. Maybe it got better since then, but I don't use it for anything so I wouldn't know.
I like Stack Overflow, they've done a great job, I've lost count over the answers I've gotten there. I'm not saying they're perfect, but the amount of loathing they get from you guys is just not proportionate to any actual problems over there that I can see, so I'm wondering what the real deal is? Did they treat some of you in a manner that was determined to be below your expectations or something? Not fawn over the 5 digit SSC rep or something?
July 28, 2014 at 6:37 am
Jeff Moden (7/25/2014)
Heh... isn't "reconciliation" how they found out that some BitCoin bank had been seriously whacked because the current balance wasn't immediately calculated to the penny? 😉I'm with those that insist there's no reason in the world in this day and age why balances shouldn't be instantaneously correct.
I have a sneaking suspicion that instantaneously correct balances ultimately don't scale, can't prove it though!
July 28, 2014 at 6:40 am
I'm interested in this answer as well. I have definitely encountered a fair amount of pretentious responses and posts there (then again, look at this thread's topic), but they are (both) outweighed by the indispensable amount of help I have received from a typically very helpful and kind community.
July 28, 2014 at 6:41 am
bantrim (7/28/2014)
I'm interested in this answer as well. I have definitely encountered a fair amount of pretentious responses and posts there (then again, look at this thread's topic), but they are (both) outweighed by the indispensable amount of help I have received from a typically very helpful and kind community.
Welcome to the thread!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 28, 2014 at 6:43 am
patrickmcginnis59 10839 (7/28/2014)
Ed Wagner (7/28/2014)
SQLRNNR (7/27/2014)
Jeff Moden (7/26/2014)
SQLRNNR (7/26/2014)
But the BS around rep just sucks.That might be where the word "Overflow" comes from. 😛
So they named it stack overflow because it is really just Diarrhea?:Whistling:
The last time I checked out stack overflow, it was just that. Maybe it got better since then, but I don't use it for anything so I wouldn't know.
I like Stack Overflow, they've done a great job, I've lost count over the answers I've gotten there. I'm not saying they're perfect, but the amount of loathing they get from you guys is just not proportionate to any actual problems over there that I can see, so I'm wondering what the real deal is? Did they treat some of you in a manner that was determined to be below your expectations or something? Not fawn over the 5 digit SSC rep or something?
They are some pretty arrogant mods over there. Topics get closed too soon and the manner on which newbies are told their questions are not up to standards by some people over there... No, thank you.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 28, 2014 at 6:49 am
😀
July 28, 2014 at 7:01 am
bantrim (7/28/2014)
I'm interested in this answer as well. I have definitely encountered a fair amount of pretentious responses and posts there (then again, look at this thread's topic), but they are (both) outweighed by the indispensable amount of help I have received from a typically very helpful and kind community.
Welcome to The Thread as well. As you are new here a very brief history. Yes, this thread began as a rant about questions being posted SSC. It has also grown from there in ways the title doesn't express. This has become The Water Cooler for many of us. Yes we still rant about some of the questions and OPs, but it allows us to let off steam, refocus, and dive back in to try and help some more. It has also server as location where we have asked others to help with questions that we have found ourselves out of our depth, we aren't all masters of every aspect of MS SQL Server.
We have also learned many things about each other during the time this thread has been active. If you have a few months you may want to start at the beginning. It would also help when you get confused when we talk about the TitD (the Tent in the Desert) and the Guard Hippo that protects it (last I knew he was wearing a pink tutu).
Again, welcome and enjoy your stay.
July 28, 2014 at 7:05 am
Lynn Pettis (7/28/2014)
bantrim (7/28/2014)
I'm interested in this answer as well. I have definitely encountered a fair amount of pretentious responses and posts there (then again, look at this thread's topic), but they are (both) outweighed by the indispensable amount of help I have received from a typically very helpful and kind community.Welcome to The Thread as well. As you are new here a very brief history. Yes, this thread began as a rant about questions being posted SSC. It has also grown from there in ways the title doesn't express. This has become The Water Cooler for many of us. Yes we still rant about some of the questions and OPs, but it allows us to let off steam, refocus, and dive back in to try and help some more. It has also server as location where we have asked others to help with questions that we have found ourselves out of our depth, we aren't all masters of every aspect of MS SQL Server.
We have also learned many things about each other during the time this thread has been active. If you have a few months you may want to start at the beginning. It would also help when you get confused when we talk about the TitD (the Tent in the Desert) and the Guard Hippo that protects it (last I knew he was wearing a pink tutu).
Again, welcome and enjoy your stay.
🙂
I see I have much catching up to do then. I have pretty well just lurked and read the daily email, but noticed this thread (The Thread?) is always sitting there at the bottom, and thought "hey, why not?".
July 28, 2014 at 7:06 am
patrickmcginnis59 10839 (7/25/2014)
Sean Lange (7/25/2014)
patrickmcginnis59 10839 (7/25/2014)
Getting the account balance temporarily wrong isn't a big deal, that is what the end of day reconciliation is for. And an overdraft from an account is far more likely to occur because two ATMs are being used at once than because of a uncommitted read from a database.
He might have a point here, isn't that what folks talk about regarding partitioned mode? Granted, he doesn't take into consideration page splits but that was also mentioned in the thread, so folks are covering the topic at least.
I would completely disagree here. I have real world experience here that directly contradicts this. Getting the balance correct to the penny real-time is critical when it comes to plastic cards. I saw overdraft charges in the hundreds weekly because of littering a financial application with NOLOCK. In a system with lots of activity this is not a rare thing, it is real and it happens a lot more than many people think. You can't settle a card rejection at the end of the day when the person trying to make a purchase has just been denied. Talk about some pissed off people.
His point is that getting balances correct to the penny is what reconciliations are for, and he has a point, because number one, reconciliations ARE going to get the funds, and number two, folks with plastic are legally obligated for their charges (as opposed to for instance that related bitcoin thread, folks are not tied to an anonymous account, and reconciliations don't do squat in that case).
I remember getting zapped by this, because I did two small transactions on my card, and then a third larger that overdrafted my account. The bank happily processed the third first and was able to hit me with 3 overdrafts despite applying the transactions out of chronological order (date/time) because they applied it ordered by amount descending, because its their business and I had legitimately overdrafted the account. So in my opinion, the guy is reporting reality.
I am talking about balances in the other direction. Sure in your case you were held responsible because you had three transactions that were approved which took over the limit. I am talking about the other direction when a transaction is denied because of insufficient funds caused by dirty reads.
The situation I worked with was health care debit cards and this type of thing happened. We denied prescription coverage when the account had enough funds. You can imagine how hostile things got when transactions are denied but there are enough funds to cover it.
_______________________________________________________________
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/
July 28, 2014 at 7:08 am
bantrim (7/28/2014)
Lynn Pettis (7/28/2014)
bantrim (7/28/2014)
I'm interested in this answer as well. I have definitely encountered a fair amount of pretentious responses and posts there (then again, look at this thread's topic), but they are (both) outweighed by the indispensable amount of help I have received from a typically very helpful and kind community.Welcome to The Thread as well. As you are new here a very brief history. Yes, this thread began as a rant about questions being posted SSC. It has also grown from there in ways the title doesn't express. This has become The Water Cooler for many of us. Yes we still rant about some of the questions and OPs, but it allows us to let off steam, refocus, and dive back in to try and help some more. It has also server as location where we have asked others to help with questions that we have found ourselves out of our depth, we aren't all masters of every aspect of MS SQL Server.
We have also learned many things about each other during the time this thread has been active. If you have a few months you may want to start at the beginning. It would also help when you get confused when we talk about the TitD (the Tent in the Desert) and the Guard Hippo that protects it (last I knew he was wearing a pink tutu).
Again, welcome and enjoy your stay.
🙂
I see I have much catching up to do then. I have pretty well just lurked and read the daily email, but noticed this thread (The Thread?) is always sitting there at the bottom, and thought "hey, why not?".
That's what it does. Hiding at the bottom, lurking, creeping and silently calling your attention. And then one day.....
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 28, 2014 at 7:10 am
Koen Verbeeck (7/28/2014)
bantrim (7/28/2014)
Lynn Pettis (7/28/2014)
bantrim (7/28/2014)
I'm interested in this answer as well. I have definitely encountered a fair amount of pretentious responses and posts there (then again, look at this thread's topic), but they are (both) outweighed by the indispensable amount of help I have received from a typically very helpful and kind community.Welcome to The Thread as well. As you are new here a very brief history. Yes, this thread began as a rant about questions being posted SSC. It has also grown from there in ways the title doesn't express. This has become The Water Cooler for many of us. Yes we still rant about some of the questions and OPs, but it allows us to let off steam, refocus, and dive back in to try and help some more. It has also server as location where we have asked others to help with questions that we have found ourselves out of our depth, we aren't all masters of every aspect of MS SQL Server.
We have also learned many things about each other during the time this thread has been active. If you have a few months you may want to start at the beginning. It would also help when you get confused when we talk about the TitD (the Tent in the Desert) and the Guard Hippo that protects it (last I knew he was wearing a pink tutu).
Again, welcome and enjoy your stay.
🙂
I see I have much catching up to do then. I have pretty well just lurked and read the daily email, but noticed this thread (The Thread?) is always sitting there at the bottom, and thought "hey, why not?".
That's what it does. Hiding at the bottom, lurking, creeping and silently calling your attention. And then one day.....
You're making it sound like a Stephen King novel. Does everyone float down here?
July 28, 2014 at 7:12 am
bantrim (7/28/2014)
Lynn Pettis (7/28/2014)
bantrim (7/28/2014)
I'm interested in this answer as well. I have definitely encountered a fair amount of pretentious responses and posts there (then again, look at this thread's topic), but they are (both) outweighed by the indispensable amount of help I have received from a typically very helpful and kind community.Welcome to The Thread as well. As you are new here a very brief history. Yes, this thread began as a rant about questions being posted SSC. It has also grown from there in ways the title doesn't express. This has become The Water Cooler for many of us. Yes we still rant about some of the questions and OPs, but it allows us to let off steam, refocus, and dive back in to try and help some more. It has also server as location where we have asked others to help with questions that we have found ourselves out of our depth, we aren't all masters of every aspect of MS SQL Server.
We have also learned many things about each other during the time this thread has been active. If you have a few months you may want to start at the beginning. It would also help when you get confused when we talk about the TitD (the Tent in the Desert) and the Guard Hippo that protects it (last I knew he was wearing a pink tutu).
Again, welcome and enjoy your stay.
🙂
I see I have much catching up to do then. I have pretty well just lurked and read the daily email, but noticed this thread (The Thread?) is always sitting there at the bottom, and thought "hey, why not?".
After "catching up" you may start asking yourself "why oh why?". 😀
_______________________________________________________________
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/
July 28, 2014 at 7:13 am
bantrim (7/28/2014)
Koen Verbeeck (7/28/2014)
bantrim (7/28/2014)
Lynn Pettis (7/28/2014)
bantrim (7/28/2014)
I'm interested in this answer as well. I have definitely encountered a fair amount of pretentious responses and posts there (then again, look at this thread's topic), but they are (both) outweighed by the indispensable amount of help I have received from a typically very helpful and kind community.Welcome to The Thread as well. As you are new here a very brief history. Yes, this thread began as a rant about questions being posted SSC. It has also grown from there in ways the title doesn't express. This has become The Water Cooler for many of us. Yes we still rant about some of the questions and OPs, but it allows us to let off steam, refocus, and dive back in to try and help some more. It has also server as location where we have asked others to help with questions that we have found ourselves out of our depth, we aren't all masters of every aspect of MS SQL Server.
We have also learned many things about each other during the time this thread has been active. If you have a few months you may want to start at the beginning. It would also help when you get confused when we talk about the TitD (the Tent in the Desert) and the Guard Hippo that protects it (last I knew he was wearing a pink tutu).
Again, welcome and enjoy your stay.
🙂
I see I have much catching up to do then. I have pretty well just lurked and read the daily email, but noticed this thread (The Thread?) is always sitting there at the bottom, and thought "hey, why not?".
That's what it does. Hiding at the bottom, lurking, creeping and silently calling your attention. And then one day.....
You're making it sound like a Stephen King novel. Does everyone float down here?
More like sinking.
_______________________________________________________________
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/
Viewing 15 posts - 44,791 through 44,805 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply