Are the posted questions getting worse?
-
Ed Wagner (8/11/2015)
Lynn Pettis (8/11/2015)
Ed Wagner (8/11/2015)
Alvin Ramard (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Ed Wagner (8/11/2015)
The silver spoons need to be ordered again. Better get at least a case.Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
I read that and I continually wonder why you and Lynn both continue to help this person. You guys put in way too much effort trying to help them and in return they put forth no effort, no learning and no details.
The whole quote from that is one of the more pathetic things I have seen. They got your code to work so they reverted to a simpler piece of code that doesn't work. :w00t:
Unfortunately I get your code to work.
Thank you for your script.
I reverted back to a simple script that is not really what I need.
I'm starting to wonder the same thing.
Would it be ok to suggest he have his boss contact me and I'll do it for a reasonable rate? Now he's asking for an Archive Delete Utility he can purchase.
Weak the force is. 🙁
I don't see why not. I've seen others do the same thing for other posts. Given the level of competence and sense of entitlement displayed thus far, however, I'd be cautious about investing a ton of time when you might not get paid.
BTW, I saw the most recent post, but I'm done.
I posted my suggested code. So far I got a thanks but no word as to whether or not he is using it or it works as he'd like.
Well I guess we now know who has the crystal ball. A simple "thanks" with no more code without questions? I think that means the problem is solved. Well done.
The comment about "missing the transaction" and loop *almost* made me post that the transaction was not what's really missing, but I was done. I had capitulated and let SSS (silver spoon syndrome) prevail. I don't want to take that approach with anyone, but it can be so very frustrating sometimes. Better than I just let it go.
Again, well done, sir.
But I left it open by saying it all depends on the situation and requirements. Oh, wait, there probably aren't any requirements.
But I also said that there are others ways depending on how much data is being kept versus how much is being deleted. Oh, wait, probably doesn't matter.
-
SQLRNNR (8/11/2015)
Just curious if anybody knows what a "SPAM DIG" happens to be? Is that like a clam dig?... got me thinking (I know, scary!) ...
Not sure I'll eat Spam again! 😉
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]
-
SQLRNNR (8/11/2015)
Just curious if anybody knows what a "SPAM DIG" happens to be? Is that like a clam dig?In simple terms, blacklisting
😎
-
Ed Wagner (8/11/2015)
Lynn Pettis (8/11/2015)
SQLRNNR (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Grant Fritchey (8/11/2015)
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
VARCHAR(1) and NVARCHAR(1) are my absolute favorite "stupid database design" problems. Seriously. Love them. I point and laugh and laugh. Weird how the database design people don't appreciate the humor.
I sort of get it when they allow NULL. I wouldn't design anything like that but I can understand where that comes from. But to allow variable length and force a single character just kills me. :-D:-D:-D
I especially love it when they use an NVARCHAR(1) to store a 0 or 1. Unfortunately, that's a real-life example.
It's not just an edge-case real life example either. I have seen something like this at just about every client I have had.
Using SQL Server, storing a 0,1, or null; sounds like a good use of the BIT data type to me.
Yes it does, doesn't it? You'd think it would be intuitive, but I guess it isn't to everyone.
Personally I might use Tinyint with a constraint. Bit doesn't play nice with SUM.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Lynn Pettis (8/11/2015)
Ed Wagner (8/11/2015)
Lynn Pettis (8/11/2015)
Ed Wagner (8/11/2015)
Alvin Ramard (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Ed Wagner (8/11/2015)
The silver spoons need to be ordered again. Better get at least a case.Here's a quote I don't think I've every seen before:
Unfortunately I get your code to work.
http://www.sqlservercentral.com/Forums/Topic1709884-3077-2.aspx#bm1710535
I read that and I continually wonder why you and Lynn both continue to help this person. You guys put in way too much effort trying to help them and in return they put forth no effort, no learning and no details.
The whole quote from that is one of the more pathetic things I have seen. They got your code to work so they reverted to a simpler piece of code that doesn't work. :w00t:
Unfortunately I get your code to work.
Thank you for your script.
I reverted back to a simple script that is not really what I need.
I'm starting to wonder the same thing.
Would it be ok to suggest he have his boss contact me and I'll do it for a reasonable rate? Now he's asking for an Archive Delete Utility he can purchase.
Weak the force is. 🙁
I don't see why not. I've seen others do the same thing for other posts. Given the level of competence and sense of entitlement displayed thus far, however, I'd be cautious about investing a ton of time when you might not get paid.
BTW, I saw the most recent post, but I'm done.
I posted my suggested code. So far I got a thanks but no word as to whether or not he is using it or it works as he'd like.
Well I guess we now know who has the crystal ball. A simple "thanks" with no more code without questions? I think that means the problem is solved. Well done.
The comment about "missing the transaction" and loop *almost* made me post that the transaction was not what's really missing, but I was done. I had capitulated and let SSS (silver spoon syndrome) prevail. I don't want to take that approach with anyone, but it can be so very frustrating sometimes. Better than I just let it go.
Again, well done, sir.
But I left it open by saying it all depends on the situation and requirements. Oh, wait, there probably aren't any requirements.
But I also said that there are others ways depending on how data is being kept versus how much is being deleted. Oh, wait, probably doesn't matter.
Whoa - Your WAITs consume no time at all. The preamble to the waits (that thread) consumed a lot of time and created frustration, but the waits consumed no time. 😛
Of course, they're both right. No clear requirements, no info on what's kept versus deleted, no feedback that it worked. The OP won't learn anything new. They will receive affirmation that the silver spoons are plentiful. Still, well done.
-
Didn't think I was geeky or nerdy but 30min after "just looking at few things", this was the MRU list
😎
-
GilaMonster (8/11/2015)
SQLRNNR (8/11/2015)
And the post was good. Not quite stern enough on the burnout topic - imho. Too many of us get too close to that edge.
I wrote, rewrote and re-rewrote the last section for almost 2 months. It is still a little wishy-washy, I'm not entirely happy but I think it'll do as a starting point. It's a topic I'm probably going to come back to a few times, along with related observations, I may need a little more room than a blog post though.
Maybe we ought to get a group of folks that have had to go through burnout, or that recognize that they came very close to it, and collaborate on an article about it.
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 -
What an attitude.
-
Eirikur Eiriksson (8/11/2015)
Didn't think I was geeky or nerdy but 30min after "just looking at few things", this was the MRU list😎
Looks eerily familiar. It takes no time at all for my MRU to grow like that.
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 -
Lynn Pettis (8/11/2015)
What an attitude.Duly smacked
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 -
WayneS (8/11/2015)
Lynn Pettis (8/11/2015)
What an attitude.Duly smacked
It's actually the last variable, that's NULL. 😀
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]
-
Alvin Ramard (8/11/2015)
WayneS (8/11/2015)
Lynn Pettis (8/11/2015)
What an attitude.Duly smacked
It's actually the last variable, that's NULL. 😀
I think we scared him off.
-
Lynn Pettis (8/11/2015)
Alvin Ramard (8/11/2015)
WayneS (8/11/2015)
Lynn Pettis (8/11/2015)
What an attitude.Duly smacked
It's actually the last variable, that's NULL. 😀
I think we scared him off.
WTF = Where's That Fellow ??? 😀
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]
-
Alvin Ramard (8/11/2015)
Lynn Pettis (8/11/2015)
Alvin Ramard (8/11/2015)
WayneS (8/11/2015)
Lynn Pettis (8/11/2015)
What an attitude.Duly smacked
It's actually the last variable, that's NULL. 😀
I think we scared him off.
WTF = Where's That Fellow ??? 😀
Washing The Fence
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 -
Any other Threadizens going to the Louisville SQL Saturday next week?
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 - 50,086 through 50,100 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply