SQL ServerÈçºÎÌá¸ßÊý¾Ý¿â»¹ÔµÄËÙ¶È
Ó°ÏìÊý¾Ý¿â»¹ÔËٶȵÄÒòËغÍÓ°ÏìÊý¾Ý¿â±¸·ÝËٶȵÄÒòËØÏàͬ¡£³ý´ËÖ®Í⣬¼ÙÈçÄãʹÓÃSQL Server 2005µÄ»°£¬Ä㻹¿ÉÒÔÆô¶¯ÁíÍâÒ»¸öÓÅ»¯ÈÎÎñÀ´»¹Ôµ±Ç°²»´æÔÚµÄÊý¾Ý¿â£¬ÔËÐл·¾³ÎªWindows XP£¬Windows 2003 Server »ò¸üа汾¡£
Perform Volume Maintenance Tasks
µ±Ä㻹ÔÒ»¸öеÄÍêÕûÊý¾Ý¿âÊÇ£¬SQL Server¶Á±¸·ÝÎļþÍ·£¬È»ºó´´½¨ÔʼÊý¾Ý¿âÖÐÊý¾ÝºÍÈÕÖ¾ÎļþÐèÒªµÄ´ÅÅ̿ռ䡣¼ÙÈçSQL Server·þÎñÆô¶¯ÕÊ»§Ã»ÓГPerform Volume Maintenance Tasks”ȨÏ޵Ļ°£¬Êý¾ÝºÍÈÕÖ¾Îļþ¾ÍÐèÒª±»³õʼ»¯Îª0£¬Ò²¾ÍÊÇ˵£¬SQL ServerÏÈ´´½¨ÕâЩÎļþ£¬È»ºóÓÃ0À´Ìî³äËüÃÇ¡£¶ÔÓÚÒ»¸ö´óÊý¾Ý¿âÀ´Ëµ£¬Õ⽫»¨·ÑºÜ¶àʱ¼ä¡£ÎҼǵÃʹÓÃSQL Server 2000´Ó´Å´øÉÏ»¹ÔÒ»¸ö320GBµÄÊý¾Ý¿âʱ£¬×ÜÊÇÆæ¹ÖΪʲô×ÜÊÇÓÐ30·ÖÖÓµÄʱ¼ä£¬»¹Ô½ø³ÌÒ»µã³Æ½øÕ¹¶¼Ã»ÓС£
È»ºó£¬¼ÙÈçSQL Server·þÎñÆô¶¯ÕÊ»§ÓГPerform Volume Maintenance Tasks”ȨÏ޵Ļ°£¬Ëü¾Í»á¸ù¾Ý´óСÀ´´´½¨Êý¾ÝÎļþ£¬Ìø¹ý“Ìî³ä0”Õâ¸ö½×¶Î¡£
ÏÂͼʹÓÃsecpol.mscÀ´ÏÔʾȨÏÞ
Äã¿ÉÒÔÉèÏëÒ»ÏÂËü»á½ÚÊ¡Äã¶àÉÙ»¹Ô´óÐÍÊý¾Ý¿âµÄʱ¼ä¡£×¢Ò⣬ÊÂÎñÈÕÖ¾ÎļþÈÔÈ»ÐèÒª“Ìî³ä0”£¬½ö½öÊÇÊý¾ÝÎļþ¿ÉÒÔÌø¹ýÕâÒ»²½¡£
×¢Ò⣺µ±È»Ê¹ÓÃÐÂȨÏÞʱ£¬ÒªÆô¶¯SQL Server·þÎñÀ´Ê¹Ö®ÉúЧ
ÏÂÃæÊÇÒ»¸ö»¹Ô20GBÊý¾ÝºÍ5GBÊÂÎñÈÕÖ¾ËùÏûºÄʱ¼äµÄ¶ÔÕÕ±í
»¹ÔÏûºÄʱ¼ä
δʹÓÔPerform Volume Maintenance Tasks”
5:05
ʹÓÓPerform Volume Maintenance Tasks”
1:01
ÏûºÄ1:01ʱ¼äÊÇÒòΪSQL ServerÈÔȻҪ°ÑÊÂÎñÈÕÖ¾Îļþ½øÐГÌî³ä0”²Ù×÷£¬Î´Ê¹ÓÔPerform Volume Maintenance Tasks”µÄÇé¿öÏ£¬SQL ServerÐèÒª°ÑÊý¾ÝÎļþºÍÊÂÎñÈÕÖ¾¶¼½øÐГÌî³ä0”µÄ²Ù×÷£¬ËùÒÔ»¹Ôʱ¼äÏÔʾ±ä³¤ÁË¡£
Äã¿ÉÒÔÓÃÏÂÃæÕâ¸ö½Å±¾À´¿ìËÙÈ·¶¨µ±Ç°ÊÇ·ñʹÓÃÁËPVMT(Perform Volume Maintenance Tasks)¡£
CREATE DATABASE test_InstantInit ON
PRIMARY (name = 'test_InstantInit', filename = 'k:\temp\test_InstantInit.mdf', size = 1GB)
LOG ON (name = 'test_InstantInit_log', filename = 'k:\temp\test_InstantInit.ldf', size = 1MB)
DROP DATABASE test_InstantInit
Õû¸ö½Å±¾Èç¹ûÔÚ¼¸ÃëÄÚÍê³É¾ÍÖ¤Ã÷ʹÓÃÁËPVMT¡£
ÕâÀﻹÓÐÒ»µãÐèҪ˵Ã÷µÄµØ·½¡£µ±SQL ServerÌø¹ý“Ìî³ä0”½×¶Î¿Õ¼äʱ£¬Èç¹ûÊý¾ÝÎļþËùÕ¼ÓõĿռäÀïÃæ°üÀ¨ÒÔÇ°µÄÊý¾Ý£¬ÄÇôʹÓÃDBCC
Ïà¹ØÎĵµ£º
DDL´¥·¢Æ÷ DDL Triggers
SQL Server 2005¿ÉÒÔ¾ÍÕû¸ö·þÎñÆ÷»òÊý¾Ý¿âµÄij¸ö·¶Î§ÎªDDLʼþ¶¨Òå´¥·¢Æ÷¡£Ò²¿ÉÒÔΪµ¥¸öDDLÓï¾ä£¨ÀýÈ磺CREAT_TABLE¡¢DROP_TABLEµÈ£©»òÕßΪһ×éÓï¾ä£¨ÀýÈ磺ָ¶¨DDL_DATABASE_LEVEL_EVENTSÏëÒª´¥·¢Æ÷´¥·¢Êý¾Ý¿âËùÓÐDDLʼþ£©¶¨ÒåDDL´¥·¢Æ÷¡£
ÔÚDDL´¥·¢Æ÷ÄÚ²¿£¬¿ÉÒÔͨ¹ý·ÃÎÊeventdata()º¯Êý»ñµÃÓ ......
Ê×Òª²½Öè(Ò»°ã¿ÉÊ¡ÂÔ):
¿ªÆômysql·þÎñ(ĬÈÏÊÇ¿ª»úʱ¾Í×Ô¶¯ÔËÐÐÁË):
¿ØÖÆÃæ°å
-->¹ÜÀí¹¤¾ß-->·þÎñ,ÔÚÀïÃæÕÒµ½Ãû³ÆΪmysqlµÄÏî,Ë«»÷¾Í¿É¿´ËüµÄ·þÎñ״̬ÊÇÆô¶¯»¹ÊÇÍ£Ö¹,°ÑËüÉèΪÆô¶¯
Á¬½Ómysql:
ÔÚÃüÁîÐÐÏÂÊäÈë mysql -h
localhost -u root -p»Ø³µ,È»ºóÊäÈëÃÜÂë¼´¿É;»òÖ±½ÓÔËÐÐmysql×Ô´øµÄÁ¬½Ó¹¤¾ß,È»ºóÊäÈëÃÜÂë¼ ......
/*
±êÌ⣺ÆÕͨÐÐÁÐת»»(version 2.0)
×÷Õߣº°®Ð¾õÂÞ.ع»ª
ʱ¼ä£º2008-03-09
µØµã£º¹ã¶«ÉîÛÚ
˵Ã÷£ºÆÕͨÐÐÁÐת»»(version 1.0)½öÕë¶Ôsql server 2000Ìṩ¾²Ì¬ºÍ¶¯Ì¬Ð´·¨£¬version 2.0Ôö¼Ósql server 2005µÄÓйØд·¨¡£
ÎÊÌ⣺¼ÙÉèÓÐÕÅѧÉú³É¼¨±í(tb)ÈçÏÂ:
ÐÕÃû ¿Î³Ì ·ÖÊý
ÕÅÈý ÓïÎÄ 74
ÕÅÈý Êýѧ 83
ÕÅÈý ÎïÀí 93 ......
¹ØÓÚÁ½±í¹ØÁªµÄupdate£¬µ«Óï¾äÔõôд¶¼²»ÕýÈ·£¬ÀÏÊDZ¨´í£¬ÓÚÊÇÐľªÈâÌø£¨¾ÍŲ»Äܼ°Ê±Íê³É²Ù×÷£©È¥²éÁËһϣ¬NND£¬ÔÀ´°ÑSQLд³ÉÁËÔÚSQL ServerÏÂÃæµÄÌØÓÐÐÎʽ£¬ÕâÖÖÓï·¨ÔÚOracleÏÂÃæÊÇÐв»Í¨µÄ£¬¼±Ã¦¸Ä»ØÀ´£¬¼°Ê±Íê³ÉÁËÈÎÎñ¡£Ë³±ãÒ²°Ñ²éµ½µÄSQLÌû³öÀ´£¬ÄÄÌìÔÙÍü¼ÇÁË£¬Ò²ºÃÔÚÕâÀïÕÒ»ØÀ´£º
update customers a ......
Sqlʱ¼äº¯Êý
Ò»¡¢sql serverÈÕÆÚʱ¼äº¯Êý
Sql ServerÖеÄÈÕÆÚÓëʱ¼äº¯Êý
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
......