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

MsSql ²é¿´ÐÅÏ¢ºÃÓï¾ä

set statistics profile on
set statistics io on
set statistics time on
select top 1 * from et_order order by pkid desc
½á¹ûÈçÏ£º
SQL Server ·ÖÎöºÍ±àÒëʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
SQL Server Ö´ÐÐʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
SQL Server Ö´ÐÐʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
SQL Server Ö´ÐÐʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 1 ºÁÃë¡£
(1 ÐÐÊÜÓ°Ïì)
±í 'ET_Order'¡£É¨Ãè¼ÆÊý 1£¬Âß¼­¶ÁÈ¡ 4 ´Î£¬ÎïÀí¶ÁÈ¡ 0 ´Î£¬Ô¤¶Á 0 ´Î£¬lob Âß¼­¶ÁÈ¡ 0 ´Î£¬lob ÎïÀí¶ÁÈ¡ 0 ´Î£¬lob Ô¤¶Á 0 ´Î¡£
(3 ÐÐÊÜÓ°Ïì)
SQL Server Ö´ÐÐʱ¼ä:
   CPU ʱ¼ä = 0 ºÁÃ룬ռÓÃʱ¼ä = 8 ºÁÃë¡£
ÁíÒ»¸ö°ì·¨Îª£º
declare   @begin_date   datetime  
  declare   @end_date   datetime  
  select   @begin_date   =   getdate()  
  exec   ´æ´¢¹ý³Ì    
  select   @end_date   =   getdate()  
  select   datediff(ms,@begin_date,@end_date)   as   'ÓÃʱ/ºÁÃë'


Ïà¹ØÎĵµ£º

MSSQLÈÕÖ¾Îļþ¼°Æä´¦ÀíÏê½â


ÈçºÎÇå³ýMSSQLÊÂÎñÈÕÖ¾Îļþ
   ÈýÖÖ·½·¨£º  
    
1¡¢É¾³ýLOG  
    
   1)£º·ÖÀëÊý¾Ý¿âÆóÒµ¹ÜÀíÆ÷£­£¾·þÎñÆ÷£­£¾Êý¾Ý¿â£­£¾ÓÒ¼ü£­£¾·ÖÀëÊý¾Ý¿â      
   2)£ºÉ¾³ýLOGÎļþ  & ......

ASP.netÒ³ÃæÊµÏÖMSSQLÊý¾Ý¿âµÄ´´½¨ºÍ²Ù×÷£¬Êǿⴴ½¨£¡

///   <summary>  
        ///   ´´½¨Êý¾Ý¿â¡£  
        ///   </summary>
        ///   <param name="srvName">±íÊ ......

aspÁ¬½ÓMssqlµÄ·½·¨¼°³£¼ûµÄ´íÎó

aspÏνÓMssqlµÄ°ì·¨¼°³£¼ûµÄ²î´í
//µÚÒ»ÖÖд·¨£º
MM_conn_STRING = "Driver={SQL Server};server=(local);uid=sa;pwd=;database=infs;"
Set conn = Server.Createobject("ADODB.Connection")
conn.open MM_conn_STRING
SET RS=SERVER.CreateObject("ADOBD.recordset")
SQL="SELECT * from TABLE ORDER BY ID DESC"
R ......

Linux»·¾³µÄAMP°²×° MSSQLÀ©Õ¹°²×°


LinuxÒª°²×°mssqlÀ©Õ¹£¬±ØÐëÊ×ÏȰ²×°freetds£¬°²×°¹ý³ÌÈçÏ£º
1¡¢¼ÙÉèÔ´ÎļþĿ¼Ϊ/webServ£¬°²×°Ä¿Â¼Îª/opt/freetds¡£
1) >cd /webServ
2) ÏÂÔØ£¬ >wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
3) ½âѹ£¬ >tar -zxvf freetds-stable.tgz
4) ½øÈ룬 >cd freetds-0¡£ ......

MSSQLÈ«ÎļìË÷

MSSQLÈ«ÎļìË÷ --1.´ò¿ªÊý¾Ý¿â
use pubs
go
--2.´ò¿ªÈ«ÎÄË÷ÒýÖ§³Ö
--execute sp_fulltext_database 'enable'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 0 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ