Unable to create an index on the AdventureWorks sample database
bug add tag
2 years ago Paul White

I tried to create a columnstore index on the db<>fiddle AdventureWorks sample database:

Error:

https://dbfiddle.uk/MKxX8NRD

It seems impossible to create any sort of index on the sample database.

Is this an oversight, or by design?

comments
transcript
a year
sqlHippo — Monday, 11th Dec 2023 00:58

I just spent way too long thinking I’d forgotten how to create indexes, but if Paul White can’t do it, I don’t feel so bad.

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.