Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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²éѯ±íÖÐ×ֶβ»Öظ´

·½·¨Ò»£º
 select distinct name from tablename
·½·¨¶þ£º
select min(fid),name,sex from tablename group by name
×ܼƣº
select distinct name from tablename ´ò¿ªÖظ´¼Ç¼µÄµ¥¸ö×Ö¶Î
select * from tablename where fid in(Select min(fid) from tablename group by name)´ò¿ªÖظ´¼Ç¼µÄËùÓÐ×Ö¶ÎÖµ
select ......

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ÖеÄDDL,DML,DCLÓïÑÔ

     ¸Ð¾õ×Ô¼ºÊDZȽϱ¿µÄ£¬Ñ§Ï°¹ýSQLÓïÑÔ£¬µ«ÊÇÈ´·Ö²»Ì«Çå³þDDL¡¢DML¡¢DCLÓïÑÔ£¬ËùÒÔÄØ£¬½ñÌì¾Íºñ×ÅÁ³Æ¤ÎÊÁËÀÏʦ£¬ÏÖÔÚ¾Í×Ô¼ºÄ¿Ç°µÄÁ˽âÀ´×ܽáһϡ£
1¡¢DDL£¨DATA DEFINITION LANGUAGE£©Êý¾ÝÃèÊöÓïÑÔ
     DDLÓï¾ä²»»á²úÉú»¹Ô­Êý¾Ý£¬ËùÒÔɾ³ýµÄÊý¾ÝÒ²ÊÇÎÞ·¨»Ö¸´µÄ
CREATE - to ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ