{"author_name":"iad_otomamay","categories":["\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0"],"author_url":"https://blog.hatena.ne.jp/iad_otomamay/","title":"SQLServer2005\u3067\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u5168\u822c\u7684\u306b\u30ea\u30d3\u30eb\u30c9\u3059\u308b\u30af\u30a8\u30ea\u3092\u4f5c\u308b\u30af\u30a8\u30ea","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","type":"rich","published":"2008-02-05 00:00:01","height":"190","blog_title":"\u30ec\u30d9\u30eb\u30a8\u30f3\u30bf\u30fc\u5c71\u672c\u5927\u306e\u30d6\u30ed\u30b0","version":"1.0","width":"100%","description":"\u6628\u65e5\u306e\u30a8\u30f3\u30c8\u30ea(Index\u518d\u69cb\u7bc9)\u306e\u7d9a\u304d\u3068\u3057\u3066\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u30ac\u30d0\u30c3\u3068\u30ea\u30d3\u30eb\u30c9\u3057\u305f\u3044\u3068\u601d\u3063\u305f\u3068\u304d\u306b\u3001 \u826f\u3044\u65b9\u6cd5\u304c\u306a\u304b\u3063\u305f\u306e\u3067\u3001 \u300c\u30ea\u30d3\u30eb\u30c9\u3059\u308b\u305f\u3081\u306e\u30af\u30a8\u30ea\u300d\u3092\u4f5c\u308b\u305f\u3081\u306e\u30af\u30a8\u30ea\u3092\u8003\u3048\u305f\u3002 select 'ALTER INDEX ALL ON ' + object_name(dm.object_id) + ' REBUILD;' FROM sys.dm_db_index_physical_stats(DB_ID(), NULL,NULL, NULL, NULL) AS dm where avg_fragmentation_in_percent > 30 ALTER INDEX \u306eALL\u30ad\u30fc\u30ef\u30fc\u30c9\u3092\u2026","image_url":null,"url":"https://daiyamamoto.hatenablog.com/entry/20080205/p1","blog_url":"https://daiyamamoto.hatenablog.com/","html":""}