Posachedwapa, ndikudabwa, ndinamva kuti m'madipatimenti ena a kampani yaikulu kumene ndimagwira ntchito, ndizoletsedwa kuyambitsa Mbiri ya SQL nthawi yantchito.
Sindikudziwa momwe amakwanitsira kusanthula zovuta zantchito zomwe zimachitika nthawi yabizinesi. Kupatula apo, mawonedwe a magwiridwe antchito nthawi zambiri samapereka chithunzi cholondola, makamaka ngati njira imodzi kapena ziwiri / funso likucheperachepera, osatsegula makamaka seva yokha. Funso laling'ono lomwe limayenda kangapo pa ola ndipo limatenga masekondi 10 m'malo mwa limodzi (koma limatero zofunika kwambiri kasitomala wamanjenje kwambiri) sichidzafika pamalingaliro a DMV. Ndipo sankhani ndi CROSS APPLY kutengera zolemba zamafunso omwe amanyamula seva kwambiri.
Komabe, ndili ndi chidwi chofuna kumvetsetsa komwe mantha awa amachokera. M'makampani ena Mbiri ya SQL - chida chogwirira ntchito, mwa ena amachiwopa ngati moto (kwanthawi yayitali ndimakhala ndikufunsira ndikufanizira). Ndikutsimikiza kuti zidayenda motere:
Houston, tili ndi mavuto. Maziko ndi pang'onopang'ono. Zifotokozereni
Pali nkhupakupa zambiri pano... Ndikufuna chiyani?
Chabwino, ndiyang'ana mabokosi onse ndikusankha.
Kodi ndi chiyani chomwe chatsalira m'maganizo a akuluakulu a boma? Winawake anayambitsa izo Mbiri ya SQL ndipo zonse zidasonkhana ngati mtengo. Kenako amauzana wina ndi mnzake pamasewera a gofu.
Mwa njira, kuyesa kujambula zoterezi 'timalemba zonse' samatsata fayilo, koma ku database pa seva yomweyo - ndidawonapo nkhaniyi.
Nanga inu zinthu zikuyenda bwanji? Chonde tengani nawo gawo pa kafukufukuyu
Ogwiritsa ntchito olembetsedwa okha ndi omwe angatenge nawo gawo pa kafukufukuyu.
Kodi ndizotheka kuyendetsa mbiri ya SQL pa PROD?
-
Ndife kampani yaying'ono, zonse ndi zophweka kwa ife
-
Ma admins opanga angathe
-
Oyang'anira zopanga amatha pambuyo povomereza ndikumenya mitu yawo
-
Woyera woyera woyera
Ogwiritsa 4 adavota. Ogwiritsa 3 adakana.
Source: www.habr.com