Is this comment not very friendly or is that just me?
Welcome, your answer has been flagged as low quality. It needs more substance. Please post the query using a temp table and quote some citation. — Rohit Gupta2 hours ago
> The system will automatically delete negatively-scored, non-migrated, unlocked, and unanswered questions (both open and closed, including as duplicates) that are older than 30 days.
One of the reasons we have so much crap on the site is people ignore terrible questions. If they at least downvoted them (for free!) the system would delete them after 30 days.
Completed, all question downvotes now are "free" for the downvoter.
We did not perform a global recalc.
If you would like your old question downvotes to be free, perform a self-recalc at: https://stackoverflow.com/reputation
We will be monitoring voting patterns over the next few weeks and ev...
> May 12, 2011
@Zikato It's only for answers, which is why I wrote "for free!"
Maybe Mr Cube was thinking of the automatic downvote that used to come with a validated low quality flag (or even question closure back in the day).
@Zikato I feel like I've noticed in recent times that users are actually upvoting bad questions from time to time. That or people are double-accounting and upvoting themselves.
I have a table with the following structure
USERID
CONTACT
VALUE
1
LANDLINE
+12312322334
1
MOBILE
+11234567890
1
EMAIL
[email protected]
2
LANDLINE
+12312322335
2
MOBILE
+11234567899
3
LANDLINE
+12312322336
3
MOBILE
+11234567898
I want to have a result set of all users that h...
Much has been written about the perils of Scalar UDFs in SQL Server. A casual search will return oodles of results.
There are some places where a Scalar UDF is the only option, though.
As an example: when dealing with XML: XQuery can't be used as a computed column definition. One option docum...
I have a shared SQL Server 2016 dev instance in a VM which has poor INSERT performance compared to a shared SQL Server 2012 dev instance on an (supposed to be) identical VM. It also compares poorly to my local SQL Server 2016 dev instance, so I am currently proceeding on the assumption that ther...
Indeed. I suppose that question had the benefit of including a repro. I'd probably have a hard time arguing it didn't get special treatment viz. close voting due to it being from a personality
Those icebergy-type questions do occasionally get good answers with lasting value, but the hit rate is awfully low
Calls to getdate will in turn call the windows api and will switch into non-preemptive mode which can be considered more expensive from the point of view of the scheduler. That being said, in your code you make the call once at the beginning of the batch of inserts as opposed to constantly on each insert. I wouldn't expect a singular call to a system function to cause much of a difference in that scenario. If you are still seeing a significant difference I would suggest to try the recommendations and ensure that you are indeed comparing identical configurations. — Fernando SibajaMar 1, 2021 at 14:29
@JoshDarnell Oh yes your answer was collateral damage I'm afraid. If you object, I'll undelete it but that will prevent the question being automatically cleared away if it doesn't get reopened.
@ErikDarling Goes to show you can trust it
Naturally, it's not impossible there's some change to 2022 that makes 100k-command scripts slow to run. That question just doesn't allow us to test it.
Speaking of science, I ran into an acquaintance yesterday (we've spoken once or twice before). I mentioned I had a sore throat and was losing my voice. Within 60 seconds, he had gone from telling me he never gets sick, to talking about how deadly and under-researched the C19 vaccine is.
@PaulWhite I quickly excused myself after learning the uncomfortable facts that "real" vaccines take 22 years to be developed, and that young healthy people are keeling over from heart attacks from the jab. Understandably, I had a lot of important self-reflection to do at that point.
Yeah well, I don't know, so there were issues but honestly the pharma companies were on to a loser from the start. Don't come up with a vaccine (or whatever you prefer to call it) and everyone points and laughs at the state of so-called 'scientists'. Produce one, and a different group get bunched up
You know, sometimes bad things happen and people just have to make the best of it
But no, people want to be intensely angry about stuff
But maybe that's what the Illuminati want me to think idk
I still see the occasional #DiedSuddenly on Twitter despite blocking people on sight for it but there you go I suppose
Our gardener's ex-wife got right into it and even ran for the local mayoralty on a platform of idk C19 vaccines are control chips for 5G or sthg.
Completed, all question downvotes now are "free" for the downvoter.
We did not perform a global recalc.
If you would like your old question downvotes to be free, perform a self-recalc at: https://stackoverflow.com/reputation
We will be monitoring voting patterns over the next few weeks and ev...
Much has been written about the perils of Scalar UDFs in SQL Server. A casual search will return oodles of results.
There are some places where a Scalar UDF is the only option, though.
As an example: when dealing with XML: XQuery can't be used as a computed column definition. One option docum...
