MS SQL SERVER º£Á¿Êý¾ÝµÄ²éѯÓÅ»¯¼°·ÖÒ³Ëã·¨
̽ÌÖÈçºÎÔÚÓÐ×Å1000ÍòÌõÊý¾ÝµÄMS SQL SERVERÊý¾Ý¿âÖÐʵÏÖ¿ìËÙµÄÊý¾ÝÌáÈ¡ºÍÊý¾Ý·ÖÒ³¡£ÒÔÏ´úÂë˵Ã÷ÁËÎÒÃÇʵÀýÖÐÊý¾Ý¿âµÄ“ºìÍ·Îļþ”Ò»±íµÄ²¿·ÖÊý¾Ý½á¹¹£º
CREATE TABLE [dbo].[TGongwen] ( --TGongwenÊǺìÍ·Îļþ±íÃû
[Gid] [int] IDENTITY (1, 1) NOT NULL ,
--±¾±íµÄidºÅ£¬Ò²ÊÇÖ÷¼ü
[title] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
--ºìÍ·ÎļþµÄ±êÌâ
[fariqi] [datetime] NULL ,
--·¢²¼ÈÕÆÚ
[neibuYonghu] [varchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
--·¢²¼Óû§
[reader] [varchar] (900) COLLATE Chinese_PRC_CI_AS NULL ,
--ÐèÒªä¯ÀÀµÄÓû§¡£Ã¿¸öÓû§ÖмäÓ÷ָô·û“,”·Ö¿ª
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
¡¡¡¡ÏÂÃæ£¬ÎÒÃÇÀ´ÍùÊý¾Ý¿âÖÐÌí¼Ó1000ÍòÌõÊý¾Ý£º
declare @i int
set @i=1
while @i<=250000
begin
insert into Tgongwen(fariqi,neibuyonghu,reader,title) values('2004-2-5','ͨÐÅ¿Æ','ͨÐÅ¿Æ,°ì¹«ÊÒ,Íõ¾Ö³¤,Áõ¾Ö³¤,Õžֳ¤,admin,ÐÌÕìÖ§¶Ó,ÌØÇÚÖ§¶Ó,½»Ñ²¾¯Ö§¶Ó,¾ÕìÖ§¶Ó,»§Õþ¿Æ,Öΰ²Ö§¶Ó,ÍâÊ¿Æ','ÕâÊÇ×îÏȵÄ25ÍòÌõ¼Ç¼')
set @i=@i+1
end
GO
declare @i int
set @i=1
while @i<=250000
begin
insert into Tgongwen(fariqi,neibuyonghu,reader,title) values('2004-9-16','°ì¹«ÊÒ','°ì¹«ÊÒ,ͨÐÅ¿Æ,Íõ¾Ö³¤,Áõ¾Ö³¤,Õžֳ¤,admin,ÐÌÕìÖ§¶Ó,ÌØÇÚÖ§¶Ó,½»Ñ²¾¯Ö§¶Ó,¾ÕìÖ§¶Ó,»§Õþ¿Æ,ÍâÊ¿Æ','ÕâÊÇÖмäµÄ25ÍòÌõ¼Ç¼')
set @i=@i+1
end
GO
declare @h int
set @h=1
while @h<=100
begin
declare @i int
set @i=2002
while @i<=2003
begin
declare @j int
set @j=0
 
Ïà¹ØÎĵµ£º
×ªÔØ£ºhttp://blog.csdn.net/cnming/archive/2009/03/11/3979290.aspx
ÔÚ²éѯ·ÖÎöÆ÷ÖÐ˳ÐòÖ´ÐÐÒÔÏÂÈý²½£¬ÆäÖÐ databasename ΪÄãµÄÊý¾Ý¿âÎļþÃû
1.Çå¿ÕÈÕÖ¾£ºDUMP TRANSACTION databasename WITH NO_LOG
2.½Ø¶ÏÊÂÎñÈÕÖ¾£ºBACKUP ......
master..xp_dirtree 'D:\',1,1 µÚÒ»¸ö1ÊÇÉî¶È£¬µÚ¶þ¸ö1ÊÇÎļþ
1. Ö´ÐÐ master..xp_dirtree 'c:\',1,1,ÕâÑù¿ÉÒÔ»ñÈ¡c:\ϵÄËùÓÐÎļþºÍÎļþ¼Ð,²»°üÀ¨×ÓÎļþ¼Ð¼°Îļþ
2. ÏÔʾÔÚtreeviewÖÐ,ÓñêÖ ......
1.²é¿´Êý¾Ý¿âµÄ°æ±¾
select @@version
2.²é¿´Êý¾Ý¿âËùÔÚ»úÆ÷²Ù×÷ϵͳ²ÎÊý
exec master..xp_msver
3.²é¿´Êý¾Ý¿âÆô¶¯µÄ²ÎÊý
sp_configure
4.²é¿´Êý¾Ý¿âÆô¶¯Ê±¼ä
select convert(varchar(30),login_time,120) from master..sysprocesses where spid=1
²é¿´Êý¾Ý¿â·þÎñÆ÷ÃûºÍʵÀýÃû
print ''Server Name...... ......
---- ÈËÃÇÔÚʹÓÃSQLʱÍùÍù»áÏÝÈëÒ»¸öÎóÇø£¬¼´Ì«¹Ø×¢ÓÚËùµÃµÄ½á¹ûÊÇ·ñÕýÈ·£¬¶øºöÂÔ
Á˲»Í¬µÄʵÏÖ·½·¨Ö®¼ä¿ÉÄÜ´æÔÚµÄÐÔÄܲîÒ죬ÕâÖÖÐÔÄܲîÒìÔÚ´óÐ͵ĻòÊǸ´ÔÓµÄÊý¾Ý¿â
»·¾³ÖУ¨ÈçÁª»úÊÂÎñ´¦ÀíOLTP»ò¾ö²ßÖ§³ÖϵͳDSS£©ÖбíÏÖµÃÓÈΪÃ÷ÏÔ¡£±ÊÕßÔÚ¹¤×÷ʵ¼ù
Öз¢ ......