Are the posted questions getting worse?
- Jeff Moden wrote:RBarryYoung wrote:
Geez, 1 MILLION?!?! Will this guy never stop talking?!?
Wow! Mr. R. Barry Young... source of the term "Pseudo Cursors" for me. How the heck are ya, Barry? Very long time no see!
Hey Jeff, I couldn't miss your party!
I've been doing OK, retired a couple of years ago, but I still answer some questions over at StackOverflow.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Congratulations on the retirement. I've just about given up on SO. Discussions are discouraged... unless you happen to be a moderator. 🙁
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Jeff Moden wrote:Steve Jones - SSC Editor wrote:
SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not catching more than it does.
I'll never understand some of the problems people have with spam. For example, how hard would it be to write an "after insert" trigger to check for the obvious spam patterns in the titles that we've recently seen and have the system mark them as SPAM? 😉
Feel free to write one. Then think about all the things this trigger has to look for, across time. We, and likely none of you, want to add triggers for specific cases that come up for a period of time. Then remember that people post lots of numbers and other data in here, and how could you be sure you aren't creating more issues that will drive other complaints or just break posting.
- Jeff Moden wrote:
Shifting gears a bit... the following message started showing up on my machine some time ago (seems like at least a week) on every post thread and ONLY for this site (SSC). Is anyone else getting this?
I get this randomly, not every time. Devs are trying to figure out what is broken, or if this is an ops/infra issue.
Seems to be only FF for me, not Chrome or Edge.
- Steve Jones - SSC Editor wrote:Jeff Moden wrote:
Shifting gears a bit... the following message started showing up on my machine some time ago (seems like at least a week) on every post thread and ONLY for this site (SSC). Is anyone else getting this?
I get this randomly, not every time. Devs are trying to figure out what is broken, or if this is an ops/infra issue.
Seems to be only FF for me, not Chrome or Edge.
Thanks, Steve. Just to add the extra info (I think I provided it once before but can't remember), I'm using FF almost exclusively and it appears somewhere near the end of every post for me. I'll be happy to test any fix for folks.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
So I have noticed the”Ask SSC” link from the menu has been removed.
That a on purpose change, is the plan to wind down Ask or was it an “oooops” moment.
- Steve Jones - SSC Editor wrote:Jeff Moden wrote:Steve Jones - SSC Editor wrote:
SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not catching more than it does.
I'll never understand some of the problems people have with spam. For example, how hard would it be to write an "after insert" trigger to check for the obvious spam patterns in the titles that we've recently seen and have the system mark them as SPAM? 😉
Feel free to write one. Then think about all the things this trigger has to look for, across time. We, and likely none of you, want to add triggers for specific cases that come up for a period of time. Then remember that people post lots of numbers and other data in here, and how could you be sure you aren't creating more issues that will drive other complaints or just break posting.
I'll remind you that 1) it's not my site and 2) it's not my site. 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Jeff Moden wrote:Steve Jones - SSC Editor wrote:Jeff Moden wrote:Steve Jones - SSC Editor wrote:
SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not catching more than it does.
I'll never understand some of the problems people have with spam. For example, how hard would it be to write an "after insert" trigger to check for the obvious spam patterns in the titles that we've recently seen and have the system mark them as SPAM? 😉
Feel free to write one. Then think about all the things this trigger has to look for, across time. We, and likely none of you, want to add triggers for specific cases that come up for a period of time. Then remember that people post lots of numbers and other data in here, and how could you be sure you aren't creating more issues that will drive other complaints or just break posting.
I'll remind you that 1) it's not my site and 2) it's not my site. 😉
You forgot the third and the most important point, "it is not my site"
😎
Logic and intelligence are not necessarily two sides of a coin 😉
- Eirikur Eiriksson wrote:Jeff Moden wrote:Steve Jones - SSC Editor wrote:Jeff Moden wrote:Steve Jones - SSC Editor wrote:
SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not catching more than it does.
I'll never understand some of the problems people have with spam. For example, how hard would it be to write an "after insert" trigger to check for the obvious spam patterns in the titles that we've recently seen and have the system mark them as SPAM? 😉
Feel free to write one. Then think about all the things this trigger has to look for, across time. We, and likely none of you, want to add triggers for specific cases that come up for a period of time. Then remember that people post lots of numbers and other data in here, and how could you be sure you aren't creating more issues that will drive other complaints or just break posting.
I'll remind you that 1) it's not my site and 2) it's not my site. 😉
You forgot the third and the most important point, "it is not my site" 😎
Logic and intelligence are not necessarily two sides of a coin 😉
😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
I'll remind you that 1) it's not my site and 2) it's not my site. 😉
It is, however, your contention this is easy...
-
Easy.
Exactly the rabbit hole we all fall into sometimes.
If life was easy, would any of us have a job? After all, some in politics imply with a couple weeks training any coal miner could be a software programmer.
I have to agree it might be easy, but also run into some other issues, So easy depends on what the goal is.
- Steve Jones - SSC Editor wrote:
I'll remind you that 1) it's not my site and 2) it's not my site. 😉
It is, however, your contention this is easy...
'Nuff said and understood. My apologies.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Greg Edwards-268690 wrote:
Easy. Exactly the rabbit hole we all fall into sometimes.
If life was easy, would any of us have a job? After all, some in politics imply with a couple weeks training any coal miner could be a software programmer.
I have to agree it might be easy, but also run into some other issues, So easy depends on what the goal is.
This post has had me thinking for the past couple days. It does depend on the goal. About 10 months ago I split with my business partner of 10 years so I had to completely start over technically. We tried a number of different businesses and it became clear over time it was (long past) time to move on. I didn't really care much over the time because this person was investing in the businesses and I always had interesting technical projects to work on. The code is/was all encumbered in those businesses so in the end I had zilch. Starting from scratch what is there to look forward to but endless complexity or simple tasks repeated ad nausea? It's really made me think about what are the real sources of complexity in databases and systems
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
-
I've always been concerned but, as I get older, I seriously worry about the medical world and hospitals and the people in them when I see things like the following...
https://www.sqlservercentral.com/forums/topic/conditional-sum-in-sql
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Out of interest, has anyone heard or seen from Gail in awhile? I haven't seen them about in ages. I noticed that their website has been down a little while too (I have habit of sharing some of theirarticles to colleagues and unfortunates on the internet, such as their "No, this isn't a bug in T-SQL" post about unqualified columns in sub queries, which is a personal favourite). I recall they said they they'd struggled for a while, especially over COVID, so I hope they are doing well if anyone has heard from them.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 15 posts - 65,941 through 65,955 (of 66,789 total)
You must be logged in to reply to this topic. Login to reply