{"action":"created","issue":{"url":"https://api.github.com/repos/MicrosoftDocs/sql-docs/issues/885","repository_url":"https://api.github.com/repos/MicrosoftDocs/sql-docs","labels_url":"https://api.github.com/repos/MicrosoftDocs/sql-docs/issues/885/labels{/name}","comments_url":"https://api.github.com/repos/MicrosoftDocs/sql-docs/issues/885/comments","events_url":"https://api.github.com/repos/MicrosoftDocs/sql-docs/issues/885/events","html_url":"https://github.com/MicrosoftDocs/sql-docs/pull/885","id":346099357,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA1MDQ0MDY4","number":885,"title":"Update columnstore-indexes-overview.md","user":{"login":"baleng","id":41946901,"node_id":"MDQ6VXNlcjQxOTQ2OTAx","avatar_url":"https://avatars1.githubusercontent.com/u/41946901?v=4","gravatar_id":"","url":"https://api.github.com/users/baleng","html_url":"https://github.com/baleng","followers_url":"https://api.github.com/users/baleng/followers","following_url":"https://api.github.com/users/baleng/following{/other_user}","gists_url":"https://api.github.com/users/baleng/gists{/gist_id}","starred_url":"https://api.github.com/users/baleng/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/baleng/subscriptions","organizations_url":"https://api.github.com/users/baleng/orgs","repos_url":"https://api.github.com/users/baleng/repos","events_url":"https://api.github.com/users/baleng/events{/privacy}","received_events_url":"https://api.github.com/users/baleng/received_events","type":"User","site_admin":false},"labels":[{"id":808196656,"node_id":"MDU6TGFiZWw4MDgxOTY2NTY=","url":"https://api.github.com/repos/MicrosoftDocs/sql-docs/labels/do-not-merge","name":"do-not-merge","color":"ee0701","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-31T09:08:11Z","updated_at":"2018-07-31T09:10:03Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/MicrosoftDocs/sql-docs/pulls/885","html_url":"https://github.com/MicrosoftDocs/sql-docs/pull/885","diff_url":"https://github.com/MicrosoftDocs/sql-docs/pull/885.diff","patch_url":"https://github.com/MicrosoftDocs/sql-docs/pull/885.patch"},"body":" there is an error in\r\nConvert a columnstore table to a rowstore. CREATE COLUMNSTORE INDEX (Transact-SQL) Usually this conversion isn't necessary, but there can be times when you need to convert. Examples show how to convert a columnstore to a heap or clustered index.\r\n\r\nto revert to a rowstore CI we need \"create clustered index on..WITH DROP_EXISTING=ON\" , to revert it to an heap simply drop CCI the index"},"comment":{"url":"https://api.github.com/repos/MicrosoftDocs/sql-docs/issues/comments/409151560","html_url":"https://github.com/MicrosoftDocs/sql-docs/pull/885#issuecomment-409151560","issue_url":"https://api.github.com/repos/MicrosoftDocs/sql-docs/issues/885","id":409151560,"node_id":"MDEyOklzc3VlQ29tbWVudDQwOTE1MTU2MA==","user":{"login":"PRMerger18","id":29423451,"node_id":"MDQ6VXNlcjI5NDIzNDUx","avatar_url":"https://avatars1.githubusercontent.com/u/29423451?v=4","gravatar_id":"","url":"https://api.github.com/users/PRMerger18","html_url":"https://github.com/PRMerger18","followers_url":"https://api.github.com/users/PRMerger18/followers","following_url":"https://api.github.com/users/PRMerger18/following{/other_user}","gists_url":"https://api.github.com/users/PRMerger18/gists{/gist_id}","starred_url":"https://api.github.com/users/PRMerger18/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PRMerger18/subscriptions","organizations_url":"https://api.github.com/users/PRMerger18/orgs","repos_url":"https://api.github.com/users/PRMerger18/repos","events_url":"https://api.github.com/users/PRMerger18/events{/privacy}","received_events_url":"https://api.github.com/users/PRMerger18/received_events","type":"User","site_admin":false},"created_at":"2018-07-31T09:10:03Z","updated_at":"2018-07-31T09:10:03Z","author_association":"CONTRIBUTOR","body":"@baleng : Thanks for your contribution! The author, @MikeRayMSFT, has been notified to review your proposed change."}}
{"actor":{"display_login":"PRMerger18"}}