@JoshDarnell Let me guess they didn't use await either?? I mean, the docs clearly say use -1 for an infinite timeout #rtfm
Anyone any thoughts on this one?
I don't doubt Paul is right, but he doesn't say anything about having two indexes. My testing seems to show that it does infer uniqueness, see the final query where the Scan Count is still 1 on a non-unique index dbfiddle.uk/afPKcC0K — Charlieface5 mins ago
Case is a unique and a non-unique index on the same columns, does the optimizer infer uniqueness when seeking the non-unique index?
Should I mark a composite index as unique if it already contains the primary key?
Probably not. The optimizer can generally use information about the uniqueness of the contained key column anyway, so there's no real advantage.
There is also an important consequence of marking an index unique on...
RTÉ - Ireland's national broadcaster has an American expert on who thinks that the undecideds would go with Harris - she seems to have unsuprisingly widened the gender gap! Not stellar but solid. V.P. debate on 01/10!
@Vérace Chump talks dumb and it it so hard to listen to. I think Harris is the far-and-away better candidate, I just wish she didn't appear as scared as she did.
@JoshDarnell I'm not a .net person so legit question: Why is everything new in .net that I see always setup for async calls. Everything is async await, even trivial functions. Is this expected due to changes in .net design/paradigm or is it just people taking things too far? Or, I guess, a little of column a and b.
@SeanGallardy Because people suddenly realized that most paradigms they had been using were fundamentally broken or difficult to use, and that await and "promises" (aka Task) was the answer. C# is not unique in this, JS has also been going there among others.
Also the requirements of high throughput and low memory usage of web apps and the cloud effectively mandated offloading waiting threads, because native OS threads take up too much memory (both kernel and usermode).
Think of it this way: you've sent a request to an IO device (disk, network, serial) or you want to wait for a timer. Why ask the kernel to freeze a whole thread just to do that, when you can just tell the kernel to call yo back when it's done.
This was always possible, but you had to write a Begin and End function for every time you do this, which was too much work for most people. await helps by splitting the function under the hood into separate pieces, and allowing those callbacks to happen but you can still code as if it's all one function.
Debugging is still a bit of pain, because the stack frames sometimes don't carry over properly.
the other side is you may want a dedicated thread handling those requests instead of waiting for .net threading (which would have to be implemented over native threads) to pick up the signal.
I think language semantics come into it to some extent too. Because once one thing is async, the whole call stack needs to be. So it's more "ergonomic" if developers to have the async option available.
@SeanGallardy That's what the threadpool is for, you can even implement your own threadpool if you so desire. It's just a bunch of threads waiting on kernel wait handles in a loop.
C# hasn't solved this, and now there's this whole ecosystem of functions that use Task and ValueTask so the train has already run away, which is a shame. I wish there was a more simplified calling convention for async code.
> After adding just 1000 rows with some non-NULL values in c2, the issue went away entirely. In the production system we un-archived this tiny amount of old data, updated statistics and poof! Plans are stable and have seek+lookup with estimated number of rows around 1 as expected.
The opaqueness of certain sentences in mathematics approaches infinity, at least for me. For instance, "In mathematics, an amenable group is a locally compact topological group G carrying a kind of averaging operation on bounded functions that is invariant under translation by group elements." What?
If I understand that original sentence, then the elements of a group form a likeable group if the average bounds of the group don't change. I am indubitably wrong.
> ‘Sometimes one is forced to consider the possibility that affairs are being conducted in a manner which, all things being considered and making all possible allowances is, not to put too fine a point on it, perhaps not entirely straightforward.’
Has anyone used software to make an animated avatar of themselves and then link that to your input video so that you're the animated character instead of your normal video? If so, which did you use?
I was looking at Adobe's but it seems... ridiculous
America's in a worse state than I thought - this woman, (who makes Marjorie Taylor Greene look like a moderate), while not winning elections, does well in Florida! <shakes head in pity and disgust...>
