ALTER INDEX ALL ON 表名
REBUILD WITH(ONLINE = ON)
–显示所有索引的碎片情况
Set NoCount ON
DBCC ShowCONTIG WITH ALL_INDEXES
go
–显示指定表索引的碎片情况
Set NoCount ON
DBCC ShowCONTIG( 表名)  WITH ALL_INDEXES
gohttp://wenku.baidu.com/view/a45a827d27284b73f2425071.html

exec sp_addlinkedserver   ’srv_lnk’, ”, ‘SQLOLEDB’,'服务器’ exec sp_addlinkedsrvlogin ’srv_lnk’,'false’,null,’用户’,'密码’ go select top  10 * from srv_lnk.库名.dbo.表名GO

set statistics profile onset statistics io onset statistics time ongo<这里写上你的语句...>goset statistics profile offset statistics io off

select * From master..sysprocesses where db_name(dbid)=’数据库名’

with Lock(spid, blocked, lastwaittype, cpu, status, cmd, nt_domain, dbName, sql_handle)   as  (select spid, blocked, lastwaittype, cpu, status, cmd, nt_domain, db_name(dbid), sql_handle from master..sysprocesses a )select dbName, a.spid, a.blocked, a.status, a.cmd, text from Lock a cross app

此博文仅好友可见