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

ÈçºÎ¿ªÆôSQLSERVERÊý¾Ý¿â»º´æÒÀÀµÓÅ»¯ÍøÕ¾ÐÔÄÜ


ÈçºÎ¿ªÆôSQLSERVERÊý¾Ý¿â»º´æÒÀÀµÓÅ»¯ÍøÕ¾ÐÔÄÜ
Êý¾Ý¿â, »º´æ, SQLSERVER, ÐÔÄÜ
ºÜ¶àʱºò£¬ÎÒÃÇ·þÎñÆ÷µÄÐÔÄÜÆ¿¾±»áÊÇÔÚ²éѯÊý¾Ý¿âµÄʱºò£¬ËùÒÔ¶ÔÊý¾Ý¿âµÄ»º´æ·Ç³£ÖØÒª£¬ÄÇôÓÐûÓÐÒ»ÖÖ·½·¨£¬¿ÉÒÔʵÏÖSQL SERVERÊý¾Ý¿âµÄ»º´æ£¬µ±Êý¾Ý±íûÓиüÐÂʱ£¬¾Í´Ó»º´æÖжÁÈ¡£¬µ±ÓиüеÄʱºò£¬²Å´ÓÊý¾Ý±íÖжÁÈ¡ÄØ£¬´ð°¸Êǿ϶¨µÄ£¬ÕâÑùµÄ»°ÎÒÃǶÔһЩ³£ÓõĻù´¡Êý¾Ý±í¾Í¿ÉÒÔ»º´æÆðÀ´£¬±ÈÈç×öÐÂÎÅϵͳµÄÐÂÎÅÀà±ðµÈ£¬Ã¿´Î¾Í²»ÐèÒª´ÓÊý¾Ý¿âÖжÁÈ¡ÁË£¬¼Ó¿ìÍøÕ¾µÄ·ÃÎÊËٶȡ£
ÄÇôÈçºÎ¿ªÆôSQLSERVERÊý¾Ý¿â»º´æÒÀÀµ£¬·½·¨ÈçÏ£º
µÚÒ»²½£ºÐÞ¸ÄWeb.ConfigµÄ<system.web>½ÚµÄÅäÖ㬴úÂëÈçÏ£¬ÈÃÍøÕ¾ÏîÄ¿ÆôÓÃSqlCacheDependency¡£×¢ÒâÏÂÃæ´úÂëÖеÄconnectionStringName,¾ÍÊÇÖ¸¶¨µÄ<connectionStrings>½ÚÖеÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®±äÁ¿Ãû³Æ¡£nameÔòÊÇΪ¸ÃSqlCacheDependencyÆðµÄÃû×Ö£¬Õâ¸öÃû×Ö½«ÔÚµÚÈý²½ÖÐÓõ½¡£SqlCacheDependencyÀà»á×Ô¶¯Íê³É¶Ô´ËÅäÖýÚÐÅÏ¢µÄ¶ÁÈ¡ÒÔ½¨Á¢ºÍÊý¾Ý¿âÖ®¼äµÄÁªÏµ¡£
view source
< id="highlighter_422634_clipboard" title="copy to clipboard" classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="16" height="16" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0" type="application/x-shockwave-flash">
print?
01.<system.web>
02.<httpHandlers>
03.<add verb="*" path="*.aspx"
04.type="URLRewriter.RewriterFactoryHandler, URLRewriter" />
05.<add verb="*" path="*.shtml"
06.type="URLRewriter.RewriterFactoryHandler, URLRewriter" />
07.<add verb="*" path="*.bobo"
08.type="URLRewriter.RewriterFactoryHandler, URLRewriter" />
09.  
10.</httpHandlers>
11.<!-->ÒÔÏÂ<SPAN class=t_tag onclick=tagshow(event) href="tag.php?name=%C9%E8%D6%C3">ÉèÖÃ</SPAN>Êý¾Ý¿â»º´æÒÀÀµ·½Ê½-->
12.<caching>
13.<sqlCacheDependency enabled="true" pollTime="6000">
14.<databases>
15.<add name="YD_JWC_JAKE" connectionStringName="cachestr"/>
16.</databases>
17.</sqlCacheDependency>
18.</caching>
19.<!-- 
20.ÉèÖà compilation debug="true" ½«µ÷ÊÔ·ûºÅ²åÈë
21.ÒÑ<SPAN class=t_t


Ïà¹ØÎĵµ£º

ExcelµÄÊý¾Ýµ¼Èëµ½sqlserverÊý¾Ý¿â

  ½ñÌìÔÚ¸ø¹«Ë¾×öÍøվʱ£¬Ö÷¹Ü¸øÁËÒ»¸öеÄÐèÇó¸øÎÒ£¬ÓÉÓÚ¹«Ë¾µÄµç»°±íÊý¾Ý±È½Ï¶à£¬ÐèÒªµ¼Èëµ½Êý¾Ý¿â±íÖУ¬ËùÒÔÌØÒâµÄ´ÓÍøÉϲéÔÄÁËһЩ×ÊÁÏ£¬¼òÒ×µÄдÁ˸ö´ÖÂÔµÄÀ࣬»ù±¾Ô­ÀíÊÇ£º°ÑExcel×öΪÊý¾ÝÔ´£¬ÐγÉdatable¶ÔÏó£¬ È»ºóÔÚÊý¾Ý¿â½¨Á¢Ò»ÕűíÒ»ÁÐÒ»ÁеĽ«Êý¾ÝÌí¼Óµ½Ð±íÖУ¬ÊµÏÖµÄÀࣺ
 using System;
using S ......

SQLSERVER ´æ´¢¹ý³Ì Óï·¨

*** author£ºSusan
*** date:2005/08/05
*** expliation:ÈçºÎ寫´æ儲過³ÌµÄ¸ñʽ¼°Àý×Ó£¬ÓÐÓÎ標µÄÓ÷¨£¡
*** ±¾°æ:SQL SERVER °æ£¡
******************************************************/
ÔÚ´æ儲過³ÌÖеĸñʽ規¸ñ£º
CREATE PROCEDURE XXX
/*
ÁÐ舉傳Èë ......

SqlServer µÄ¼¸ÖÖ·ÖÒ³·½Ê½


·½Ê½Ò»£º
select top 200 * from view_OrganResource
where  1=1 and OrganID = 57 and
(OrderID not in(select top 1000 OrderID from tb_OrganResource
where  1=1 and  OrganID = 57 order by uploadtime desc))
order by uploadtime desc --5858 1980
·½Ê½¶þ£º
select top 200 * from
vi ......

¼òµ¥µÄ3¸öSQLÊÓͼ¸ã¶¨ËùÓÐSqlServerÊý¾Ý¿â×Öµä ת

Êý¾Ý¿â×Öµä°üÀ¨±í½á¹¹(·Ö2KºÍ2005£©¡¢Ë÷ÒýºÍÖ÷¼ü.Íâ¼ü.Ô¼Êø.ÊÓͼ.º¯Êý.´æ´¢¹ý³Ì.´¥·¢Æ÷.¹æÔò¡£¿ÉÒÔÔÚÆóÒµ¹ÜÀíÆ÷¡¢²éѯ·ÖÎöÆ÷Öмòµ¥Ö´ÐУ¬Ö±½ÓÁ˵±µÄ²é³öSQL2K¼°SQL2005µÄËùÓÐÊý¾Ý×ֵ䣬·½±ãÎĵµµÄ±àд£¬Ï£Íû¶Ô´ó¼ÒÓаïÖú¡£
1. SqlServer2000Êý¾Ý¿â×Öµä--±í½á¹¹.sql
SELECT TOP 100 PERCENT --a.id,
   & ......

ÈçºÎ»ñµÃsqlserverÊý¾Ý¿âÖÐÕ¼ÓøßcpuÓû§µÄ»î¶¯ÄÚÈÝ


ÈçºÎ»ñµÃsqlserverÊý¾Ý¿âÖÐÕ¼ÓøßcpuÓû§µÄ»î¶¯ÄÚÈÝ
1¡¢´Ó΢ÈíÕ¾µãÉÏÏÂÔØqslice_setup.exe
2¡¢´ò¿ªQuery Analyzer£¬ÔËÐÐÒÔÏÂÓï¾ä£º
declare @a int
while (1<2)
begin
select @a=1
end
½«»á·¢ÏÖcpuÂíÉÏ´ïµ½100%
3¡¢´ò¿ªqlice.exe£¬½«·¢ÏÖsqlserver.exeµÄcpuÕ¼ÓÃÂʺܸߣ¬Ë«»÷½øÈ룬³öÐÐsqlserver.exeÖоßÌåÏß³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ