Why you should not shrink your data files
来源:互联网 发布:ubuntu 16.04 主题包 编辑:程序博客网 时间:2024/06/05 15:48
http://www.sqlskills.com/blogs/paul/why-you-should-not-shrink-your-data-files/
照着文中的实验做了一下(SQL Server 10.50.4276),还真是一样的结果。。。。不过DBCC SHRINKFILE并不会影响log file。因为shrink log file仅仅是将标记为turncate的虚拟log文件释放给操作系统,不涉及移动数据。
0 0
- Why you should not shrink your data files
- Why you should take your 20s seriously
- Why you should take your 20s seriously
- Why you should use talloc for your next project
- Why you should start by learning data visualization and manipulation
- Why you should learn R first for data science
- Do what you love: Why you are not your job
- Why Should You Build Your Own Business Website For Marketing Your Business?
- Why Should I Hire You
- Kill -9 Why You Should Not Use It Unless Absolutely Necessary
- Why you should never call Suspend/TerminateThread
- Why you should use Umbrello UML Modeller
- Why you should use Test::Class
- Why you should always use PHP interfaces
- Log4j---Why You Should Use “isDebugEnabled” ?
- Why you should speak at technical conferences
- 51 You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the
- Why Software Should Not Have Owners
- JDBC连接池的比较:DBCP、C3P0、Proxool 、 BoneCP
- 《程序员的自我修养》读后感
- Java中把数组转为一个List
- Android 有效的展示大图片(四)
- svn中如何列出所有branches下的分支?
- Why you should not shrink your data files
- Linux 库函数源码分析(1) --- memmove
- kettle 集群、分区
- hdu-1398-Square Coins
- Javascript 中的 && 和 ||
- Eclipse中配置tomcat
- solr schema.xml
- UVA - 156 Ananagrams
- Expression Blend for Silverlight 超丑数据加载效果