Sql-docs: COLUMN STORE INDEXES - Do not work with ROWLOCK hints

[ermagana]

Our organization recently attempted to make a performance optimization by leveraging a column store index. In the process of regression testing, we found that update and delete statements using the ROWLOCK hint were failing due to the Column Store Index. This was a surprise to us, as we have not been able to find any Microsoft documentation that would have led us to believe this is a constraint.

We'd request the constraint be added, so that future users of this great feature are aware before using the index.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 571bf244-1472-286b-d1a8-7db2e54f40a2
• Version Independent ID: bccbd120-47f3-78b7-0cd6-7d4198ea3604
• Content: Columnstore indexes: Overview - SQL Server
• Content Source: docs/relational-databases/indexes/columnstore-indexes-overview.md
• Product: sql
• Technology: table-view-index
• GitHub Login: @MikeRayMSFT
• Microsoft Alias: mikeray

[WilliamAntonRohm]

@ermagana -- Erik, thank you for your feedback.

@MikeRayMSFT -- Mike, please look into this issue.

[MikeRayMSFT]

Thank you @ermagana - I'm reviewing this with product partners & engineers.

[pmasl]

@ermagana you mean you hit error 651? That's by design. I'll add a note to docs.

@MikeRayMSFT see PR #16847

[ermagana]

Yes, thank you. Can you share a link to the updated docs?

[pmasl]

Yes, thank you. Can you share a link to the updated docs?

https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table