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

sql server ÈÕÖ¾ÎļþµÄÊÕËõ

ÍêÈ«±¸·Ý»òÈÕÖ¾±¸·ÝËä˵¶¼ÓнضÏÈÕÖ¾µÄ¹¦ÄÜ,µ«ÊDz»»áÊÕËõÈÕÖ¾ÎļþµÄ¿Õ¼ä·µ»Ø¸ø²Ù×÷ϵͳ.
Èç¹ûÄãÏ뽫ÈÕÖ¾ÎļþµÄ¿Õ¼ä·µ»Ø¸ø²Ù×÷ϵͳµÄ»°,Ö»ÓÐÒ»ÖÖ·½·¨,¾ÍÊÇÊÕËõÊý¾Ý¿â(Ñ¡ÔñÈÕÖ¾Îļþ)
ZTÒ»¸öÏà¹ØÌû×Ó,¹©²Î¿¼!
ÎïÀíÈÕÖ¾Îļþ£º
    Õâ¸ö±È½ÏºÃÀí½â£¬ÊµÊµÔÚÔڵĶ«Î÷£¬Êý¾Ý¿âĿ¼ÏÂÃæµÄ.ldfÎļþ¾ÍÊÇ£¬ÓÐЩÈËϲ»¶¸Äºó׺£¬¸Ð¾õ²»´óºÃ£¬Êý¾Ý¿âµÄÊÂÎñÈÕÖ¾¼Ç¼¾ÍÔÚÕâÀïÃæ
ÐéÄâÈÕÖ¾£º
    ÏàÐŶàÊýÈËÓÐÕâ¸ö¸Ð¾õ£¬ÐéÄâÕâ¸ö×ÖÑÛ×ÜÊÇÉñÃصĴúÃû´Ê£¬ÐéÄâ¸ö·¹µº°®ÎÒϲ»¶£¬µ«ÐéÄâÈÕÖ¾£¬ÐéÄâÄڴ棬ÐéÄâ¡£¡£¡£¡££¬¿´Á˾ÍÌÖÑá¡£½âÊÍÓ¦¸ÃÊÇÕâÑùµÄ£¬¶ÔÓÚÒ»¸ö»ò¶à¸öÁ¬ÐøµÄÎïÀíÈÕÖ¾Îļþ£¬SQL SERVERÔÚÕâЩÎļþµÄÄÚ²¿ÓÖ»®·Ö³ÉÁ˶à¸öСµÄÎļþ£¬³ÆΪÐéÄâÈÕÖ¾Îļþ£¬ËûÊÇÈÕÖ¾ÎļþÊÕËõºÍÈÕÖ¾½Ø¶ÏµÄ×îСµ¥Î»£¬±ÈÈçÎïÀíÈÕÖ¾ÎļþÊÇ400M£¬ÄÚ²¿»®·ÖÁË4¸ö100MµÄÐéÄâÎļþ£¬ÊÕËõʱÄãµÃµ½µÄÊÇ300M£¬200M£¬²»¿ÉÄܵõ½239M£¬¶ÔÓÚÒ»¸öÎïÀíÎļþ£¬»á»®·Ö³É¶àÉÙ¸öÐéÄâÎļþ£¬Õâ¸öÓÉSQL×Ô¼ºÎ¬»¤£¬Î¨Ò»¿ÉÒÔÈ˹¤¸ÉÔ¤µÄÊÇÖ¸¶¨½Ï´óµÄÎïÀíÈÕÖ¾Îļþ£¬²¢Ö¸¶¨½Ï´óµÄÔö³¤±ÈÀý£¬ÕâÑù¿ÉÄÜÐéÄâÎļþµÄ¿éÍ·»á´óµã£¬ÊýÁ¿»áÉٵ㣬ϵͳµÄά»¤¿ªÏú»áµÍÒ»µã
Âß¼­ÈÕÖ¾£º
    ²»ÒªÍ·ÔΣ¬Ó²×ÅͷƤ¿´°É£¡£¡£¡¸Ð¾õÕâ¸öÓ¦¸ÃÊÇÊý¾Ý¿âÊÂÎñÈÕÖ¾µÄÕæʵдÕÕ£¬ÎïÀíÈÕÖ¾ÎļþºÃ±ÈÊÇÒ»¸öÈÝÆ÷£¬ÀïÃæÈÝÄɵÄÊÇÈÕÖ¾¼Ç¼£¬ÕâЩ¼Ç¼¾Í³ÆΪÂß¼­ÈÕÖ¾£¬´ÓÎïÀíÈÕÖ¾ÎļþµÄÆðµã¿ªÊ¼£¬Âß¼­ÈÕ־˳ÐòµÄÉú³É£¬¼Ç¼ÏÂÊý¾Ý¿âÀï·¢ÉúµÄÿ¸öÊÂÎñ£¬ÕâЩÊÂÎñ±»´òÉÏÒ»¸ö±êÇ©£¬LSN£¬Ë³ÐòµÄÅÅÁÐÏÂÀ´£¬ÕâÑùÂß¼­ÈÕÖ¾¾ÍÔÚÎïÀíÈÕÖ¾ÎļþÄÚÂýÂýµÄ³É³¤£¬Ö±µ½³äÂúÁËËû£¬Õâ¸öʱºòÎïÀíÈÕÖ¾Îļþ¾Í»á×Ô¶¯Ìí¼ÓеĿռ䣬ÒÔ¼ÌÐøÇ°ÃæµÄ²½Ö裬ÕâÖÖÇé¿öÊÇ×îÖ±½ÓµÄÒ»ÖÖ£¨´ÓÀ´²»½Ø¶ÏÈÕÖ¾£¬»ù±¾ÉϾÍÊÇÕâÑùµÄ£©£¬µ«ÊÂʵÉÏÍùÍùÊǸ´ÔӵĶà
¼ì²âµã(checkpoint)ºÍ»Ö¸´ÖÜÆÚ(recovery interval)£º
    checkpoint²»ÊÇÓÃÓÚ¼ì²éÊý¾ÝÊÇ·ñÍêÕû£¬Ò³ÃæÁ¬½ÓÊÇ·ñÕýÈ·µÄ£¬ËûÊÇÓÉϵͳά»¤µÄÒ»¸ö½ø³Ì£¨ÄãÒ²¿ÉÒÔÊÖ¹¤µÄÖ´ÐУ©£¬ÓÃÓÚ½«¸ßËÙ»º´æÀïµÄÔàҳˢе½´ÅÅÌ£¬Á½ÕßµÄÅäºÏËãÊÇΩÃîΩФ£¬µ±»º´æÖеÄÔàÒ³»ýÀÛµ½Ò»¶¨µÄÊýÁ¿£¬SQL¹À¼ÆÑÝËãÕâЩÔàÒ³Òª»¨µÄʱ¼ä¿ìÒª½Ó½üÉ趨µÄrecovery interval£¨·ÖÖÓ£©Ê±£¬ÏµÍ³¾Í»á²úÉúÒ»¸öcheckpoint£¬ËùÒÔcheckpointµÄ²úÉú²»ÊǶ¨Ê±µÄ£¬ËüÓÉrecovery intervalºÍÊý¾Ý¿âµÄ¸üÐÂƵ·±¶È¾ö¶¨¡£Èç¹ûÄãµÄÊý¾Ý¿âÓÀÔ¶²»ÓÃÖØÆô£¬ÓÀÔ¶²»»á³öÏÖʲô¹ÊÕÏ£¬¾ÍÕâôһֱÔËÐÐÏÂÈ¥£¬ÄÇôcheckpointºÍrecovery interval¾ÍûÓÐÏëÏóÖеÄÖØÒªÁË£¬SQL×ÜÊ


Ïà¹ØÎĵµ£º

SQL Server 2005°²×°Ê§°ÜµÄ´¦Àí·½·¨

ÔÚ°²×°SQL Server 2005¿ª·¢°æʱ³öÏÖÎÊÌâ¡£°²×°»·¾³Îªwindows xp sp3£¬°²×°Óû§Ê¹Ó󬼶¹ÜÀíÔ±£¨Administrator£©¡£³öÏֵĴíÎóÊÇ
ÔÚ°²×°“Integration Services”²½Öèʱ³öÏÖ°²×°´íÎó£¬Ìáʾ“´íÎó: -2146233087”¡£
´íÎó¼Ç¼
±êÌâ:
Microsoft SQL Server 2005 °²×°³ÌÐò
ÎÞ·¨ÔÚ COM+ Ŀ¼Öа²×°ºÍÅäÖ ......

SQL×¢Èë

SQL×¢Èë¹¥»÷
¡¡¡¡SQL×¢Èë¹¥»÷ÊǺڿͶÔÊý¾Ý¿â½øÐй¥»÷µÄ³£ÓÃÊÖ¶ÎÖ®Ò»¡£Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚ³ÌÐòÔ±µÄˮƽ¼°¾­ÑéÒ²²Î²î²»Æ룬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´ú ......

Ò»´Î²åÈë¶àÌõÐÅÏ¢(sql)

×¢ÊÍ:Ö»Êʺϵ¥±íµ¥ÁÐÊý¾Ý,
create database test
go
use test
go
create table users
(
:id int identity(1,1) primary key not null,
:name nvarchar(20)
)
go
create proc sp_Inserts
@Names nvarchar(4000)
as
declare @Name nvarchar(20),@ErrorSum int
:set @ErrorSum = 0
:begin tra ......

SQLÈÕÆÚ¸ñʽ´óÈ«

CONVERT
½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£ÓÉÓÚijЩÐèÇó¾­³£Óõ½È¡ÈÕÆÚ¸ñʽµÄ²»Í¬.ÏÖÒÔÏ¿ÉÔÚ
SQL ServerÖÐ ½«ÈÕÆÚ¸ñʽ»¯.
SQL Server Ö§³ÖʹÓÿÆÍþÌØËã·¨µÄ°¢À­²®ÑùʽÖеÄÊý¾Ý¸ñʽ¡£
ÔÚ±íÖУ¬×ó²àµÄÁ½Áбíʾ½« datetime »ò smalldatetime ת»»Îª×Ö·ûÊý¾ÝµÄ style Öµ¡£¸ø style Öµ¼Ó 100£¬¿É»ñµÃ°ü ......

ÓÃsql²Ù×÷oracleµÄblob×Ö¶Î

ÓÃsql²Ù×÷oracleµÄblob×Ö¶Î
1¡¢²éѯ
select utl_raw.cast_to_varchar2(dlob),id from system.t_htinfo 
2¡¢²åÈë
insert into system.t_htinfo  values ('3',utl_raw.cast_to_raw('Äã'));
3¡¢¸üÐÂ
update system.t_htinfo set fld_value=utl_raw.cast_to_raw('1') where fh_nm=1820648 and form_index=52
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ