1









1






1


























標籤：
,














-

Popular posts from this blog

Transaction terminated running SELECT on secondary AG group

Image
1 Using SQL Server 2016, Always-On Running a simple SELECT on a table within a secondary Availability Group. select distinct some_column from some_table oo (nolock) inner join some_other_ ss (nolock) on ss.some_column= oo.some_other_column SSMS eventually sends back this error: Msg 3948, Level 16, State 2, Line 14061 The transaction was terminated because of the availability replica config/state change or because ghost records are being deleted on the primary and the secondary availability replica that might be needed by queries running under snapshot isolation. Retry the transaction. The same SELECT with (NOLOCK) works fine on the primary AG. With or without the NOLOCK it fails most of the time 9/10 and sometimes executes correctly but that's rare. No changes were made to the ...
Read more

Was Earth closer to Europa on 1983-11-25 or 1985-07-22?

Image
4 xkcd #2003: gives a humorous line of succession to the United States presidency. The comic's title text, found by hovering over the comic, states that a tie is broken by whoever was closest to the surface of Europa when they were born. The only potential tie on the list occurs in item #19. It states the "champion" of the Nathan's Hot Dog Eating contest, but does not specify the men's or women's champion. At the time of the comic's publication, the men's champion was Joey Chestnut (born 1983-11-25) and the women's champion was Miki Sudo (Wikipedia gives only 1985 as her year of birth, but famousbirthdays.com claims July 22). Both were ineligible to hold the presidency at the time of publication due to not meeting the minimum age requirement of 35. But supposing they bo...
Read more

Köttigit

Image
Köttigit Büscheliges Mineral-Aggregat aus weißen, nadeligen Köttigitkristallen; Fundort: Grube Silbereckle, Reichenbach, Lahr/Schwarzwald, Baden-Württemberg (Sichtfeld 8 mm) Allgemeines und Klassifikation Andere Namen Zinkarseniat Chemische Formel Zn 3 [AsO 4 ] 2 ·8H 2 O [1] Mineralklasse (und ggf. Abteilung) Phosphate, Arsenate und Vanadate System-Nr. nach Strunz und nach Dana 8.CE.40 (8. Auflage: VII/C.13) 40.03.06.05 Kristallographische Daten Kristallsystem monoklin Kristallklasse; Symbol monoklin-prismatisch; 2/ m Raumgruppe C 2/ m (Nr. 12) Vorlage:Raumgruppe/12 Gitterparameter a  = 10,24 Å; b  = 13,41 Å; c  = 4,76 Å β  = 105,2° [1] Formeleinheiten Z  = 2 [1] Häufige Kristallflächen {010}, {201}, Physikalische Eigenschaften Mohshärte 2 bis 3 [2] Dichte (g/cm 3 ) gemessen: 3,33; berechnet: 3.24 [2] Spaltbarkeit vollkommen nach {010} [2] Bruch; Tenazität faserig [3] ...
Read more