{"width":"100%","blog_url":"https://nekoandcake.hatenablog.com/","url":"https://nekoandcake.hatenablog.com/entry/2022/08/22/001840","provider_name":"Hatena Blog","categories":[],"title":"SQLskills SQL101: Why does my heap have a bunch of empty pages?","published":"2022-08-22 00:18:40","author_name":"tgk","description":"SQLskills SQL101: Why does my heap have a bunch of empty pages? - Paul S. Randal \u6982\u8981 SQL Server\u306e\u30d2\u30fc\u30d7\u304b\u3089\u3001\u5168\u884cdelete\u3055\u308c\u305f\u30da\u30fc\u30b8\u304c\u958b\u653e\u3055\u308c\u305a\u306b\u6b8b\u3063\u3066\u3044\u308b\u306e\u306f\u306a\u305c\u304b? \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306a\u3089\u5168\u884c\u524a\u9664\u3055\u308c\u305f\u30da\u30fc\u30b8\u306f\u958b\u653e\u3055\u308c\u308b\u306e\u306b\u3002 \u305d\u306e\u7406\u7531\u306f\u3001\u30d2\u30fc\u30d7\u304b\u3089\u7a7a\u306e\u30da\u30fc\u30b8\u3092\u958b\u653e\u3059\u308b\u306b\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u5168\u4f53\u306e\u6392\u4ed6\u30ed\u30c3\u30af\u304c\u5fc5\u8981\u3060\u304b\u3089\u3002 \u30ed\u30c3\u30af\u30a8\u30b9\u30ab\u30ec\u30fc\u30b7\u30e7\u30f3\u304c\u767a\u52d5\u3059\u308b\u3068\u304b\u3001TABLOCK\u30d2\u30f3\u30c8\u3092\u4f7f\u3046\u3068\u304b\u3001\u305d\u3046\u3044\u3046\u3053\u3068\u3092\u3057\u306a\u3044\u9650\u308a\u3001\u30c6\u30fc\u30d6\u30eb\u5168\u4f53\u304c\u6392\u4ed6\u30ed\u30c3\u30af\u3055\u308c\u308b\u3053\u3068\u306f\u306a\u3044\u306e\u3067\u3001\u5927\u91cfdelete\u5f8c\u306b\u30d2\u30fc\u30d7\u306b\u306f\u7a7a\u306e\u30da\u30fc\u30b8\u304c\u6b8b\u3063\u2026","author_url":"https://blog.hatena.ne.jp/tgk/","image_url":null,"version":"1.0","type":"rich","provider_url":"https://hatena.blog","height":"190","blog_title":"50\u6b73\u304b\u3089\u306e\u82f1\u8a9e","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fnekoandcake.hatenablog.com%2Fentry%2F2022%2F08%2F22%2F001840\" title=\"SQLskills SQL101: Why does my heap have a bunch of empty pages? - 50\u6b73\u304b\u3089\u306e\u82f1\u8a9e\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}