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

Àí½âSQL ServerÖеÄË÷Òý£¨Ò»£©

¶ÔÓںܶàDBAºÍ³ÌÐòÔ±À´Ëµ£¬SQL ServerÖеÄË÷Òý²»ÊÇÒ»¸öİÉúµÄÊÂÎÎÒÃÇÉõÖÁÿÌì¶¼ÔÚʹÓÃËü£¬¶ÔÓÚÄÄЩÇé¿öÏÂÓ¦¸Ã´´½¨Ë÷Òý¶¼ÄÜÒ»Ò»µÄµÀ³ö£¬²»¹ýÓпÉÄÜÎÒÃDz¢Ã»ÓÐ×ÐϸȥÏëËüµÄ¾ßÌåÔ­Àí£¬±¾ÎĽ«¸ù¾ÝÎÒ¶ÔSQL ServerÖеÄË÷ÒýµÄÀí½â×öÒ»¸ö¼òµ¥µÄ×ܽáºÍ¸ÅÊö£¬Ï£Íû¶Ô´ó¼ÒÄÜÓÐËù°ïÖú£¨Ïêϸ¿É²Î¿¼¡¶SQL Server 2005 Implementation and Maintenance¡· £©¡£
Ò»£¬Ë÷ÒýµÄ×÷ÓÃ
ÔÚSQL ServerÊý¾Ý¿âÖУ¬µ±ÎÒÃÇÐèÒªÔÚ´óÅúÁ¿±ÈÈ缸ÒÚÌõÊý¾Ý¿âÖмìË÷»òÕßÐÞ¸ÄÊý¾ÝµÄʱºò£¬Ë÷ÒýÄܹ»°ïÎÒÃÇ¿ìËÙµÄÕÒµ½Ä¿±êÊý¾Ý¡£¾ÍÈçͬÎÒÃÇÒªÔÚ×ÖµäÖвéÕÒÒ»¸ö×ÖµÄÏêϸ½âÊÍ£¬Èç¹ûûÓÐË÷Òý£¬ÄÇôÎÒÃÇÖ»ÓÐÒ»Ò³Ò»Ò³µÄ²éÕÒ£¬ÕâÑùµÄËÙ¶ÈÊÇÌØ±ðµÄÂýµÄ£¬µ±ÓÐÁËË÷Òý£¬ÎÒÃÇ¿ÉÒÔ¿ìËÙµÄÌø×ªµ½°üº¬Õâ¸ö×ÖµÄÒ³£¬ÕâÑù¾Í´ó´óµÄ½ÚÊ¡ÁËʱ¼ä¡£
¶þ£¬SQL ServerÖд´½¨Ë÷ÒýµÄ½á¹¹B-Tree/Banlanced Tree(BÊ÷)
ÎÒÃÇ˼¿¼Ò»¸öÎÊÌ⣬¼´±ãÒ»±¾×ÖµäÓÐË÷ÒýÊDz»ÊÇÒ»¶¨¾ÍÄÜÌá¸ß²éÔÄËÙ¶ÈÄØ£¿¼ÙÈçÎÒÃǰ´ÕÕÒ»¸ö¸ö×ÖµÄÔÚË÷ÒýÖÐÕÒÏÂÈ¥£¬ÄÇô¼¸Ê®Íò¸ö×Ö×é³ÉµÄË÷ÒýÒ²»á»¨µôÎÒÃǺܳ¤µÄʱ¼ä£»¶øÏÖʵÉú»î¸æËßÎÒÃÇ£¬Ò»°ãÎÒÃǵÄË÷ÒýÒ²Êǰ´ÕÕÒ»¶¨¹æÂÉ×é³ÉµÄ£¬±ÈÈçлª×ÖµäÓа´ÕÕÉúĸÅÅÐòµÄË÷Òý£¬Ò²Óа´Õձʻ­ÅÅÐòµÄË÷Òý£¬ÕâÑùÎÒÃǾÍÄܸü¿ìËٵIJéÔÄ£¬¶ø²»±ØÒªÔÚË÷ÒýÖа¤¸ö×ÖÕÒÏÂÈ¥¡£ÕâÀï¾ÍҪ̸µ½B-TreeÁË£¬B-TreeÒ²ÓÐÀàËÆµÄÔ­Àí¡£
ÈçÏÂÊÇB-TreeµÄʾÒâͼ
ÈçÉÏͼB-TreeÖÐÖ»ÓÐÒ»¸ö¸ù½Úµã£¬Õâ¸ö¸ù½ÚµãÖ»°üº¬Ò»¸öÊý¾ÝÒ³(data page)£»°üº¬0¸ö»òÕß¶à¸öÖмä²ã£¬Í¬Ê±Ò»¸öÒ¶¼¶¡£
ÔÚÒ¶¼¶µÄÊý¾ÝÒ³Öд洢ÁË´´½¨Ë÷ÒýµÄÊý¾ÝµÄÏà¹ØÐÅÏ¢£¨ÅÅÐòµÄ£©£»¶øÃ¿¸öÒ¶¼¶Ò³Ëù°üº¬µÄË÷ÒýÐÐÔòÒª¸ù¾Ý´´½¨Ë÷ÒýµÄÁеÄÊý¾ÝÀàÐÍÀ´¾ö¶¨¡£
¶øÖмä²ãÊǽ«Ã¿¸öÒ¶¼¶Ò³ÉϵĵÚÒ»¸öÊäÈëË÷ÒýÖµ¶¼´æ´¢ÔÚÒ»¸öÊý¾ÝÒ³ÉÏ£¬²¢ÇÒ´æ´¢¶ÔÓ¦Ò¶¼¶Ò³µÄÖ¸Õë¡£¶ø¸ù½Úµã´æ´¢µÄ·½Ê½Óë´ËÀàËÆ£¬´æ´¢µÄÊÇÿ¸öÖмä²ãµÄµÚÒ»¸öÊäÈëÒÔ¼°¶ÔÓ¦µÄÖ¸Õë¡£
Èý¡¢Ë÷Òý²éÕÒÊý¾ÝµÄʵÀý
ÏÂÃæ²Î¿¼Õâ¸öʵÀý
Èç¹ûÎÒÃDzéÕÒ “Man”Õâ¸öµ¥´Ê£¬ÄÇôÊ×ÏÈ´Ó¸ù½Úµã²éÕÒ Õâ¸öʱºòÖµHºÍO¶¼»á±»²éÕÒ³öÀ´£¬ÓÉÓÚLÔÚO֮ǰ£¬ËùÒÔÕâ¸öʱºò»áÈ¥ Öмä²ã¼¶µÄHÒ³²éÕÒ Õâ¸öʱºòÖµL»á±»²éÕÒ³öÀ´£¬È»ºóÔÚÒ¶¼¶Ò³L²éÕÒµ½M¡£ÕâÑùÎÒÃǾͽö²éÕÒÁËÈý¸öÒ³£¬Èç¹ûÎÒÃǰ´ÕÕ˳Ðò²éÕÒ£¬ÔÚÉÏͼÖÐÔòÐèÒª²éÕÒ5¸öÒ³£¬ÔÚÊý¾ÝÁ¿ºÜ´óµÄÇé¿öÏÂÓÅÊÆ»á¸üÃ÷ÏÔ¡£
Èý¡¢¹ØÓÚË÷ÒýµÄ¼¶
ÎÒÃÇÖªµÀÔÚSQL ServerÖÐ Ò»¸öÊý¾ÝÒ³µÄ´óСÊÇ8192×Ö½Ú£¬Óû§×î¶àÖ»ÄÜ´æ´¢ 8060×Ö½ÚµÄÊý¾Ý¡£¼ÙÈçÎÒÃÇÔÚÒ»¸öchar(60)µÄÁÐÉÏ´´½¨Ë÷Òý£¬ÔÚÊý¾Ý±íÖÐÿһÐÐÔòÐèÒª60×ֽڵĴ洢£¬Í¬


Ïà¹ØÎĵµ£º

ÀûÓÃhibernateµÄQueryÖ±½ÓÖ´ÐÐSQLÓï¾ä

ÀûÓÃhibernateµÄQuery½øÐÐÖ±½ÓÖ´ÐÐSQLÓï¾ä
Ò»¡¢
String sql = "insert into SHOP_MALL_ACCOUNT_MAP_T (MALL_NO,ACCOUNT) values ('"
+ mallNo + "','" + userId + "')";
SQLQuery query = getSession().createSQLQuery(sql);
query.executeUpdate();
¶þ¡¢
String sql = "select to_char(SYN_DATE,' ......

SQL ServerÈçºÎ±¸·ÝÔ¶³ÌÊý¾Ý¿âµ½±¾µØ

     Èç¹ûûÓÐÔ¶³ÌÊý¾Ý¿âËùÔÚ·þÎñÆ÷µÄwindowsÕ˺ÅÃÜÂ룬½öÓÐÔ¶³ÌSQL ServerÊý¾Ý¿âµÄÓû§ÃÜÂ룬¸ÃÈçºÎ±¸·ÝÔ¶³ÌÊý¾Ý¿âdb1µÄÊý¾Ýµ½±¾µØÄØ£¿
1£ºÔÚ±¾µØ°²×°Í¨°æ±¾µÄÊý¾Ý¿âÈí¼þ£¨±ÈÈ磺SQL Server2000£©
2£ºÔÚ±¾µØÊý¾Ý¿â·þÎñÆ÷ÉÏ´´½¨Êý¾Ý¿âdb2£»
3£ºÊ¹Óñ¾µØ“ÆóÒµ¹ÜÀíÆ÷”×¢²áÔ¶³ÌÊý¾Ý¿â£¬²¢½ ......

orale sqlÏà¹ØÑ§Ï°

to_dateºÍto_charÊÇoracleÀïÀïÃæµÄÄÚÖú¯Êý¶ø²»ÊDZê×¼µÄsqlÓï·¨Öеĺ¯Êý£¬Ó÷¨¾ÙÀý£º
1.to_char£¬·µ»Ø½á¹û¿ÉÏÔʾΪ¸÷ÖÖÐÎʽ
 select to_char(sysdate,'yyyy/mm/dd') ,sysdate from dual;
½á¹û£º  2010/05/26               &nbs ......

SQLÖÐCaseµÄʹÓ÷½·¨(ÏÂÆª)

½ÓÉÏÆª
ËÄ£¬¸ù¾ÝÌõ¼þÓÐÑ¡ÔñµÄUPDATE¡£
Àý£¬ÓÐÈçϸüÐÂÌõ¼þ
¹¤×Ê5000ÒÔÉϵÄÖ°Ô±£¬¹¤×ʼõÉÙ10%
¹¤×ÊÔÚ2000µ½4600Ö®¼äµÄÖ°Ô±£¬¹¤×ÊÔö¼Ó15%
ºÜÈÝÒ׿¼ÂǵÄÊÇÑ¡ÔñÖ´ÐÐÁ½´ÎUPDATEÓï¾ä£¬ÈçÏÂËùʾ
--Ìõ¼þ1
UPDATE Personnel
SET salary = salary * 0.9
WHERE salary >= 5000;
--Ìõ¼þ2
UPDATE Personnel
SET sala ......

SQL server2005ÖÐÎļþ±¸·ÝÓë»Ö¸´

±¸·Ý
BACKUP DATABASE mydb
TO DISK='c:\olddb.bak'
WITH INIT
--ΪÁ˲âÊÔ£¬°Ñ±¸·ÝºÃµÄÎļþ´ÓCÅÌÒÆ¶¯µ½D:\tempdb Îļþ¼Ð
--»¹Ô­
--1.ÓôËÓï¾äµÃµ½±¸·ÝÎļþµÄÂß¼­ÎļþÃû£º
RESTORE FILELISTONLY from DISK = N'd:\tempdb\olddb.bak' --±¸·ÝÎļþ´æ·Å·¾¶
--¿´LogicalName£¬Ò»°ã»áÓÐÁ½¸öÎļþ,È磺
--olddb &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ