Activity overview
Latest activity by PeterVandivier_vgg
Annnnnd... I've only just now learned that specifying compression at the table statement scope is invalid when specifying compression on an inline scoped PK statement. Notably however, neither SQL Prompt Formatter nor the SSMS `parse` function throw an error when evaluating the below statement. ```sql drop table if exists dbo.#foo; create table #foo ( a int not null primary key clustered with (data_compression = page) ) with (data_compression = page); ``` ...although the following error is thrown when attempting to execute the batch: Msg 7711, Level 16, State 3, Line 21 The DATA_COMPRESSION option was specified more than once for the table, or for at least one of its partitions if the table is partitioned. Msg 1750, Level 16, State 0, Line 21 Could not create constraint or index. See previous errors. / comments
Annnnnd... I've only just now learned that specifying compression at the table statement scope is invalid when specifying compression on an inline scoped PK statement. Notably however, neither SQL ...
SQL Prompt Formatter error - Inline Index with included column
The following valid SQL pops an (incorrect) parsing error when attempting to format the code block with ctrl+k+y```sqldrop table if exists #foo;create table #foo ( a int, b int, index idx_...