|
Not everything that's right is obvious. Patterns are a codified set of guidelines and advice, including information about when they're appropriate, and they're useful precisely because it's not always obvious what the right answer is without some guidelines to help you.
I think it's all about your last sentence, people being prescriptive with any guidelines, whether that be design patterns or coding standards or anything else to do with work, loses the point of what the guidelines were there for in the first place.
|
|
|
|
|
I had this argument while I was still in college. A team member had decided the entire major was worthless because we had to use prescribed solutions to everything. Apparently having missed the point that these general solutions can (and should be) modified to fit a situation, and the point of our major was identifying when a pattern would be useful and exactly how to implement it in that situation to best benefit the software and our own sanity.
I mean hell, look at adaptor. It's a stopgap solution to keep you from having to re-write libraries and nothing more. This isn't a sacred text it's a few useful ideas.
But yeah, doesn't stop people from treating it like their personal bible.
|
|
|
|
|
Thou shalt follow the hallowed word of the holy pattern! 
|
|
|
|
|
So, a complex query fails with
Quote: Msg 8152, Level 16, State 13, Line 1
String or binary data would be truncated.
Now, which column is it? Surely the engine knows which column it is and could add it to the error message?
We're gonna fix it soon, honest![^]
|
|
|
|
|
 
What do you get when you cross a joke with a rhetorical question?
|
|
|
|
|
Soon, very soon!
|
|
|
|
|
Isn't that what varchar(MAX) is for?
|
|
|
|
|
NVARCHAR(MAX) is a good think, but has two disadvantages:
1. You can't control where the data stored, in-page or as BLOB
2. Every size is passed so you can't use it for 'sanity' check (where data can not be longer than n)
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
Kornfeld Eliyahu Peter wrote: BLOB
Don't you mean CLOB?
Whether I think I can, or think I can't, I am always bloody right!
|
|
|
|
|
I mean like BLOB - out of page...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
If you are suffering from this 10 years - you may start using Profiler...it can help!
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
You can always switch to Oracle. You'll develop a whole new set of gripes. 
|
|
|
|
|
Been there, done that.
Dual - I mean, FFS!
|
|
|
|
|
I understand the reasoning behind the Dual table.
Instead of adding a load of exceptions with possible "features" to the parser, they've added a readonly dummy table.
My personal gripes revolve mostly around the fact that you have a different set of Types depending on whether you're doing pure SQL, procedures or packages.
|
|
|
|
|
Ha! I didn't expect that! Quite amusing though all the same.
"The whole idea that carbon dioxide is the main cause of the recent global warming is based on a guess that was proved false by empirical evidence during the 1990s." climate-models-go-cold
|
|
|
|
|
Munchies_Matt wrote: I didn't expect that!
Really?
|
|
|
|
|
No, I thought we were a better team than that, but apparently not.
"The whole idea that carbon dioxide is the main cause of the recent global warming is based on a guess that was proved false by empirical evidence during the 1990s." climate-models-go-cold
|
|
|
|
|
An Irishman walks into a bar in Dublin, orders three pints of Guinness and sits in the back of the room, drinking a sip out of each one in turn. When he finished all three, he comes back to the bar and orders three more.
The bartender says to him, ‘You know, a pint goes flat after I draw it; It would taste better if you bought one at a time.’ The Irishman replies, ‘Well, you see, I have two brothers. One is in America, the other in Australia, and I’m here in Dublin. When we all left home, we promised that we’d drink this way to remember the day we all drank together.’
The bartender admits that this is a nice custom, and leaves it there. The Irishman becomes a regular in the bar and always drinks the same way: he orders three pints and drinks the three pints by taking drinks from each of them in turn.
One day, he comes in and orders two pints. All the other regulars’ in the bar notice and fall silent. When he comes back to the bar for the second round, the bartender says, ‘I don’t want to intrude on your grief, but I wanted to offer my condolences on your great loss.’
The Irishman looks confused for a moment, then the light dawns in his eye and he laughs. ‘Oh, no,’ he says, ‘Everyone is fine. It’s me……..I’ve quit drinking!’
|
|
|
|
|
|
What the hell happened to England team? So disappointing 
|
|
|
|
|
No, they only booked the team hotel for the first week anyway... 
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Disappointing maybe, it's your point of view, I bet the Uruguayans have a completely different view on the subject.
Unexpected? Not really.
|
|
|
|
|
What happened? They won?!
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
|
Once again the England team have gone and done the worst thing they possibly could have done - made me do basic arithmetic and probabilities!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
