SQL SERVER常用的语句

最近遇到关于数据库维护方法的问题，提供常见的SQL SERVER 语句：

1. 查询8个月以前的数据：
   SELECT CREATETIME FROM WMS_BILL_PUTIN WHERE CREATETIME<DATEADD(MONTH,-8,GETDATE())
2. 保存日志，压缩事务日志
   USE [SHACH003] DECLARE @bakfile NVARCHAR(100) SET @bakfile='D:\logBAK\log_bak_SHACH003'+convert(nvarchar(8),getdate(),112)+'.log' BACKUP LOG [SHACH003] TO DISK= @bakfile WITH RETAINDAYS= 1,COMPRESSION DBCC SHRINKFILE(SHACH003_log,1024) Go
   3.查询数据库表占用空间
   SELECT object_name(id) tablename,8*reserved/1024 reserved, rtrim(8*dpages/1024)+'Mb' used,8*(reserved-dpages)/1024 unused, 8*dpages/1024-ROWS/1024*minlen/1024 free,ROWS from sysindexes WHERE indid=1 AND (object_name(id) IN(SELECT NAME FROM sys.tables)) ORDER BY reserved DESC