SQL Server2005ÖеÄSQL ServerÉí·ÝÑéÖ¤µÄÉèÖÃ
¸Õ¸Õ×°ÁËSQL2008£¬ÅäÖÃÁËһϣ¬ÔÚÍøÉÏÕÒµ½Õâ¸ö½Ì³Ì£¬¾õµÃ²»´í£¬×ªÔØÑ§Ï°
1¡¢ ¸ü¸ÄTCP/IPÁ¬½ÓΪÆôÓÃ
2¡¢ µÇ¼ £¬ ÐÞ¸Ä2¸öµØ·½
a) Éí·ÝÑéÖ¤·½Ê½£¨»ìºÏģʽ£©
ͼһ£ºÊ×ÏÈʹÓÃwindowsÉí·ÝµÇ¼£¨×¢Ò⣬ ·þÎñÆ÷Ãû³Æ±ØÐëÌîдÕýÈ·£©
ͼ¶þ£º´ò¿ªSQL ʵÀýµÄÊôÐÔ
ͼÈý£ºÑ¡Ôñ×ó±ßµÄ“°²È«ÐÔ”£¬ ×¢Òâ×öÈçÏÂÑ¡Ôñ
b) ÆôÓÃsa£¬ Èô½«saµÄÃÜÂëÉèÖÃΪ¿ÕÃÜÂ룬 Ìø¹ýµÚÒ»²½£» ÈôÃÜÂ벻Ϊ¿Õ£¬ Á½²½Í¬Ê±ÉèÖ㬠¼´£º2¸ö¶¼ÉèÖÃÍê³Éºóµã»÷È·¶¨¼´¿É¡£
i. µÚÒ»²½£¬ ÆôÓÃSa
¸ü¸ÄÍê³Éºó£¬µ¥»÷È·¶¨±£´æ
ii. µÚ¶þ²½£¬ÉèÖÃÃÜÂë
¸ü¸ÄÍê³Éºó£¬µ¥»÷È·¶¨±£´æ
µ±È»Õû¸öÉèÖÃÍê³ÉÖ®ºó£¬ »¹ÐèÒªÖØÆôsql·þÎñ£¬Èç¹û»¹²»ÐУ¬ÔÙÈ¥¿ØÖÆÃæ°å£¬¹ÜÀí¹¤¾ß£¬·þÎñÖÐÕÒµ½SQL Server (MSSQLSERVER)ÏÈÍ£Ö¹£¬ÔÙÆô¶¯£¬È»ºóÔÙÖØÐÂÆô¶¯SQL£¬Ó¦¸ÃûÎÊÌâÁË£¡
Ïà¹ØÎĵµ£º
1¡¢²é¿´µ±Ç°Êý¾Ý¿âµÄ״̬
SELECT
DATABASEPROPERTY
('pubs'
,'IsFulltextEnabled'
)
2¡¢´ò¿ªFullText¹¦ÄÜ
sp_fulltext_databse
'enable'
¹Ø±Õ´Ë¹¦ÄÜ
& ......
--> --> (Roy)Éú³É²âÊÔÊý¾Ý
if not object_id('Class') is null
drop table Class
Go
Create table Class([Student] nvarchar(2),[Course] nvarchar(2),[Score] int)
Insert Class
select N'ÕÅÈý',N'ÓïÎÄ',78 union all
select N'ÕÅÈý',N'Êýѧ',87 union all
select N'ÕÅÈý',N'Ó¢Óï',82 union all
sel ......
Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚÕâ¸öÐÐÒµµÄÈëÃÅÃż÷²»¸ß£¬³ÌÐòÔ±µÄˮƽ¼°¾ÑéÒ²²Î²î²»Æë£¬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´úÂ룬¸ù¾Ý³ÌÐò ......
ÔÚOracle10g֮ǰ£¬ÓÅ»¯SQLÊǸö±È½Ï·ÑÁ¦µÄ¼¼Êõ»î£¬²»Í£µÄ·ÖÎöÖ´Ðмƻ®£¬¼Óhint£¬·ÖÎöͳ¼ÆÐÅÏ¢µÈµÈ¡£ÔÚ10gÖУ¬OracleÍÆ³öÁË×Ô¼ºµÄSQLÓÅ»¯¸¨Öú¹¤¾ß: SQLÓÅ»¯Æ÷(SQL Tuning Advisor £ºSTA)£¬ËüÊÇеÄDBMS_SQLTUNE°ü¡£Ê¹ÓÃSTAÒ»¶¨Òª±£Ö¤ÓÅ»¯Æ÷ÊÇCBOģʽÏ¡£
Ö´ÐÐDBMS_SQLTUNE°ü½øÐÐsqlÓÅ»¯ÐèÒªÓÐadvisorµ ......