SQL Serer´úÀí·þÎñÊý¾Ý¿â
SQL Serer´úÀí·þÎñ
¶ÔÓÚÒ»¸öSQL Serverϵͳ¹ÜÀíÔ±À´Ëµ£¬ËûÿÌ춼ÃæÁÙ×ÅÐí¶à²»Í¬µÄÈÎÎñÀ´Ö´ÐУ¬ÀýÈç¼ì²éÒ»¸ö»ò¶à¸ö·þÎñÆ÷£¬µ÷½ÚºÍÓÅ»¯Êý¾Ý¿âµÄÐÔÄÜ£¬ÐÞ¸ÄÊý¾Ý¿âµÄ²¼¾ÖÉè¼ÆºÍÊý¾Ý¿â±í£¬Âú×ãÏÖÔںͽ«À´µÄÐèÒª,RAID1¡£Ò»°ãÀ´Ëµ£¬±£³ÖÊý¾Ý¿âÔÚËùÓй¤×÷ʱ¼äÄܹ»×îÓÅ»¯µÄÖ´ÐÐÊÇϵͳ¹ÜÀíÔ±µÄÄ¿±ê£¬ÎªÁË´ïµ½Õâ¸öÄ¿±ê£¬ÏµÍ³¹ÜÀíÔ±±ØÐë·Ç³£ÓÐЧµØ×éÖ¯ËùÓÐÈÎÎñ¡£SQL ServerÌṩµÄ·þÎñ¹¤¾ß£¬ÌرðÊÇSQL Server agent(SQL Server´úÀí£©Äܹ»°ïÖúϵͳ¹ÜÀíÔ±´ïµ½Õâ¸öÄ¿±ê¡£
SQL Server´úÀíÊÇÒ»¸öÈÎÎñ¹æ»®Æ÷ºÍ¾¯±¨¹ÜÀíÆ÷£¬ÔÚʵ¼ÊÓ¦ÓÃʱ£¬¿ÉÒÔ½«ÄÇЩÖÜÆÚÐԵŤ×÷¶¨Òå³ÉÒ»¸öÈÎÎñ£¬SQL Server´úÀíµÄ°ïÖúÏÂ×Ô¶¯Ö´ÐУ»ÔÚ×Ô¶¯Ö´ÐÐʱ£¬Èô³öÏÖ¹ÊÕÏ£¬ÔòSQL Server´úÀí×Ô¶¯Í¨Öª²Ù×÷Ô±£¬²Ù×÷Ô±»ñµÃ֪ͨºó¼°Ê±Åųý¹ÊÕÏ¡£Èç´ËÔÚÈÎÎñ¡¢²Ù×÷Ô±¡¢±¨¾¯ÈýÕßÖ®¼ä¼´Ï໥¶ÀÁ¢£¬ÓÖÏ໥ÁªÏµ¡¢Ï໥²¹³ä£¬¹¹³ÉÁË×Ô¶¯Íê³ÉijЩÈÎÎñµÄÓлúÕûÌå¡£
Ò»¡¢SQL Serer´úÀí·þÎñÅäÖÃ
SQL Server´úÀíÔÊÐí×Ô¶¯´¦Àí²»Í¬µÄ¹ÜÀíÈÎÎñ£»µ«ÔÚ×ö֮ǰ£¬±ØÐëÆô¶¯SQL Server´úÀí¡£SQL Server´úÀí¿ÉÒÔʹÓúÍSQL Server ServiceÏàͬµÄ·½·¨Æô¶¯¡£
Æô¶¯ºó¿ÉÒÔÀûÓÃSQL Server Enterprise Manager£¨ÆóÒµ¹ÜÀíÆ÷£©¶ÔÆä½øÐÐÅäÖã¬Æä¾ßÌå²½ÖèÈçÏ£º
(1)´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬´ò¿ª¹ÜÀíÎļþ¼Ð£¬Æô¶¯SQL Server´úÀí¡£ÓÒ»÷Êó±ê£¬Ñ¡ÔñÊôÐÔ£¬ÉèÖÓ³£¹æ”ÖеÄÑ¡Ïî¡£
(2)
(3)
(4)
(5)
ÉòÑô¿ÎÄÊý¾Ý»Ö¸´ÖÐÐÄÒѾ³É¹¦½â¾ö£º±íɾ³ýÓëÐÐÊý¾Ýɾ³ýµÄ»Ö¸´
ÔÚSql Server2000¡¢SqlServer2005ÔËÐÐÔÚ¼òµ¥ÈÕ־ģʽ¡¢ÍêÈ«ÈÕ־ģʽ»òÕß´óÈÝÁ¿ÈÕÖ¾¼Ç¼ģʽÏÂÊý¾Ý±»Îó(drop¡¢delete¡¢truncate£©É¾³ý±í»Ö¸´,updataºóµÄÊý¾Ý»Ö¸´µÈ
sql serverÊý¾Ý»Ö¸´ TEL£º13386848847 QQ£º81803950 68877893
Ö»ÒªÄúÓÐÊý¾ÝÎļþ£¬ÉòÑô¿ÎÄÊý¾Ý»Ö¸´ÖÐÐĽ«Äܹ»×î´ó³Ì¶ÈµÄ»Ö¸´ÄãµÄÊý¾Ý¿â¡£
¼´Ê¹ÄúûÓÐÊý¾ÝÎļþ£¬Ö»ÒªÌṩÔÀ´Êý¾Ý¿â´æ´¢µÄÓ²ÅÌ£¬ÉòÑô¿ÎÄÊý¾Ý»Ö¸´ÖÐÐÄÒ²¿É½øÐÐ×îµÍ²ãµÄËéƬ¼¶Êý¾Ý¿â»Ö¸´¡£
¡¡
ÒÔÉÏÇé¿ö,ÊDZ¾ÖÐÐÄÒÑÓдóÁ¿³É¹¦°¸Àý.ÔÚÆäËû¹«Ë¾»Ö¸´²»ÂúÒâµÄ¿Í»§,¿ÉÔÚÉòÑô¿ÎÄÊý¾Ý»Ö¸´ÖÐÐĵõ½ÒâÏë²»µ½µÄÊÕ»ñ.
¾ßÌåÇé¿ö,ÇëÀ´µç×Éѯ:13386848847 024-31065488 24Сʱ
ÍâµØ¿Í»§¿ÉÒÔ¼ÓÎÒ¹«Ë¾QQ£º81803950 68877893£¬½«Òª»Ö¸´µÄÊý¾Ý¿âÎļþѹËõ£¬È»ºó´«À´£¬¼´¿É»Ö¸´¡£
רҵ½øÐÐSQL SERVER¸÷ÖÖÔÖÄÑÇé¿öϵÄÊý¾Ý»Ö¸´£¬¾ßÓжà¸ö´óÐÍÊý¾Ý¿â»Ö¸´µÄ³É¹¦¾ÑéÏà¹ØµÄÖ÷ÌâÎÄÕ£º
S
Ïà¹ØÎĵµ£º
Rebuild indexes online with SQL Server 2005
http://blogs.techrepublic.com.com/datacenter/?p=249
Online index rebuild
SQL Server 2005 introduces the ability to rebuild your indexes in an
online fashion so that other processes are able to access the table
while the rebuild is occurring. Because y ......
[code=SQL][/code]
--Óï ¾ä ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE --´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE --´ÓÊý¾Ý¿âÖÐɾ ......
SELECT OrderId, TableName, replace(PrimaryKeyColumn,'''','''''') as PrimaryKeyColumn, ColumnState,cast(IsUpdating as varchar) as IsUpdating, OperateTime, ValueColumn, SystemTypeID from SubCompFtpDataDairy where OperateTime>=dateadd(hh,-24,getdate()) ......
´ÓA±íËæ»úÈ¡10Ìõ¼Ç¼,ÓÃSELECT TOP 10 * from ywle order by newid()
order by Ò»°ãÊǸù¾Ýijһ×Ö¶ÎÅÅÐò,newid()µÄ·µ»ØÖµ ÊÇuniqueidentifier ,order by newid()Ëæ»úÑ¡È¡¼Ç¼ÊÇÈçºÎ½øÐеÄ
newid()ÔÚɨÃèÿÌõ¼Ç¼µÄʱºò¶¼Éú³ÉÒ»¸öÖµ, ¶øÉú³ÉµÄÖµÊÇËæ»úµÄ, ûÓдóСд˳Ðò. ËùÒÔ×îÖÕ½á¹ûÔÙ°´Õâ¸öÅÅÐò, ÅÅÐòµÄ½á¹ûµ±È»¾ÍÊÇÎ ......
Ò»¡¢Êý¾Ý¿â°æ±¾
Êý¾ÝѹËõÔÚSql Server 2008ÉϲÅÖ§³Ö£¬2005²»ÐУ¬²¢ÇÒ»¹ÒªÊÇÆóÒµ°æ¡£ÎÒ³£³£ÍüÁËÕâÒ»µã£¬ÔÚ2005µÄStudioÉÏÄÖ³öÓï·¨´íÎóµÄ×´¿ö£¬ÕÛÌÚÀË·ÑÁ˺ÃÒ»Õó²ÅÐÑÎò¹ýÀ´¡£
¶þ¡¢Ñ¹Ëõ×´¿ö
´óÔ¼¿ÉÒÔ½ÚÊ¡20%-50%µÄ¿Õ¼ä£¬²¢ÇÒÐÐѹËõºÍҳѹËõÓÐËùÇø±ð¡£
µ«ÈÃÎÒʧÍûµÄÊÇ£¬Ïñº¬ÓÐVarchar(max),xmlÕâÖÖ×Ö¶ÎÀàÐ͵ģ¬·´¶øËƺõѹ ......