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

¹ÜÀí SQL Server µÄÊÂÎñÈÕÖ¾

ÎÄÕÂÀ´Ô´£ºHttp://www.simple-talk.com
Ô­ÎĵØÖ·£ºhttp://www.simple-talk.com/sql/learn-sql-server/managing-transaction-logs-in-sql-server/
Ô­×÷ÕߣºRobert Sheldon
·­Ò룺Èý½úÒ»Ö¦»¨
ÒëÎÄÔ­µØÖ·£ºhttp://prj.souty.cn/Admin/Knowledges/ShowKnowledge.aspx?id=44dbde74-d2c5-41a5-a8e9-375ba7103025
ÔÚ SQL Server ʵÀýÖеÄÿһ¸öÊý¾Ý¿â£¬¶¼ÓÐÒ»¸öÈÕÖ¾£¬Ëü¼Ç¼×ÅÊý¾Ý¿âµÄËùÓиü¸Ä¡£ÓÉÓÚÕâ¸öÈÕÖ¾ÊǶÀÁ¢µÄ£¬ÔÚ¸ü¸Ä·¢Éú֮ǰ£¬ÊÂÎñÈÕÖ¾ÔÊÐíÔÚÓ²¼þ¹ÊÕÏ»òÓ¦ÓóÌÐò´íÎóʱ£¬¶ÔÊý¾Ý¿â»Ø¹ö»ò±£´æÊÂÎñ¡£ÓÉÓÚËüµÄ½ÇÉ«µÄÖØÒªÐÔ£¬ÊÂÎñÈÕÖ¾±»±£´æÔÚÒ»¸ö»ò¶à¸öÓëÊý¾Ý¿âÎļþ¶ÀÁ¢µÄÈÕÖ¾ÎļþÖУ»ÈÕÖ¾¼Ç¼ÊÇÔÚÄÚÈݵıä¸ü´Ó»º´æÐ´µ½Êý¾Ý¿âÎļþÖÐÒÔǰ·¢ÉúµÄ¡£
¶Ôÿ¸öÊý¾Ý¿â£¬ÊÂÎñÈÕÖ¾Ö§³ÖÒÔϲÙ×÷£º
 µ±·¢³öÒ»¸ö»Ø¹ö²Ù×÷»òÊý¾Ý¿âÒýÇæ¼ì²âµ½Ò»¸ö´íʱ£¬½øÐÐÊÂÎñ»Ø¹ö£»
 µ±·þÎñÆ÷ʧ¸Äʱ£¬½øÐÐÒ»¸öÍêÕûµÄÊÂÎñ»Ø¹ö¡£Õâ¸öÊÂÎñÔÚSQL Server ÖØÆôʱ½øÐлعö¡£
 µ±·þÎñÆ÷ʧ°Üʱ£¬½«Î´Íê³ÉµÄÊÂÎñдÈëµ½ÈÕÖ¾Îļþ£¬¶ø²»ÊÇÊý¾ÝÎļþÖС£µ± SQL Server ÖØÆôʱ£¬ÕâЩδÍê³ÉµÄÊÂÎñ½«»áдÈëÊý¾ÝÎļþ¡£
µ±·¢ÉúÓ²¼þ´íÎóʱ£¬¶Ô»Ö¸´µÄÊý¾Ý¿â¡¢Îļþ×é¡¢Îļþ»òÒ³Ïòǰ¹ö¶¯µ½Ê§°Üµã¡£ÊÂÎñ½«¹ö¶¯µ½×îºóÒ»¸öÍêÕû±¸·Ý»ò²îÒ챸µã¡£
¶ÔÊÂÎñ¸´ÖÆ¡¢Êý¾Ý¿â¾µÏñ¡¢ÈÕÖ¾´«ÊäÌṩ֧³Ö¡£
 
ÕâЩ¼Ç¼ÊÂÎñÈÕÖ¾µÄÎļþ£¬»áÓÉÊý¾Ý¿âÒýÇæ¸ù¾ÝÎïÀíÎļþµÄʵ¼ÊÇé¿ö£¬×Ô¶¯µØ·Ö½âΪ¶à¸öÐéÄâÎļþ¡£Êý¾Ý¿âÒýÇæÒ²»áÅжÏÔÚºÎʱ¶ÔÄÄЩÐéÄâÎļþ½øÐнضϡ£Äã¿ÉÒÔÖ¸¶¨ÎïÀíÈÕÖ¾ÎļþµÄ×îСֵºÍ×î´óÖµ£¬²¢¿ÉÒÔÅäÖÃÀ©Õ¹ÎļþʱµÄÔö³¤ÂÊ¡£ÁíÍ⣬Äã¿ÉÒÔÏòÈÕÖ¾Ôö¼ÓÎïÀíÎļþ¡¢É¾³ýÎļþ¡¢Ôö¼ÓÈÕÖ¾µÄ´óС»òÊÕËõÈÕÖ¾¡£
 
 
ÔÚÕâÆªÎÄÕÂÖУ¬ÎÒ½«½âÊÍÈçºÎÖ´ÐÐÕâЩÈÎÎñ£¬ÒÔ¿ªÊ¼¹ÜÀíÄãµÄÊÂÎñÈÕÖ¾£¬Í¬Ê±£¬ÎÒÌṩÁËһЩÀý×ÓÒÔÑÝʾÿһ¸öÈÎÎñÈçºÎ¹¤×÷¡£ÔÚÕâЩÀý×ÓÖУ¬ÎÒʹÓÃλÓÚ±¾µØ SQL Server 2008 ʵÀýÉ쵀 EmplyeeDb Êý¾Ý¿â£º
 
USE master;
 
IF EXISTS
(
  SELECT name from sys.databases
  WHERE name = 'EmployeeDB'
)
DROP DATABASE EmployeeDB;
 
CREATE DATABASE EmployeeDB
ON
(
  NAME = EmployeeDB_dat,
  FILENAME = 'C:\SqlData\EmployeeDb.mdf'
)
LOG ON
(
  NAME = EmployeeDB_log,
  FILENAME = 'C:\SqlData\EmployeeDb.ldf'
);
 
 
×¢Ò⣺ÎÒÊÇÔÚÒ»¸öÖ¸¶¨µÄλÖÃÉÏ´´½¨ÁËÒ»¸öÊý¾Ý¿âÎļþ£¬¶ø²»


Ïà¹ØÎĵµ£º

ÇÉÓö¯Ì¬ºêʵÏÖSQLÖд«µÝÖØ¸´²ÎÊý

ÈóǬ±¨±í¿ÉÒÔͨ¹ýSQL¼ìË÷ºÍ¸´ÔÓSQLÉú³ÉÊý¾Ý¼¯¡£µ±SQLÖÐÐèÒª´«Èë¶à¸ö²ÎÊýʱ£¬ÒªÔÚÉè¼ÆÆ÷ÖÐͨ¹ý ÅäÖÃ-²ÎÊý ¶¨ÒåÏàÓ¦µÄ²ÎÊý£¬È»ºóÔÙ°ÑSQLÖÐÐèÒª²ÎÊýµÄµØ·½Ìæ»»³É?£¬×îºó»¹ÒªÔÚSQL±à¼­Æ÷ÖÐÌí¼Ó¶ÔÓ¦?µÄ²ÎÊý¡£ÕâÑùµ±SQLÖÐÓжàÉÙ¸öÎʺţ¬ÎÒÃǾÍÐèÒªÌí¼Ó¶àÉÙ¸ö²ÎÊý¡£µ±SQLÖÐÓõ½µÄ²ÎÊý±È½ÏÉÙʱ£¬²Ù×÷ÆðÀ´»¹±È½Ï·½±ã¡£µ«µ±ÒµÎñ±È½Ï¸´ ......

Excel VBA ʵÏÖSQLÊý¾Ý¶ÁÈ¡K3ÈËÔ±ÐÅÏ¢

Private Sub CommandButton1_Click()
Worksheets("Sheet2").Select
    Cells.Select
     Selection.Delete Shift:=xlUp
     Range("A1").Select
'Çå³ýÔÚExcelÖеÄÊý¾Ý,È·±£µ¼ÈëÐÅÏ¢²»³öÏÖÓëÔ­ExcelÊý¾Ý½øÐеþ¼Ó
Dim cnnConnect As Object
Dim rstR ......

SQL ÓÐÌõ¼þµØÉ¸Ñ¡Öظ´Êý¾Ý

 --»ù´¡Á˽⣺
1) select distinct name from table --´ò¿ªÖظ´¼Ç¼µÄµ¥¸ö×Ö¶Î
2) select * from table where fid in(Select min(fid) from table group by name)--´ò¿ªÖظ´¼Ç¼µÄËùÓÐ×Ö¶ÎÖµ
3) select * from table where name in(select name from table group by name having count(name)=1)--´ò¿ªÖظ´ÈÎÒâ´ÎÊýµ ......

DBA³£ÓÃsql(¶þ)

 session״̬£º
STATUS VARCHAR2(8) Status of the session:
ACTIVE - Session currently executing SQL
INACTIVE - sql¼°ÆäsessionûÓÐÊÍ·Å»òÕý³£Í˳ö......
KILLED - Session marked to be killed
CACHED - Session temporarily cached for use by Oracle*XA
SNIPED - Session inactive, waiting on the clie ......

SQLÓïÑÔµÄCASEʹÓÃ×ܽá

 ×ª×Ôhttp://lavasoft.blog.51cto.com/62575/23373
SQLÓïÑÔµÄCASEÓï¾ä±¸Íü
 
¸ÅÊö£º
SQLÓï¾äÖеÄCASEÓï¾äÓë¸ß¼¶ÓïÑÔÖеÄswitchÓï¾ä£¬ÊDZê×¼SQLµÄÓï·¨£¬ÊÊÓÃÓëÒ»¸öÌõ¼þÅжÏÓжàÖÖÖµµÄÇé¿öÏ·ֱðÖ´Ðв»Í¬µÄ²Ù×÷¡£Áé»îÓ¦ÓÃCASEÓï¾ä¿ÉÒÔʹSQLÓï¾ä±äµÃ¼ò½àÒ×¶Á£¬ÏÂÃæÔÚDB2»·¾³ÏÂͨ¹ýÒ»¸ö¼òµ¥µÄ²éѯÀ´Õ¹Ê¾SQL CASEÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ