Muva nje, ngokumangala, ngithole ukuthi komunye weminyango yenkampani enkulu engisebenza kuyo, akuvumelekile ukwethula Iphrofayili ye-SQL ngezikhathi zebhizinisi.
Angazi ukuthi bakwazi kanjani ukuhlaziya izinkinga zokusebenza ezenzeka phakathi namahora ebhizinisi. Phela, ukubukwa kokusebenza ngokuvamile akunikezi isithombe esinembile, ikakhulukazi uma inqubo eyodwa noma ezimbili / umbuzo wehla, ngaphandle kokulayisha iseva ngokwayo. Umbuzo omncane osebenza izikhathi ezimbalwa ngehora futhi othatha imizuzwana eyi-10 esikhundleni sowodwa (kodwa uyawenza baluleke kakhulu iklayenti ethukile kakhulu) ngeke nakanjani igcine ekubukweni kwe-DMV. Bese ukhetha ngokuthi CROSS APPLY ngokusekelwe emibhalweni yemibuzo ngokwayo ilayisha iseva kakhulu.
Nokho, nginentshisekelo yokuqonda ukuthi lokhu kwesaba kuvela kuphi. Kwezinye izinkampani Iphrofayili ye-SQL - ithuluzi lokusebenza, kwabanye babesaba njengomlilo (isikhathi esithile ngangihlanganyela ekubonisaneni futhi ngingaqhathanisa). Ngiqinisekile ukuthi kuhambe kanje:
Houston, sinezinkinga. Isisekelo sihamba kancane. Zibonele
Kunemikhaza eminingi lapha... Ngidingani?
Kulungile, ngizomaka wonke amabhokisi bese nginquma.
Yini esele ezingqondweni zeziphathimandla? Kukhona owayiqala Iphrofayili ye-SQL futhi konke kwahlangana njengesigxobo. Bese betshelana ngomdlalo wegalofu.
By the way, umzamo wokurekhoda okunjalo 'sibhala konke' ayilandeleli ifayela, kodwa kusizindalwazi kuseva efanayo - ngake ngabona icala elinjalo.
Zihamba kanjani izinto kuwe? Sicela ubambe iqhaza kuhlolovo
Abasebenzisi ababhalisiwe kuphela abangabamba iqhaza kuhlolovo.
Kungenzeka yini ukusebenzisa iphrofayili ye-SQL ku-PROD?
-
Siyinkampani encane, konke kulula kithi
-
Abaphathi bokukhiqiza bangakwazi kunjalo
-
Abaphathi bokukhiqiza bangakwazi ngemuva kokugunyazwa nokushaya amakhanda
-
Ngcwele ngcwele ngcwele
Bangu-4 abasebenzisi abavotile. Abasebenzisi abangama-3 bayenqaba.
Source: www.habr.com