I have two large tables (over 200 million rows each), that when joined give slow query performance even on table INVOICE primary (clustered) key to table SHIPMENT primary (non clustered key), that the clustered index seek to support the join has 100% of the cost.
How do I optimize this? I have i...
@EvanCarroll I'm a Model M man, myself, although my Thinkpad's keyboard is good enough that I don't bother most of the time.
Both of the above are decades-old IBM products (coincidentally?). I used to have some Intellistations at one point as well, although the XW series from HP had much better fit and finish.
This edit suggestion appears to have been approved single-handedly by a regular user:
This is the expected effect of using the Improve button. What seems less expected is that the user did not make any improvements to the suggestion, according to the revision history of the post. These are all...
@hot2use There were two things changed: the keywords in the code snippet were uppercased, and brackets around an inline piece of code in a sentence were removed. Both changes were invalid in my opinion.
Or the improvement added something that isn't considered different by the diff code. Anyway, it will be interesting to see what comes of this. Thanks for reporting it.
@TomV No need, chill here :) I'll go. I don't want to say anything to get moved to trash which in some light could be misconstrued as "X is greater than Y". Nothing personal, bud.
@TomV does anyone but you read it as a pissing match?
@TomV I mean, most importantly, does @SeanGallardy-Microsoft?
I don't read his comments directed at me as being of a pissing match.
It's a DB-centered channel for DBAs. We make light hearted jokes about each others' stuff, and each other. I don't actually care if Hekaton was better (though it's probably not, because you know and even if it was, you couldn't benchmark it)....
I'm just saying because if it's not clear to you, or Sean, I don't mean anything I say personally or take what others direct at me that way, and I don't think others are doing so here either.
@sp_BlitzErik just keep in mind what you're essentially saying when you say "ban evan" is "I don't want to see Evan run in any moderator elections for a year" and I know that's not true.
@ypercubeᵀᴹ They will for everyone after I personally run with a chat ban in the past year, having had my other bans and suspensions elapse more than a year ago. Don't ruin it for everyone because of me. Don't make them do it!
I have an Access 97 database that is used by some software on multiple (up to 4-6) computers (running Windows 7). Once in a while (maybe 1-2 months) something happens where computers on the network can't access the database.
The program accesses the database through a ADO/JET driver (the program...