[code="java"]SQL2008 的收缩日志 由于SQL2008对文件和日志管理进行了优化，所以以下语句在SQL2005中可以运行但在SQL2008中已经被取消：(SQL2005)Backup Log DNName with no_loggodump transaction DNName with no_loggoUSE DNName DBCC SHRINK...

[code="sql"]--EXEC sp_addlinkedserver -- @server = 'PSHGQ'--GO--select * from sys.servers--EXEC sp_dropserver 'PSHGQ'--EXEC sp_addserver 'SUGON', local--select @@servername--select s...

[code="java"]select t.name,i.name,s.avg_fragmentation_in_percent from sys.tables tjoin sys.indexes i on i.object_id=t.object_idjoin sys.dm_db_index_physical_stats(db_id(),object_id('t2'),null,nu...