SQLSERVERÐÞ¸´Ð¡ÖªÊ¶
ÔÚÓëÊý¾Ý¿â´ò½»µÀµÄ¹¤×÷ÖÐʱ³£»áÅöµ½Ò»Ð©Êý¾Ý¿âµÄ´íÎó£¬Õâ¾ÍÉæ¼°µ½ÁËÐÞ¸´µÄ¹ý³Ì£¬ÒÔÏÂ֪ʶµã¶¼ÊÇ´ÓÍøÉÏÊÕ¼¯¶øÀ´:
1¡¢dbcc checkdb
Õâ¸öÃüÁî¿ÖÅÂÊÇÎÒÃÇ×î³£ÓõÄÁË£¬´ø¼ì²éºÍÐÞ¸´¹¦ÄÜ
Óï·¨¸ñʽ£º
DBCC CHECKDB
[
[ ( database_name | database_id | 0
[ , NOINDEX
| , { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ]
) ]
[ WITH
{
[ ALL_ERRORMSGS ]
[ , EXTENDED_LOGICAL_CHECKS ]
[ , NO_INFOMSGS ]
[ , TABLOCK ]
[ , ESTIMATEONLY ]
[ , { PHYSICAL_ONLY | DATA_PURITY } ]
}
]
]
REPAIR_ALLOW_DATA_LOSS ¸Ã²ÎÊý»á³¢ÊÔÐÞ¸´ËùÓдíÎ󣬵«ÔÚÐÞ¸´µÄ¹ý³ÌÖлá³öÏÖÊý¾ÝµÄ¶ªÊ§
REPAIR_FAST ¸Ã²ÎÊý½øÐÐСµÄ¡¢²»ºÄʱµÄÐÞ¸´²Ù×÷£¬ÈçÐÞ¸´·Ç¾Û¼¯Ë÷ÒýÖеĸ½¼Ó¼ü¡£ÕâЩÐÞ¸´¿ÉÒԺܿìÍê³É£¬²¢ÇÒ²»»áÓжªÊ§ Êý¾ÝµÄΣÏÕ¡£
REPAIR_REBUILD ¸Ã²ÎÊýÖ´ÐÐÓÉ REPAIR_FAST Íê³ÉµÄËùÓÐÐÞ¸´£¬°üÀ¨ÐèÒª½Ï³¤Ê±¼äµÄÐÞ¸´£¨ÈçÖØ½¨Ë÷Òý£©¡£Ö´ÐÐÕâЩÐÞ¸´Ê±²» »áÓжªÊ§Êý¾ÝµÄΣÏÕ¡£
DBCC CHECKDB ¶ÔË÷ÒýÊÓͼִÐÐÎïÀíÒ»ÖÂÐÔ¼ì²é¡£Ö»ÓÃÓÚÏòºó¼æÈÝµÄ NOINDEX Ñ¡ÏîÒ²ÊÊÓÃÓÚË÷ÒýÊÓͼÉϵÄÈκθ¨ÖúË÷Òý¡£
DBCC CHECKDB ÊÇ×ȫµÄÐÞ¸´Óï¾ä£¬ÒòΪËü¶Ô×î¶àµÄ¿ÉÄܳöÏֵĸ÷ÖÖ´íÎó½øÐбêʶºÍÐÞ¸´¡£Èç¹ûÖ»±¨¸æÊý¾Ý¿âÖÐÓзÖÅä´íÎó£¬ÇëÖ´ÐдøÐÞ¸´Ñ¡ÏîµÄ DBCC CHECKALLOC ÒÔ¶ÔÕâЩ´íÎó½øÐÐÐÞ¸´¡£È»¶ø£¬ÈôҪȷ±£ÕýÈ·ÐÞ¸´ËùÓдíÎ󣨰üÀ¨·ÖÅä´íÎ󣩣¬ÇëÖ´ÐдøÐÞ¸´Ñ¡ÏîµÄ DBCC CHECKDB£¬¶ø²»ÒªÖ´ÐдøÐÞ¸´Ñ¡ÏîµÄ DBCC CHECKALLOC¡£
DBCC CHECKDB ¶ÔÊý¾Ý¿âÖÐËùÓÐÄÚÈݵÄÍêÕûÐÔ½øÐÐÑéÖ¤¡£Èç¹ûµ±Ç°ÕýÔÚÖ´Ðлò×î½üÒÑÖ´ÐÐ DBCC CHECKDB£¬Ôò²»ÐèÒªÔËÐÐ DBCC CHECKALLOC »ò DBCC CHECKTA
Ïà¹ØÎĵµ£º
Create Procedure up_InsertData2
@ID INT
AS
BEGIN
Declare @Name NVARCHAR(30)
Declare @c1 NVARCHAR(30)
Declare @c2 NVARCHAR(30)
Declare @c3 NVARCHAR(30)
Declare @c4 NVARCHAR(30)
Declare tmpCur Cursor For Select a,b,c,d from table1
Open tmpCur;
Fetch Next from tmpCur Into @c1,@c2,@c3 ......
ÔÚSQLÓï¾äÖÐͨ¹ýϵͳ´æ´¢¹ýsp_addextendedproperty¿ÉΪ±í×Ö¶ÎÌí¼ÓÉ϶¯Ì¬µÄ˵Ã÷£¨±¸×¢£©ÏÂÃæÊÇSQL SERVER°ïÖúÎĵµÖжÔsp_addextendedproperty´æ´¢¹ý³ÌµÄÃèÊö
Óï·¨
sp_addextendedproperty
[ @name = ] { 'property_name' }
[ , [ @value = ] { 'value' }
&nbs ......
CREATE function fGetPy(@str varchar(500)='')
returns varchar(500)
as
begin
declare @strlen int,@return varchar(500),@ii int
declare @c nchar(1),@chn nchar(1)
select @strlen=len(@str),@retur ......
»ù±¾ÅäÖÃ
Ò»¡¢ÎļþϵͳҪÇó£º
1¡¢ÖÁÉÙÓжþ¸ö·ÖÇø£»
2¡¢ÏµÍ³·ÖÇø²»Ð¡ÓÚ10G£»
3¡¢·ÖÇø¸ñʽ±ØÐëÊÇNTFS¡£
¶þ¡¢²¹¶¡°²×°ÒªÇó£º
1¡¢ÏȰ²×°Íê±ÏWINDOWS 2000 SP4+³å»÷²¨+Õðµ´²¨²¹¶¡£»
2¡¢½«WINDOWS 2000²¹¶¡Éý¼¶µ½×îкó²Å¿É°²×°cluster ºÍSQL Server£»
3¡¢SQL Server²¹¶¡ÐèÉý¼¶µ½Service Pack 3¡£
Èý¡¢ClusterÐÅÏ¢£º
1£ ......
½ñÌìÒ»²»Àä¾²¾Í°ÑsqlserverÊý¾Ý¿â³õʼ»¯ÁË£¬ÔÚÍøÉÏÕÒÁ˰ëÌì·¢ÏÖÁ˼¸ÆªÌû×Ó£¬ÊÜÒæ·Çdz£¬¼Ç¼ÏÂ
DB2ÖпÉÒÔʹµÃÊý¾Ý¿â»Ø¸´µ½Ö¸¶¨µÄʱ¼äµã£¬SQL ServerÊý¾Ý¿âµÄRecovery ModelΪfull »òÕßBulk copyµÄʱºò£¬ÊÇ¿ÉÒÔ´ÓÈÕÖ¾À´»Ö¸´Êý¾Ý¿âµÄ¡£Êµ¼ÊÉÏÈÕÖ¾ÖмǼµÄÒ»ÌõÒ»ÌõµÄtransact sqlÓï¾ä£¬»Ö¸´Êý¾Ý¿âµÄʱºò»áredoÕâЩsqlÓï¾ä¡£&nb ......