I have answered every technical question to the best of my ability. If my lack of ability is frustrating to you I'm not sure what to say. I'm frustrated by it too
if anyone is curious, TF 839 prevents SQL Server from starting up with some configurations. Might be amount of memory or might be number of CPUs. who knows
@JoeObbish I'm asking you to be mindful of the other users/readers of this chat room, which is for general on- and off-site discussion; and also pointing out that as well-meaning and helpful as we all are, there's only so much that can be said without access to the system and workload details. I'm not asking you to stop.
@JoeObbish Sure, but when people join the room later they see 500-odd new messages and it's hard to find the non-Joe-issue chat one might have missed. My normal suggestion, when a topic gets extended over more than a couple of days, is to move it to a separate chat room. That helps keep the information together, and gives it it's own set of stars etc.
I think the thing about about the Joe/NUMA conversation that really gets me is I sympathize with Joe (who at this point I think has me on ignore, and I'm cool with it.) But don't think he has what he needs to solve the problem nor do I think he'll ever get what he needs to solve this problem.
So it's just the flailing and panic at this point. The only person that can solve Joe's problem is going to understand threading, cpu architecture, and virtualization. And, a the very least the threading component is a total black box. I'm assuming the Virtualization component is just as bad too.
So really his only option is to hire someone who worked on the code, or has access to it.
Threading is almost impossible to get right and it's not for mere mortals and I don't really understand even the C interface to threading. I can't tell the difference between kernel threads, and posix threads and those conversations make me quiver.
But I have all that information, and I still can't figure it out. So what's the chance of getting it right when that information is withheld?
@SeanGallardy-Microsoft We can all agree on that. Except maybe Evan, he'll have a revolutionary communist model in mind no doubt.
@JoeObbish It's only a suggestion. Let me know if you need help setting it up. I can't speak for others, but I am finding it hard to keep past details in mind. A separate chat should make that easier. As a room owner, you can relocate messages.
> Hekaton is from the Greek word ἑκατόν for “hundred”. Our design goal for the Hekaton original proof of concept prototype was to achieve 100x speedup for certain TP operations.
The only person that impresses me on the Microsoft side that I've really been amazed by that wasn't employed by Microsoft was the OrcaMDF guy, there is also an Indian blogger that has come up a lot that does a killer job blogging about the server too
I'm going to print out a list of the DBCC complete trace codes when I get more time, then I want to work on linking in C/C++ code into the server I've been having problems cross compiling or loading that through the clr.
anyway, I'm not scared of C or C++ even if I'm not the best at it. Things won't just corrupt the processes memory or take the instance down. I'm not that bad. ;)
I think you could probably point to the failures of C# for the reasons that SQL Server has so little outside development (as far as I've seen anyway).
I really wish this system had a more efficient method of retagging and fixing tags.
Not just do you not have batch operations, you have to click into the question to retag it
that's horseshit
Most of the tags with [stored-procedures] and [postgresql] are wrong it would be super nice if I didn't have to go two pages in to fix the titles and tags.
My current idea is to to create a new table in the legacy database and then create a trigger on the old table to insert the date and primary key of any new rows created or updated in the old tables.
Your method will work, but that seems almost more likely to break something.. In that case, y...
SELECT array_to_json(array_agg(Result))
FROM
(
SELECT
C.eCPClaim_carrier_id
,json_agg(
row_to_json(
(
SELECT t FROM
(
SELECT C.eCPClaim_Key AS CLAIM_KEY ...
SELECT array_to_json(array_agg(Result))
FROM
(
SELECT
C.eCPClaim_carrier_id
,json_agg(
row_to_json(
(
SELECT t FROM
(
SELECT C.eCPClaim_Key AS CLAIM_KEY ...