9 08, 2007
MCTS£¨70-431£©Ñ§Ï°±Ê¼Ç(Ô´´)
µÚÒ»ÕÂSQL Server 2005µÄ°²×°
µÚÒ»½Ú Ñ¡ÔñÕýÈ·µÄÊý¾Ý¿â°æ±¾
MCTS£¨70-431£©Ñ§Ï°±Ê¼Ç
µÚÒ»ÕÂSQL Server 2005µÄ°²×°
µÚÒ»½Ú Ñ¡ÔñÕýÈ·µÄÊý¾Ý¿â°æ±¾
Ò»¡¢¿Î³Ì×ܽá
¡ö SQL Server 2005·ÖΪÎå¸ö°æ±¾: ÆóÒµ°æ¡¢¿ª·¢°æ¡¢±ê×¼°æ¡¢¹¤×÷×é°æÒÔ¼°¿ìËÙ°æ¡£SQL Server 2005 includes five editions: Enterprise Edition, Developer Edition, Standard Edition, Workgroup Edition, and Express Edition.
¡ö ÆóÒµ°æ¶ÔËùÓеÄÌØÐÔ¼°¹¦Äܶ¼Ã»ÓÐÏÞÖÆ¡£Enterprise Edition has no limitations and contains all features and functionality.
¡ö ¿ª·¢°æ¶ÔËùÓеÄÌØÐÔ¼°¹¦Äܶ¼Ã»ÓÐÏÞÖÆ£¬µ«ÊDz»¿ÉÒÔÓÃÒÔÉú²ú»·¾³¡£Developer Edition has no limitations and contains all features and functionality, but it is not licensed for production.
¡ö ±ê×¼°æ¾ßÓÐÕë¶Ô½Ï´óÊý¾Ý¼¯µÄÌØÐÔ¼°¹¦ÄÜ£¬µ«ÊÇËüËùÖ§³ÖµÄ¾Û¼¯½ÚµãµÄÊýÁ¿£¬»¹ÓÐʹÓÃϵͳ×ÊÔ´¡¢ÔÚÏßË÷Òý¡¢Ë÷ÒýÊÓͼ¡¢¿ìËÙ»Ö¸´¡¢ÔÚÏß»¹ÔºÍÊý¾Ý·ÖÇøµÄÄÜÁ¦¶¼ÊÇÊÜÏÞÖÆµÄ¡£Standard Edition has features and functionality suited for larger data sets, but it is limited in the number of nodes it supports for clustering as well as in its capability to use system resources, online indexing, indexed views, fast recovery, online restores, and data partitioning.
¡ö ¹¤×÷×é°æ²»¾ß±¸ÐèÒª²Ù×÷´óÊý¾Ý¿âµÄÌØÐԺ͹¦ÄÜ£¬¶øÇÒÔÚÖ§³ÖÖÐÐͺʹóÐÍÆóÒµµÄÄÜÁ¦ÊÇÊÜÏÞÖÆµÄ¡£Workgroup Edition does not include the features and functionality needed to operate large databases and is restricted in its capability to support mid-size and large companies.
¡ö ¿ìËÙ°æ¶ÔÓÚÄÇЩÃâ·ÑµÄ·Ö²¼Ê½Ð¡Ð͵ÄÓ¦Óð²×°Êý¾Ý¿âÊǺÜÓÐÓõġ£Ëü²»ÊʺÏÓÚÆóÒµ¼¶µÄÊý¾Ý¿â¡£Express Edition is useful for small application-installed databases that need to be distributed free of charge. It is not suited for organization-wide databases.
<span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: BerkeleyOldITC-Book; mso-bidi-font-family: