{"author_name":"koogucc11","type":"rich","categories":["SQL Server"],"description":"\u4eca\u56de\u3084\u308b\u3053\u3068\u3092\u8aac\u660e\u3057\u3066\u307f\u308b \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u7d71\u8a08\u60c5\u5831\u3092\u4e00\u89a7\u3067\u307f\u305f\u3044\u306e\u3067\u3001\u30af\u30a8\u30ea\u4f5c\u3063\u3066\u307f\u307e\u3059\u3002 \u4f7f\u7528\u3059\u308b\u74b0\u5883\u3092\u8aac\u660e\u3057\u3066\u307f\u308b My Lenovo with SQL Server 2014 \u3067\u3059\u3002 \u8a66\u3057\u3066\u307f\u308b \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u7d71\u8a08\u306e\u60c5\u5831\u3092\u53c2\u7167\u3059\u308b\u305f\u3081\u306b\u3001sys.stats \u304a\u3088\u3073 sys.dm_db_stats_properties \u3092\u4f7f\u7528\u3057\u3066\u30af\u30a8\u30ea\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u4e0b\u8a18\u306e\u30af\u30a8\u30ea\u3092 SQL Server Management Studio \u3067\u5b9f\u884c\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002 SELECT [\u30c6\u30fc\u30d6\u30eb\u540d] = t.name, [\u7d71\u8a08\u540d] = s.name, [\u7d71\u8a08\u306e\u81ea\u52d5\u4f5c\u6210] = s.auto_created, [\u2026","width":"100%","provider_name":"Hatena Blog","blog_title":"\u90fd\u5185\u3067\u50cd\u304fSE\u306e\u6280\u8853\u7684\u306a\u3072\u3068\u308a\u3054\u3068 / Technical soliloquy of System Engineer working in Tokyo","title":"\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u7d71\u8a08\u5185\u5bb9\u306b\u3064\u3044\u3066\u53c2\u7167\u3057\u3066\u307f\u308b","version":"1.0","height":"190","published":"2015-02-15 17:04:49","blog_url":"https://ryuchan.hatenablog.com/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fryuchan.hatenablog.com%2Fentry%2F2015%2F02%2F15%2F170449\" title=\"\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u7d71\u8a08\u5185\u5bb9\u306b\u3064\u3044\u3066\u53c2\u7167\u3057\u3066\u307f\u308b - \u90fd\u5185\u3067\u50cd\u304fSE\u306e\u6280\u8853\u7684\u306a\u3072\u3068\u308a\u3054\u3068 / Technical soliloquy of System Engineer working in Tokyo\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","url":"https://ryuchan.hatenablog.com/entry/2015/02/15/170449","author_url":"https://blog.hatena.ne.jp/koogucc11/","image_url":"http://cdn-ak.f.st-hatena.com/images/fotolife/k/koogucc11/20150215/20150215163715.png"}