{"action":"closed","number":523,"pull_request":{"url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/pulls/523","id":89427166,"html_url":"https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/pull/523","diff_url":"https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/pull/523.diff","patch_url":"https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/pull/523.patch","issue_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/523","number":523,"state":"closed","locked":false,"title":"Stop double populating compression information temp tables","user":{"login":"BlitzErik","id":11590415,"avatar_url":"https://avatars.githubusercontent.com/u/11590415?v=3","gravatar_id":"","url":"https://api.github.com/users/BlitzErik","html_url":"https://github.com/BlitzErik","followers_url":"https://api.github.com/users/BlitzErik/followers","following_url":"https://api.github.com/users/BlitzErik/following{/other_user}","gists_url":"https://api.github.com/users/BlitzErik/gists{/gist_id}","starred_url":"https://api.github.com/users/BlitzErik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BlitzErik/subscriptions","organizations_url":"https://api.github.com/users/BlitzErik/orgs","repos_url":"https://api.github.com/users/BlitzErik/repos","events_url":"https://api.github.com/users/BlitzErik/events{/privacy}","received_events_url":"https://api.github.com/users/BlitzErik/received_events","type":"User","site_admin":false},"body":"This was some code that should have been pulled, but doesn't break\r\nanything because it's so old, it was before I started paying attention\r\nto temp table name formatting.","created_at":"2016-10-14T17:56:18Z","updated_at":"2016-10-15T21:35:56Z","closed_at":"2016-10-15T21:35:56Z","merged_at":"2016-10-15T21:35:56Z","merge_commit_sha":"f877c27fdb6b40dd180bfc7def9a8b5c1d9fac79","assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/milestones/6","html_url":"https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/milestones/2016-11","labels_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/milestones/6/labels","id":2072126,"number":6,"title":"2016-11","description":null,"creator":{"login":"BrentOzar","id":245462,"avatar_url":"https://avatars.githubusercontent.com/u/245462?v=3","gravatar_id":"","url":"https://api.github.com/users/BrentOzar","html_url":"https://github.com/BrentOzar","followers_url":"https://api.github.com/users/BrentOzar/followers","following_url":"https://api.github.com/users/BrentOzar/following{/other_user}","gists_url":"https://api.github.com/users/BrentOzar/gists{/gist_id}","starred_url":"https://api.github.com/users/BrentOzar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BrentOzar/subscriptions","organizations_url":"https://api.github.com/users/BrentOzar/orgs","repos_url":"https://api.github.com/users/BrentOzar/repos","events_url":"https://api.github.com/users/BrentOzar/events{/privacy}","received_events_url":"https://api.github.com/users/BrentOzar/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":1,"state":"open","created_at":"2016-10-15T21:35:53Z","updated_at":"2016-10-15T21:35:56Z","due_on":null,"closed_at":null},"commits_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/pulls/523/commits","review_comments_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/pulls/523/comments","review_comment_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/pulls/comments{/number}","comments_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/523/comments","statuses_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/statuses/d1cfeb6e2d360122ab72449ca808579494fa67cc","head":{"label":"BrentOzarULTD:BlitzIndex_522","ref":"BlitzIndex_522","sha":"d1cfeb6e2d360122ab72449ca808579494fa67cc","user":{"login":"BrentOzarULTD","id":2688558,"avatar_url":"https://avatars.githubusercontent.com/u/2688558?v=3","gravatar_id":"","url":"https://api.github.com/users/BrentOzarULTD","html_url":"https://github.com/BrentOzarULTD","followers_url":"https://api.github.com/users/BrentOzarULTD/followers","following_url":"https://api.github.com/users/BrentOzarULTD/following{/other_user}","gists_url":"https://api.github.com/users/BrentOzarULTD/gists{/gist_id}","starred_url":"https://api.github.com/users/BrentOzarULTD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BrentOzarULTD/subscriptions","organizations_url":"https://api.github.com/users/BrentOzarULTD/orgs","repos_url":"https://api.github.com/users/BrentOzarULTD/repos","events_url":"https://api.github.com/users/BrentOzarULTD/events{/privacy}","received_events_url":"https://api.github.com/users/BrentOzarULTD/received_events","type":"Organization","site_admin":false},"repo":{"id":20408831,"name":"SQL-Server-First-Responder-Kit","full_name":"BrentOzarULTD/SQL-Server-First-Responder-Kit","owner":{"login":"BrentOzarULTD","id":2688558,"avatar_url":"https://avatars.githubusercontent.com/u/2688558?v=3","gravatar_id":"","url":"https://api.github.com/users/BrentOzarULTD","html_url":"https://github.com/BrentOzarULTD","followers_url":"https://api.github.com/users/BrentOzarULTD/followers","following_url":"https://api.github.com/users/BrentOzarULTD/following{/other_user}","gists_url":"https://api.github.com/users/BrentOzarULTD/gists{/gist_id}","starred_url":"https://api.github.com/users/BrentOzarULTD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BrentOzarULTD/subscriptions","organizations_url":"https://api.github.com/users/BrentOzarULTD/orgs","repos_url":"https://api.github.com/users/BrentOzarULTD/repos","events_url":"https://api.github.com/users/BrentOzarULTD/events{/privacy}","received_events_url":"https://api.github.com/users/BrentOzarULTD/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit","description":"sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.","fork":false,"url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit","forks_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/forks","keys_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/keys{/key_id}","collaborators_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/teams","hooks_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/hooks","issue_events_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/events{/number}","events_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/events","assignees_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/assignees{/user}","branches_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/branches{/branch}","tags_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/tags","blobs_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/git/refs{/sha}","trees_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/git/trees{/sha}","statuses_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/statuses/{sha}","languages_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/languages","stargazers_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/stargazers","contributors_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/contributors","subscribers_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/subscribers","subscription_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/subscription","commits_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/commits{/sha}","git_commits_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/git/commits{/sha}","comments_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/comments{/number}","issue_comment_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/comments{/number}","contents_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/contents/{+path}","compare_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/compare/{base}...{head}","merges_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/merges","archive_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/downloads","issues_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues{/number}","pulls_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/pulls{/number}","milestones_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/milestones{/number}","notifications_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/labels{/name}","releases_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/releases{/id}","deployments_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/deployments","created_at":"2014-06-02T15:26:41Z","updated_at":"2016-10-15T16:34:31Z","pushed_at":"2016-10-15T21:35:56Z","git_url":"git://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit.git","ssh_url":"git@github.com:BrentOzarULTD/SQL-Server-First-Responder-Kit.git","clone_url":"https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit.git","svn_url":"https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit","homepage":"http://FirstResponderKit.org","size":3300,"stargazers_count":381,"watchers_count":381,"language":"PLSQL","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":81,"mirror_url":null,"open_issues_count":83,"forks":81,"open_issues":83,"watchers":381,"default_branch":"dev"}},"base":{"label":"BrentOzarULTD:dev","ref":"dev","sha":"e501bdd11ed531ae4e25b2546143dfe963f1bdbb","user":{"login":"BrentOzarULTD","id":2688558,"avatar_url":"https://avatars.githubusercontent.com/u/2688558?v=3","gravatar_id":"","url":"https://api.github.com/users/BrentOzarULTD","html_url":"https://github.com/BrentOzarULTD","followers_url":"https://api.github.com/users/BrentOzarULTD/followers","following_url":"https://api.github.com/users/BrentOzarULTD/following{/other_user}","gists_url":"https://api.github.com/users/BrentOzarULTD/gists{/gist_id}","starred_url":"https://api.github.com/users/BrentOzarULTD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BrentOzarULTD/subscriptions","organizations_url":"https://api.github.com/users/BrentOzarULTD/orgs","repos_url":"https://api.github.com/users/BrentOzarULTD/repos","events_url":"https://api.github.com/users/BrentOzarULTD/events{/privacy}","received_events_url":"https://api.github.com/users/BrentOzarULTD/received_events","type":"Organization","site_admin":false},"repo":{"id":20408831,"name":"SQL-Server-First-Responder-Kit","full_name":"BrentOzarULTD/SQL-Server-First-Responder-Kit","owner":{"login":"BrentOzarULTD","id":2688558,"avatar_url":"https://avatars.githubusercontent.com/u/2688558?v=3","gravatar_id":"","url":"https://api.github.com/users/BrentOzarULTD","html_url":"https://github.com/BrentOzarULTD","followers_url":"https://api.github.com/users/BrentOzarULTD/followers","following_url":"https://api.github.com/users/BrentOzarULTD/following{/other_user}","gists_url":"https://api.github.com/users/BrentOzarULTD/gists{/gist_id}","starred_url":"https://api.github.com/users/BrentOzarULTD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BrentOzarULTD/subscriptions","organizations_url":"https://api.github.com/users/BrentOzarULTD/orgs","repos_url":"https://api.github.com/users/BrentOzarULTD/repos","events_url":"https://api.github.com/users/BrentOzarULTD/events{/privacy}","received_events_url":"https://api.github.com/users/BrentOzarULTD/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit","description":"sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.","fork":false,"url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit","forks_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/forks","keys_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/keys{/key_id}","collaborators_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/teams","hooks_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/hooks","issue_events_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/events{/number}","events_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/events","assignees_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/assignees{/user}","branches_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/branches{/branch}","tags_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/tags","blobs_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/git/refs{/sha}","trees_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/git/trees{/sha}","statuses_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/statuses/{sha}","languages_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/languages","stargazers_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/stargazers","contributors_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/contributors","subscribers_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/subscribers","subscription_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/subscription","commits_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/commits{/sha}","git_commits_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/git/commits{/sha}","comments_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/comments{/number}","issue_comment_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/comments{/number}","contents_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/contents/{+path}","compare_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/compare/{base}...{head}","merges_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/merges","archive_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/downloads","issues_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues{/number}","pulls_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/pulls{/number}","milestones_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/milestones{/number}","notifications_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/labels{/name}","releases_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/releases{/id}","deployments_url":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/deployments","created_at":"2014-06-02T15:26:41Z","updated_at":"2016-10-15T16:34:31Z","pushed_at":"2016-10-15T21:35:56Z","git_url":"git://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit.git","ssh_url":"git@github.com:BrentOzarULTD/SQL-Server-First-Responder-Kit.git","clone_url":"https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit.git","svn_url":"https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit","homepage":"http://FirstResponderKit.org","size":3300,"stargazers_count":381,"watchers_count":381,"language":"PLSQL","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":81,"mirror_url":null,"open_issues_count":83,"forks":81,"open_issues":83,"watchers":381,"default_branch":"dev"}},"_links":{"self":{"href":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/pulls/523"},"html":{"href":"https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/pull/523"},"issue":{"href":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/523"},"comments":{"href":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/523/comments"},"review_comments":{"href":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/pulls/523/comments"},"review_comment":{"href":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/pulls/523/commits"},"statuses":{"href":"https://api.github.com/repos/BrentOzarULTD/SQL-Server-First-Responder-Kit/statuses/d1cfeb6e2d360122ab72449ca808579494fa67cc"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"BrentOzar","id":245462,"avatar_url":"https://avatars.githubusercontent.com/u/245462?v=3","gravatar_id":"","url":"https://api.github.com/users/BrentOzar","html_url":"https://github.com/BrentOzar","followers_url":"https://api.github.com/users/BrentOzar/followers","following_url":"https://api.github.com/users/BrentOzar/following{/other_user}","gists_url":"https://api.github.com/users/BrentOzar/gists{/gist_id}","starred_url":"https://api.github.com/users/BrentOzar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BrentOzar/subscriptions","organizations_url":"https://api.github.com/users/BrentOzar/orgs","repos_url":"https://api.github.com/users/BrentOzar/repos","events_url":"https://api.github.com/users/BrentOzar/events{/privacy}","received_events_url":"https://api.github.com/users/BrentOzar/received_events","type":"User","site_admin":false},"comments":0,"review_comments":0,"commits":1,"additions":6,"deletions":40,"changed_files":1}}
{"actor":{"display_login":"BrentOzar"}}