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

±¾µØsqlÁ¬½ÓÔ¶³Ì·þÎñÆ÷sql(ͼʾ)

ʹÓû·¾³£ºWinxp£¬Mssql 2000 ¸öÈ˰æ
¡¡¡¡1¡¢´ò¿ªÄãµÄ±¾µØMssqlÆóÒµ¹ÜÀíÆ÷£¬Õ¹¿ª¿ØÖÆÌ¨¸ùĿ¼¡¢Microsoft SQL Server¡¢SQL Server×顣ĬÈϰ²×°ºÃµÄMssql×éÖÐÖ»ÓÐÒ»¸öLocal£¨Windows NT£©¡£×¢Ò⣬ÔÚWin 2000ÖÐÏÔʾµÄÊDZ¾µØ¼ÆËã»úÃû¡£

¡¡¡¡2¡¢Êó±êÓÒ¼üSQL Server×飬ѡÔñн¨SQL Server×¢²áÃüÁµ¯³ö×¢²áÏòµ¼¡£

¡¡¡¡3¡¢ÔÚÌí¼Ó¿ÉÓ÷þÎñÆ÷¶Ô»°¿òÖУ¬×ó±ß¿ÉÓ÷þÎñÆ÷ÊäÈë·þÎñÆ÷IPµØÖ·»òÕß·þÎñÆ÷¼ÆËã»úÃû³Æ£¬ÕâÀïÊäÈëÄã·þÎñÉÌÌṩ¸øÄãµÄIPµØÖ·¡£²¢µã»÷Ìí¼Ó°´Å¥£¬½«ÄãÑ¡ÔñµÄ¿ÉÓ÷þÎñÆ÷Ìí¼Óµ½ÓÒ±ßÎı¾¿òÖС£

¡¡¡¡4¡¢ÔÚÑ¡ÔñÉí·Ý֤ģʽ¶Ô»°¿òÖУ¬¹²ÓÐÁ½¸öÑ¡Ïî¡£ÓÉÓÚ×¢²áµÇ¼·þÎñÆ÷SQLʱ£¬¿Õ¼ä·þÎñÉÌ»áÌṩ¸øÓû§Ò»¸öµÇ¼Óû§ÃûÓëÃÜÂ룬ÏàÓ¦µÄ£¬ÔڵǼģʽÖУ¬Ñ¡Ôñ¡°ÏµÍ³¹ÜÀíÔ±¸øÎÒ·ÖÅäµÄSQL ServerµÇ¼ÐÅÏ¢£¨SQL ServerÉí·ÝÑéÖ¤£©¡±Ñ¡Ïî¡£

¡¡¡¡5¡¢Ñ¡ÔñÁ¬½ÓÑ¡ÏîÖУ¬ÊäÈëµÇ¼Óû§ÃûÓëÃÜÂë¡£

¡¡¡¡6¡¢Ñ¡ÔñSQL Server×é¶Ô»°»°ÖУ¬¿ÉÒÔ½«µ±Ç°×¢²áµÄSQL ServerÌí¼Óµ½Ä¬ÈϵÄ×éÖУ¬»òÕßн¨Ò»¸ö¶¥²ãµÄÐÂ×é¡£

¡¡¡¡7¡¢×¢²áµÄSQL ServerÐÅÏ¢ÒÑÉèÖÃÍê³É£¬µã»÷Íê³É°´Å¥ºó£¬ÈÃMssqlÈ¥×Ô¶¯²âÊÔÁ¬½ÓÔ¶³Ì·þÎñÆ÷ÁË¡£
¡¡¡¡8¡¢Á¬½Ó³É¹¦£¬µ¯³öÈçÏÂͼËùʾÐÅÏ¢¿ò¡£

¡¡¡¡²¢ÔÚĬÈϵÄSQL Server×éÖÐ×Ô¶¯Ìí¼ÓÁËÒ»¸öδµÇ¼µÄ·þÎñÆ÷IP»òÕßÃû³Æ£¬Ë«»÷Õâ¸öIP£¬¾Í»áµÇ¼ÄãµÄÔ¶³Ì·þÎñÆ÷MssqlÁË¡£

¡¡¡¡Äã¿ÉÒÔͨ¹ý±¾µØµÄMssqlÔ¶³ÌµÇ¼µ½·þÎñÆ÷£¬²¢ÇÒ½øÐÐÏà¹ØµÄÊý¾Ý¿âά»¤ÁË¡£µ±È»£¬Ô¶³Ì²Ù×÷ʱ£¬ÓÉÓÚÍøËÙµÄÒòËØ£¬ËùÓеIJÙ×÷¶¼»áºÜ³Ù»º£¬ÕâÊôÓÚÕý³£ÏÖÏó¡£ÁíÍ⣬µÇ¼ºóµÄËùÓвÙ×÷¶¼Êܵ½·þÎñÆ÷¿ªÉèµÇ¼ÃûµÄȨÏÞÖÆÔ¼¡£


Ïà¹ØÎĵµ£º

SQL ´û¿î±ÏÒµÉúÐÅÏ¢¹ÜÀíϵͳÊý¾Ý¿âÉè¼Æ

USE MASTER
GO
--´´½¨Êý¾Ý¿âÎļþ´æ·ÅĿ¼
EXEC XP_CMDSHELL 'MKDIR D:\LOANSTUMIS'
IF EXISTS(SELECT *
from SYSDATABASES
WHERE NAME = 'LOANSTU')
DROP DATABASE LOANSTU
GO
--´´½¨Êý¾Ý¿â
CREATE DATABASE LOANSTU
ON
(
NAME = 'LOANSTU_DATA',
FILENAME = 'D:\LOANSTUMIS\LOANSTU_DATA.MDF',
......

SQL 2005 ´æ´¢¹ý³Ì µ÷ÊÔ

SQL 2005 µÄ´æ´¢¹ý³ÌºÍ´¥·¢Æ÷µ÷ÊԴ󷨣¨Ô­´´£©
www.chengchen.net ³Ì³¿
       ×òÌìÍíÉÏÎÒÕÒ±éÁË»¥ÁªÍøÒ²Ã»Óз¢ÏÖ¹ØÓÚSQL2005´æ´¢¹ý³ÌºÍ´¥·¢Æ÷µÄµ÷ÊÔ·½·¨£¬Ñо¿µ½Á賿2µã¶àÖÓ£¬ÖÕÓÚÕÒµ½·½·¨ÁË£¬²»¸É¶ÀÏí£¬ÄóöÀ´·ÖÏí¡£Èç¹ûÒª×ªÔØ£¬Çë±£Áô°æÈ¨£¬Ð»Ð»£¡
     &nbs ......

ÇåÀíSQL Server 2008Êý¾Ý¿âÈÕÖ¾

µÚÒ»²½, ÔÚÊÕËõǰÏȲ鿴ÈÕÖ¾µÄ´óС:
SELECT *
from sysfiles
WHERE name LIKE ' % LOG %'
GO
µÚ¶þ²½, °ÑÊý¾Ý¿âµÄ»Ö¸´Ä£Ê½Éè³É”¼òµ¥”:
ALTER DATABASE ¿âÃû SET RECOVERY SIMPLE
GO
µÚÈý²½, ÔËÐÐcheckpointÖ¸Áî, °Ñdirty pageд½øÊý¾Ý¿â:
CHECKPOINT
GO
µÚËIJ½, ½Ø¶ÏÈÕÖ¾: 
BACKUP ......

¸ßЧSQL²éѯ֮Ë÷Òý£¨VI£©

ÎÒÃÇÏÈ¿´ NestedLoop ºÍ MergeJoin µÄËã·¨£¨ÒÔÏÂΪÒýÓ㬼û RicCC µÄ¡¶ ͨÍùÐÔÄÜÓÅ»¯µÄÌìÌà - µØÓü JOIN ·½·¨ËµÃ÷ ¡· ):
==================================
NestedLoop:
   foreach rowA in tableA where tableA.col2=?
    {
    search rowsB from tableB where tableB.c ......

¸ßЧSQL²éѯ֮Ë÷Òý£¨II£©

ÉÏ»ØÎÒÃÇ˵µ½ÆÀ¹ÀÒ»ÌõÓï¾äÖ´ÐÐЧÂÊÖ÷Òª¿´Âß¼­ IO £¨É¶ÊÇÂß¼­ IO £¬É¶ÊÇÎïÀí IO ¼ûÁª»úÎĵµ£©£¬Õâ´ÎÎÒÃǼÌÐø¡£
ÎÒÃÇÏÈ˵˵£¬·µ»Ø¶àÐнá¹ûʱ£¬ÎªÊ²Ã´ SQLServer ÓÐʱ»áÑ¡Ôñ index seek £¬ÓÐʱ»áÑ¡Ôñ index scan ¡£
ÒÔ nonclustered index ΪÀý˵Ã÷¡£
ÏñËùÓеÄË÷Òý B Ê÷Ò»Ñù£¬·Ç¾Û¼¯Ë÷ÒýÊ÷Ò²°üÀ¨ÍêÈ«ÓÉË÷ÒýÊý¾Ý×é³ÉµÄ¸ù½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ