Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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£¬Ó¦¸ÃûÎÊÌâÁË£¡


Ïà¹ØÎĵµ£º

SQL Server ÅÅÐòʵÏÖº¯Êýϸ˵

ÅÅÃûº¯ÊýÊÇSQL Server2005мӵŦÄÜ¡£ÔÚSQL Server2005ÖÐÓÐÈçÏÂËĸöÅÅÃûº¯Êý£º
¡¡¡¡1. row_number
¡¡¡¡2. rank
¡¡¡¡3. dense_rank
¡¡¡¡4. ntile
¡¡¡¡Ò»¡¢row_number
¡¡¡¡row_numberº¯ÊýµÄÓÃ;ÊǷdz£¹ã·º£¬Õâ¸öº¯ÊýµÄ¹¦ÄÜÊÇΪ²éѯ³öÀ´µÄÿһÐмǼÉú³ÉÒ»¸öÐòºÅ¡£row_numberº¯ÊýµÄÓ÷¨ÈçÏÂÃæµÄSQLÓï¾äËùʾ£º
¡¡¡¡sel ......

SQL Server 2005 ÖÐÈçºÎ×öÈ«ÎļìË÷

1¡¢²é¿´µ±Ç°Êý¾Ý¿âµÄ״̬
       SELECT
DATABASEPROPERTY
('pubs'
,'IsFulltextEnabled'
)
 2¡¢´ò¿ªFullText¹¦ÄÜ
       sp_fulltext_databse
'enable'
       ¹Ø±Õ´Ë¹¦ÄÜ
     & ......

SQL Server 2005È«ÎļìË÷¼¼ÊõÔÚÍøÕ¾ÉϵÄÓ¦ÓÃʵ¼


Ò»¡¢Ç°ÑÔ
“ÈËÀàʧȥËÑË÷£¬ÊÀ½ç½«»áÔõÑù?”£¬Í¬Ñù£¬ºÜÄÑÏëÏóÒ»¸öÓµÓм«´óÐÅÏ¢Á¿µÄÐÐÒµÍøÕ¾ÃÅ»§Ã»ÓÐÕ¾ÄÚÈ«ÎÄËÑË÷½«»á³öÏÖÔõÑùµÄ¾ÖÃæ£¬ÍøÕ¾È«ÎļìË÷¶ÔÓÚÍÚ¾òÍøÕ¾ÐÅÏ¢ºÍÕûºÏÍøÕ¾×ÊÔ´µÄ¼ÛÖµÊDz»ÑÔ¶øÓ÷µÄ¡£ÎÒÃÇ¿´µ½£¬Í¨ÓÃÐ͵ÄËÑË÷ÒýÇæÒѾ­³ÉΪÁË»¥ÁªÍøÊÀ½çµÄÃÅ»§£¬¶ø¶ÔÓÚÒ»¸öÐÅÏ¢Á¿¼«Æä·á¸»µÄÍøÕ¾¶øÑÔ£¬È«ÍøËÑË÷»òÐ ......

ÈçºÎÓà SQL Tuning Advisor (STA) ÓÅ»¯SQLÓï¾ä


ÔÚOracle10g֮ǰ£¬ÓÅ»¯SQLÊǸö±È½Ï·ÑÁ¦µÄ¼¼Êõ»î£¬²»Í£µÄ·ÖÎöÖ´Ðмƻ®£¬¼Óhint£¬·ÖÎöͳ¼ÆÐÅÏ¢µÈµÈ¡£ÔÚ10gÖУ¬OracleÍÆ³öÁË×Ô¼ºµÄSQLÓÅ»¯¸¨Öú¹¤¾ß: SQLÓÅ»¯Æ÷(SQL Tuning Advisor £ºSTA)£¬ËüÊÇеÄDBMS_SQLTUNE°ü¡£Ê¹ÓÃSTAÒ»¶¨Òª±£Ö¤ÓÅ»¯Æ÷ÊÇCBOģʽÏ¡£
Ö´ÐÐDBMS_SQLTUNE°ü½øÐÐsqlÓÅ»¯ÐèÒªÓÐadvisorµ ......

oracle ³£ÓÃÐÔÄܲéѯSQL·ÖÏí

select count(1) from dictionary;
select * from dba_data_files;
select count(1) from dba_objects t where t.owner='BESTTONE';
select * from dba_tablespaces t where t.tablespace_name='BESTTONE';
select count(1) from dba_tables t where t.owner='BESTTONE';
select t.table_name,t.comments from diction ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ