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

Çå³ýSQLServerÊý¾Ý¿âÈÕÖ¾(SqlServer2005)

ÔÚÖ÷Êý¾Ý¿âÎļþ½øÐдóÁ¿µÄɾ³ý(ÐÂÔö£¬Ð޸Ķ¼»áÓÐÈÕÖ¾)£¬ÈÕÖ¾ÎļþÓÐ1.5G¡£×òÌ컹ԭÊý¾Ý¿âʱ³õʼֵҲ²Å1MB¡£±ØÐëÇå³ýµô£¬²»È»Ì«Õ¼¿Õ¼äÁË¡£ÉÏÍøÕÒÁ˸öÇå³ýÈÕÖ¾µÄ·½·¨¡£Ë³Àû½«ÈÕÖ¾Îļþlog.ldf´Ó1.5G±äΪÁË1M¡£ ÎÒÖ´ÐÐÈçÏ£º
 1.Çå¿ÕÈÕÖ¾
 DUMP TRANSACTION ¿âÃû WITH NO_LOG
2.½Ø¶ÏÊÂÎñÈÕÖ¾£º
 BACKUP LOG Êý¾Ý¿âÃû WITH NO_LOG
3.ÊÕËõÊý¾Ý¿âÎļþ(Èç¹û²»Ñ¹Ëõ,Êý¾Ý¿âµÄÎļþ²»»á¼õС)
ÓÒ¼üÊý¾Ý¿â->ÈÎÎñ->ÊÕËõ->Êý¾Ý¿â->È·¶¨
DBCC SHRINKDATABASE(Êý¾Ý¿âÃû)
4.½«Êý¾Ý¿âÉèΪ×Ô¶¯ÊÕËõ ÓÒ¼üÊý¾Ý¿â->ÊôÐÔ->Ñ¡Ïî->×Ô¶¯->×Ô¶¯ÊÕËõÉèΪTrue


Ïà¹ØÎĵµ£º

JavaScript ºÍJSP Á¬½ÓSqlServer Êý¾Ý¿â

µÚÒ»ÖÖ JavaScriptÁ¬½ÓÊý¾Ý¿â£º
<mce:script language="JavaScript"><!--
// ´´½¨Êý¾Ý¿â¶ÔÏó
var objdbConn = new ActiveXObject("ADODB.Connection");
// DSN×Ö·û´®
var strdsn = "Driver={SQL Server};SERVER=192.168.0.210;UID=xhb;PWD=xhb;DATABASE=books";
// ´ò¿ªÊý¾ÝÔ´
objdbConn.Open(strdsn);
// ......

SQLServerË÷Òýµ÷ÓÅʵ¼ù£¨1£©

Ë÷ÒýµÄÖØÒªÐÔ
Êý¾Ý¿âÐÔÄÜÓÅ»¯ÖÐË÷Òý¾ø¶ÔÊÇÒ»¸öÖØÁ¿¼¶µÄÒòËØ£¬¿ÉÒÔ˵£¬Ë÷ÒýʹÓò»µ±£¬ÆäËüÓÅ»¯´ëÊ©½«ºÁÎÞÒâÒå¡£
¾Û´ØË÷Òý
(Clustered Index)ºÍ·Ç¾Û´ØË÷Òý
(Non- Clustered Index)
×îͨË׵ĽâÊÍÊÇ:¾Û´ØË÷ÒýµÄ˳Ðò¾ÍÊÇÊý¾ÝµÄÎïÀí´æ´¢Ë³Ðò£¬¶ø¶Ô·Ç¾Û´ØË÷ÒýµÄË÷Òý˳ÐòÓëÊý¾ÝÎïÀíÅÅÁÐ˳ÐòÎ޹ء£¾ÙÀýÀ´Ëµ£¬Äã·­µ½Ð»ª×ÖµäµÄº ......

JavaScriptÁ¬½ÓSqlServer²¢ÊµÏÖ·ÖÒ³

//×ܼǼÊý
function sumRecord()
{
var conn= Server.CreateObject("ADODB.connection");
var rs= Server.CreateObject("adodb.recordset");
conn.open("PROVIDER=SQLOLEDB;DATA SOURCE=127.0.0.1;UID=sa;PWD=123456;DATABASE=test");
var sql = "select count(*) as RecordCount from baoming";
rs.open(sql, ......

SQLServer 2005 ÖеÄÀàÐÍ Óë C# ÖеÄÀàÐÍ ¶ÔÓ¦ ¹Øϵ

<Language from="SQL" To="C#">
   <Type from="bigint" To="long" />
   <Type from="binary" To="object" />
   <Type from="bit" To="bool" />
   <Type from="char" To="string" />
   <Type from="datetime" To="DateTime" ......

SQLSERVER¸½¼Ó´íÎó´úÂë823µÄ´¦Àí


sqlserver¸½¼ÓÊý¾Ý¿â´íÎó823µÄ½â¾ö·½°¸2008-10-13 15:06sqlserver¸½¼ÓÊý¾Ý¿â´íÎó823µÄ½â¾ö·½°¸Ò»¡¢SQL-Server¸½¼ÓÊý¾Ý¿âʱʧ°Ü¡£
1¡¢Òì³£Çé¿ö£º·þÎñÆ÷ÔÚÕý³£ÔËÐеÄÇé¿öÏÂͻȻ¶Ïµç£¬µ¼ÖÂÊý¾Ý¿âÎļþË𻵣¬¾ßÌå±íÏÖÊÇ£ºÊý¾Ý¿âÃûºóÃæÓГ£¨ÖÃÒÉ£©”×ÖÑù¡£
2¡¢Òì³£·ÖÎö£º¹ØÓÚ823´íÎóµÄ SQL-SERVER ÖеİïÖú£º
=== ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ