SQL Server 2008 vs Express
SQL Server yog tus qauv kev sib raug zoo database server tsim los ntawm Microsoft. Thiab SQL Server Express yog qhov ntsuas qis ntawm SQL Server uas yog dawb, tab sis muaj cov yam ntxwv txwv piv rau tag nrho version. Qhov tseeb version ntawm SQL Server yog SQL Server 2008 R2 thiab nws cov ntawv nthuav qhia yog SQL Server Express 2008.
Microsoft SQL Server feem ntau siv T-SQL (uas yog qhov txuas ntxiv rau SQL) thiab ANCI SQL, raws li nws cov lus nug. Nws txhawb Integer, Float, Decimal, Char, Varchar, binary, Text thiab ob peb lwm hom ntaub ntawv. Cov neeg siv-txhais kev sib xyaw hom (UDTs) kuj raug tso cai. Ib lub chaw khaws ntaub ntawv yuav muaj cov kev xav, cov txheej txheem khaws cia, indexes thiab txwv tsis yog cov rooj. Cov ntaub ntawv khaws cia hauv peb hom ntaub ntawv. Cov no yog.mdf cov ntaub ntawv,.ndf thiab.ldfextension cov ntaub ntawv khaws cov ntaub ntawv tseem ceeb, cov ntaub ntawv thib ob thiab cov ntaub ntawv teev tseg, raws li. Txhawm rau kom paub tseeb tias cov ntaub ntawv yuav ib txwm rov qab mus rau lub xeev paub zoo, nws siv lub tswv yim ntawm kev hloov pauv. Kev hloov pauv tau siv los ntawm kev sau ua ntej. SQL Server kuj txhawb kev sib koom ua ke. Kev nug siv T-SQL yog hom tseem ceeb ntawm kev khaws cov ntaub ntawv. SQL Server ua cov lus nug optimization rau kev ua tau zoo. Nws kuj tso cai rau cov txheej txheem khaws cia, uas yog parameterized T-SQL queries khaws cia rau hauv lub server nws tus kheej thiab tsis raug tua los ntawm tus neeg siv daim ntawv thov zoo li cov lus nug ib txwm. SQL Server suav nrog SQL CLR (Common Language Runtime) uas yog siv los ua ke cov neeg rau zaub mov nrog. NET Framework. Vim li no, koj tuaj yeem sau cov txheej txheem khaws cia thiab ua rau txhua yam. NET hom lus xws li C lossis VB. NET. Tsis tas li UTDs tuaj yeem txhais tau siv. NET cov lus. Cov chav kawm hauv ADO. NET tuaj yeem siv los nkag mus rau cov ntaub ntawv khaws cia hauv database. ADO. NET cov chav kawm muab kev ua haujlwm ntawm kev ua haujlwm nrog tabular lossis ib kab ntawm cov ntaub ntawv, lossis cov metadata sab hauv. Nws kuj tseem muab kev txhawb nqa XQuery, uas muab kev nkag mus rau XML nta hauv SQL Server. SQL Server kuj tseem muab cov kev pabcuam ntxiv xws li Kev Pabcuam Kev Pabcuam, kev pabcuam rov ua dua, kev pabcuam tshuaj xyuas, kev pabcuam tshaj tawm, Kev Pabcuam Ceebtoom, Kev Pabcuam Kev Sib Koom thiab Kev Tshawb Nrhiav Cov Ntawv Tag Nrho.
Raws li tau hais los saum toj no, SQL Server Express yog qhov ntsuas qis, rub tawm dawb ib tsab ntawm SQL Server. Yog li ntawd, nws pom tseeb muaj qee qhov kev txwv piv rau cov ntawv puv. Ua tsaug, tsis muaj kev txwv rau tus naj npawb ntawm databases lossis tus naj npawb ntawm cov neeg siv kev txhawb nqa los ntawm lub server. Tab sis, cov ntawv nthuav qhia tsuas yog siv tib lub processor, 1GB nco thiab 10GB cov ntaub ntawv database. Nws yog qhov tsim nyog rau kev xa tawm XCOPY txij li tag nrho cov ntaub ntawv khaws cia hauv ib cov ntaub ntawv uas hom yog.mdf. Lwm qhov kev txwv tsis pub muaj yog tsis muaj kev soj ntsuam, kev koom ua ke thiab kev ceeb toom. Tab sis tag nrho txhua yam, Cov Ntawv Tshaj Tawm yog qhov zoo rau kev kawm vim tias nws tuaj yeem siv dawb los tsim cov duab me me thiab lub vev xaib.
qhov sib txawv ntawm SQL Server thiab SQL Server Express tsab
• SQL Server yog cov khoom lag luam thaum SQL Server Express tau rub tawm dawb, ntsuas qis qis ntawm SQL Server.
• SQL neeg rau zaub mov yog tsom rau kev lag luam ua haujlwm uas xav tau kev rov ua dua thiab cov cuab yeej ua lag luam ua lag luam, thaum Express tsab yog qhov nkag-theem database zoo tagnrho rau kev kawm
• Thaum nws los txog rau cov CPUs, tus nqi ntawm lub cim xeeb thiab qhov loj ntawm cov ntaub ntawv, Express tsab muaj kev ua haujlwm tsawg dua piv rau SQL Server. Nws tsuas tuaj yeem siv tib lub processor, 1GB nco thiab 10GB database cov ntaub ntawv.
• Cov kev pabcuam ntxiv xws li Kev Tshaj Tawm thiab Kev Ntsuam Xyuas cov kev pabcuam tsis tuaj yeem nyob hauv SQL Server Express tsab.
