{"id":637,"date":"2018-04-19T20:21:40","date_gmt":"2018-04-19T12:21:40","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=637"},"modified":"2018-04-19T20:21:40","modified_gmt":"2018-04-19T12:21:40","slug":"sql%e6%9f%a5%e8%af%a2%e6%9f%90%e6%95%b0%e6%8d%ae%e5%ba%93%e5%90%84%e8%a1%a8%e5%8d%a0%e7%94%a8%e7%a3%81%e7%9b%98%e7%a9%ba%e9%97%b4%e5%92%8c%e6%94%b6%e7%bc%a9%e6%95%b0%e6%8d%ae%e5%ba%93mdf%e6%96%87","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=637","title":{"rendered":"SQL\u67e5\u8be2\u67d0\u6570\u636e\u5e93\u5404\u8868\u5360\u7528\u78c1\u76d8\u7a7a\u95f4\u548c\u6536\u7f29\u6570\u636e\u5e93MDF\u6587\u4ef6"},"content":{"rendered":"<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n--\u67e5\u6570\u636e\u5e93\u4e2d\u591a\u6570\u8868\u5360\u7528\u7684\u7a7a\u95f4\r\nCREATE TABLE TMP \r\n(name varchar(50),\r\nrows int,\r\nreserved varchar(50),\r\ndata varchar(50),\r\nindex_size varchar(50),\r\nunused varchar(50))\r\nGO\r\n\r\nINSERT INTO tmp (name,rows,reserved,data,index_size,unused) \r\nEXEC sp_msforeachTable @Command1=&quot;sp_spaceused '?'&quot;\r\nSELECT *,CONVERT(int, replace(data,' KB','')) as tt FROM tmp ORDER BY tt DESC \r\nDROP TABLE tmp\r\n\r\n\r\nGO\r\n\r\n\r\n--\u6536\u7f29\u53ef\u8ba9\u6570\u636e\u5e93\u5927\u5c0f\u51cf\u5c0f\u5f88\u591a\u7279\u522b\u662fMDF\u6587\u4ef6\r\nALTER DATABASE DBname \r\nSet  RECOVERY SIMPLE \r\nGo \r\n\r\nDBCC SHRINKDATABASE  (DBname) \r\nGo \r\n\r\nALTER DATABASE DBname \r\nSet  RECOVERY  FULL \r\nGo \r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8211;\u67e5\u6570\u636e\u5e93\u4e2d\u591a\u6570\u8868\u5360\u7528\u7684\u7a7a\u95f4 CREATE TABLE TMP (name v&#8230;<br \/><a class=\"read-more-button\" href=\"https:\/\/freesilo.com\/?p=637\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-637","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/637","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=637"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/637\/revisions"}],"predecessor-version":[{"id":638,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/637\/revisions\/638"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}