-- Set to SIMPLE mode ALTER DATABASE [DATABASE_NAME] SET RECOVERY SIMPLE; -- Shrink the db ); -- Set back to FULL (optional depending on backup method used) ALTER DATABASE [DATABASE_NAME] SET RECOVERY FULL; --SELECT * FROM sys.database_files 关于 DBCC
今天查看Job的History,发现Job 运行失败,错误信息是:“The transaction log for database 'xxxx' is full due to 'ACTIVE_TRANSACTION'.” 错误消息表明:数据库的事务日志文件空间耗尽,log 文件不能再存储新的transaction log. SQL Server将事务日志文件在逻辑上划分为多个VLF(Virtual Log Files),将这些VLF组成一个的环形结构,以VLF为重用单元.如果一个VLF 中存在
1.查询结果根据条件翻译成其他值 then '及格' else '不及格' end from S_STUDENT then '及格' else '不及格' end from S_STUDENT 2.sql 动态组合查询条件 where 1=1 效率 一般不会影响效率,会自动优化 当然也可替换: bool hasWhere = false; StringBuilder strSql = new StringBuilder(); strSql.Append("select * FROM dt_use