#DataBase

Oracle - Session, Users, Profiles Management

This article is about oracle daily maintaince, mainly contains dbausers, v$session and dbaprofiles the three parts.

SqlServer还原脚本

Drop - Delete - Truncate 的区别

truncate和delete只删除数据不删除表的结构(定义); drop将删除表的结构被依赖的constrain,trigger,index; 依赖于该表的存储过程/函数将保留,但是变为invalid状态. > TRUNCATE在各种表上无论是大的还是小的都非常快。如果有ROLLBACK命令DELETE将被撤销…

SqlServer log shrink (日志库收缩)

SqlServer的各种备份脚本

Full Database Backup Differential Database Backup differential backup base on complete backup, it's mean you should have a full backup before do this.