> At Least 29 Dead in Greek Rail Disaster - Reports
A passenger train travelling from 🇬🇷 capital Athens to the northern city of Thessaloniki collided head on with a cargo train from Thessaloniki, close to the central Greek city of Larissa late Tuesday night.
MAINTENANCE NOTIFICATION:
Sites may be in read-only mode on Wednesday, March 1st 8:00 PM EST / Thursday, March 2nd 1:00 AM UTC for up to 90 minutes.
TL;DR:
The Platform Engineering team at Stack Overflow is planning to perform SQL Server failovers to facilitate required maintenance. We plan to pe...
@Zikato I feel like I'm missing something obvious, but I thought one benefit of HA was being able to keeping a writeable copy up almost continuously. 90 minutes in read-only seems a lot. There must be a good reason.
Oh, I suppose it's so you can rollback in case of horrible failure and not lose any new content posted while the work was in progress
> ... our plan will be to avoid a network-wide read-only window, but we are including a contingency plan should we encounter unexpected problems to fall back to the previous methodology, which would require the network to be placed into read only mode for up to 90 minutes.
it looks like the 90-min would be only in the contingency plan
I'm looking for any training materials to learn the basics and internals of locking and blocking in SQL server. I asked a question yesterday about NOLOCK hints and got a lot of wonderful responses (thanks to everyone who answered for their time and effort). This is such a wonderful community to b...
@SeanGallardy if you got an Android phone, and search rugby in the emojis, that's the ball that comes up. But so does the American football as well, so 🤷♂️. I guess it's more of the old 40s style American football which did evolve from rugby. Potato potato.
I was doing COAST for a while but then they changed up their word algorithm and I found it got weaker as a starting word. I like CLOUD now though. Idk if that's been much better though.
I am using a lot if dynamically generated SQL in the application tier. This isn't he problem.
The problem is that I get a new execution plan each time because the parameter size keeps changing. (Or so says my DBA.)
Is there any reason why I shouldn't just always use varChar(8000) or nVarChar(4000...
