SQL Server 2000Êý¾Ý¿âµÄ¶¨Ê±±¸·ÝÉèÖÃ
ÀûÓÃSQL2000µÄ¶¨Ê±±¸·Ý¹¦ÄÜ£¬ÄܺܺöԷþÎñÆ÷ÉϵÄÖØÒªÊý¾ÝÐÅÏ¢½øÐÐÍêÕûµÄ¶¨Ê±±¸·Ý£¬ÒÔ±ãÔÚ·þÎñÆ÷̱»¾»òÊý¾Ý¿â³öÏÖËð»µÊ±¼°Ê±µÄ½øÐлָ´¹¤×÷£¬ÒÔÈ·±£Æ½Ê±µÄ¹¤×÷ÄÜÕý³£µÄ½øÐС£ÏÂÃæÏò´ó¼Ò½éÉÜÒ»ÏÂSQL2000¶¨ÆÚ±¸·ÝµÄÉèÖ÷½·¨£¬¾ßÌåÈçÏ£º
1. ´ò¿ªSQL2000µÄÆóÒµ¹ÜÀíÆ÷
2. ÔÚ¶ÔÓ¦µÄSQL Server×éÖÐÑ¡Ôñ¶ÔÓ¦µÄSQLÁ¬½Ó£¬²¢µã»÷¡¾¹ÜÀí¡¿£¬Ñ¡Ôñ“Êý¾Ý¿âά»¤¼Æ»®”£¬ÈçÏÂͼËùʾ£º
3. ÔÚÓұ߿հ״¦µã»÷Êó±êÓÒ¼ü£¬ÔÚµ¯³öµÄ¶Ô»°¿òÖÐÑ¡Ôñ¡¾Ð½¨Î¬»¤¼Æ»®¡¿ºóµ¯³öÊý¾Ý¿âά»¤¼Æ»®Ïòµ¼¶Ô»°¿ò£¨ÈçÏÂͼËùʾ£©£¬µã»÷¡¾ÏÂÒ»²½¡¿¿ªÊ¼Î¬»¤¼Æ»®»ù±¾ÐÅÏ¢ÉèÖÃ
4. Ñ¡ÔñÊý¾Ý¿â
Ñ¡ÔñÄúÒª½¨Á¢Î¬»¤¼Æ»®µÄÊý¾Ý¿âÃû³Æ¡£¾ßÌåÉèÖÃÈçÏÂͼËùʾ£º
Ñ¡ÔñºóÐèҪά»¤µÄÊý¾Ý¿âÃû³Æºóµã»÷¡¾ÏÂÒ»²½¡¿
5. ¸üÐÂÊý¾Ý¿âÓÅ»¯ÐÅÏ¢
´ËÏîÉèÖÃÄܶÔÄúËùÑ¡ÔñµÄÊý¾Ý¿â½øÐÐÊý¾ÝÒ³ºÍË÷ÒýÒ³µÄÓÅ»¯¹¤×÷£¬Ê¹µÃÄúµÄÊý¾Ý¿âÔÚ³¤ÆÚʹÓúóÐÔÄÜÒÀÈ»Á¼ºÃ¡£¿É¸ù¾Ý×Ô¼ºµÄÐèÇó½øÐÐÏàÓ¦µÄÉèÖ㬾ßÌåÉèÖÃÐÅÏ¢ÈçÏÂͼ£º
6. ¼ì²éÊý¾ÝÍêÕûÐÔ
´ËÏîÉèÖÃÄÜʹµÃSQL2000ÔÚÄúÉèÖõĵ÷¶Èʱ¼äÄÚ×Ô¶¯Æô¶¯DBCC CheckDB¹¦Äܼì²éÄúÊý¾ÝµÄÍêÕûÐÔºÍË÷ÒýµÄÕýÈ·ÐÔ£¬ÒԱ㼰ʱ·¢ÏÖÓÉÓÚ¸÷ÖÖÔÒòÔì³ÉÄú¶ÔÊý¾Ý¿â²Ù×÷ºó·¢ÉúµÄÎÊÌ⣬²¢¼°Ê±¸øÓèÐÞ¸´¹¤×÷¡£½¨ÒéÄú¶Ô¸ÃÏî½øÐÐÉèÖ㬾ßÌåÉèÖÃÈçÏÂͼËùʾ£º
7. Ö¸¶¨Êý¾Ý¿â±¸·Ý¼Æ»®
´ËÏîÊÇÄú½øÐÐÊý¾Ý¿âά»¤ÉèÖüƻ®µÄ¹Ø¼ü£¬SQL2000¸ù¾ÝÄúµÄµ÷¶Èʱ¼äÉèÖûá×Ô¶¯¶ÔÄúµÄÊý¾Ý¿â½øÐж¨Ê±±¸·Ý£¬²¢½«±¸·ÝÎļþ´æ·ÅÔÚÄúÑ¡ÔñµÄÓ²¼þÉ豸ÉÏ£¬ÒÔ±ãÄúÒÔºóµÄ¼°Ê±»Ö¸´¡£¾ßÌåÉèÖÃÈçͼËùʾ£º
µã»÷¡¾¸ü¸Ä¡¿ÄÜÉèÖÃÄú¶¨ÆÚÆô¶¯¸Ã¹¦Äܵĵ÷¶Èʱ¼ä£¬¾ßÌåÉèÖÃÈçÏÂͼ£º
×¢£º½¨ÒéÄú½«¶¨ÆÚ±¸·ÝµÄµ÷¶Èʱ¼äµÄ·¢ÉúƵÂÊÉèÖÃΪÿÌ죬ÇÒÿÈÕƵÂÊÉèÖÃÔÚÍíÉÏÎÞÈ˹¤×÷µÄʱºò¡£ÒòΪÄúÈç¹ûÉèÖÃÔÚ¸ÃÊý¾Ý¿âÕýÔÚʹÓÃʱ¼ä£¬¿ÉÄÜ»á¶Ô±¸·ÝÓÐËùÓ°Ïì¡£
8. Ö¸¶¨±¸·ÝÎļþĿ¼
¾ßÌåÉèÖÃÈçÏÂͼ£º
˵Ã÷£º
l ¹´Ñ¡¡¾ÎªÃ¿¸öÊý¾Ý¿â½¨Á¢×Ó
Ïà¹ØÎĵµ£º
¶ÔÕâ¸ö½øÐÐÓÅ»¯
select n5001 Ãŵê,n5002 ²¿ÃÅ,n5004 С·ÖÀà,n5019 ÉÌÆ·±àÂë,c01d21 ÉÌÆ·Ãû³Æ,
nvl(xse,0)-nvl(dzxs,0) ÏúÊÛ,
mle ëÀû,
nvl(xl,0)-nvl(dzsl,0) ÏúÁ¿
from
(select n5001,n5002,n5004,n5019,sum(n5011) xse,sum(n5016) mle,sum(n5023) xl
from n50
where to_char(n5010,'yyyymmdd')>='20 ......
select top PageSize * from ±í
where Ìõ¼þ and id not in
(select top PageSize*(CurrentPageIndex-1) id from ±í where Ìõ¼þ order by ÅÅÐòÌõ¼þ)
order by ÅÅÐòÌõ¼þ
¡¶PageSize ÊÇGridViewÖÐÿҳÏÔʾµÄÐÅÏ¢ÌõÊý£¬PageSize*(CurrentPageIndex-1) ÔÚSQLÖв»Ê¶±ð£¬Ð趨Òå±äÁ¿À´Ìæ»»¡· ......
http://kang275284.javaeye.com/blog/154331
Ò»¡¢ ÏȽéÉÜÒ»ÏÂoracle
µÄSGA£ºÊý¾Ý¿âµÄϵͳȫ¾ÖÇø£¬SGAÖ÷ÒªÓÉÈý²¿·Ö¹¹
³É£º¹²Ïí³Ø¡¢Êý¾Ý»º³åÇø¡¢ÈÕÖ¾»º³åÇø¡£
1¡¢ ¹²Ïí³ØÓÖÓÉÁ½²¿·Ö¹¹³É£º¹²ÏíSQL
Çø
ºÍÊý¾Ý×ֵ仺³åÇø¡£¹²ÏíSQL
ÇøרÃÅ´æ·ÅÓû§SQL
Ãü
Áoracle
ʹÓÃ×î½ü×îÉÙʹÓõÈÓÅÏȼ¶Ëã·¨À´¸üи²¸Ç£ ......
@ECHO OFF
ECHO /////////////////////////////////////////////////
ECHO // Microsoft SQL Server 2005 ÕûºÏ¡¢¼¯³ÉSP3
ECHO // Author : cxygoo
ECHO // Date : 2008-12-22
ECHO /////////////////////////////////////////////////
ECHO ÔËÐдËÅú´¦ÀíÇ°£¬µÃ½¨Ä¿Â¼£ºC:\SQL2005,C:\SQL200 ......
sysobjects ±í
ÔÚÊý¾Ý¿âÄÚ´´½¨µÄÿ¸ö¶ÔÏó£¨Ô¼Êø¡¢Ä¬ÈÏÖµ¡¢ÈÕÖ¾¡¢¹æÔò¡¢´æ´¢¹ý³ÌµÈ£©ÔÚ±íÖÐÕ¼Ò»ÐС£Ö»ÓÐÔÚ tempdb ÄÚ£¬Ã¿¸öÁÙʱ¶ÔÏó²ÅÔڸñíÖÐÕ¼Ò»ÐС£
ÁÐÃû Êý¾ÝÀàÐÍ ÃèÊö
name sysname ¶ÔÏóÃû¡£
Id int ¶ÔÏó±êʶºÅ¡£
xtype char(2) ¶ÔÏóÀàÐÍ¡£¿ÉÒÔÊÇÏÂÁжÔÏóÀàÐÍÖеÄÒ»ÖÖ£º
C = CHECK Ô¼Êø
D = ĬÈÏÖµ»ò DEFA ......