In an ALTER TABLE REBUILD or ALTER INDEX REBUILD statement, when a partition is specified in a DATA_COMPRESSION clause, PARTITION=ALL must be specified. The PARTITION=ALL clause is used to reinforce that all partitions of the table or index will be rebuilt, even if only a subset is specified in the DATA_COMPRESSION clause.
In a MERGE statement, a '%1!s!' clause with a search condition cannot appear after a '%2!s!' clause with no search condition. ...
In a MERGE statement, a variable cannot be set to a column and expression in the same assignment in the SET clause of an ...
In a MERGE statement, the source and target cannot have the same name or alias. Use different aliases for the source and ...
In a write-enabled dimension, end users and administrators can change, move, add and delete members. They can also update ...
In an ALTER TABLE REBUILD or ALTER INDEX REBUILD statement, when a partition is specified in a DATA_COMPRESSION clause, PARTITION=ALL ...
In both SQL Server 2005 and SQL Server 2008, the length of full-text catalog names is restricted to 120 characters, reduced ...
In Master Data Services Configuration Manager and in Master Data Manager, click the Help button to view product help that ...
In Microsoft SQL Server 2005 or later, the osql utility does not support the ED and ! commands. Remove references to the ...
In most cases, contains the text of the Transact-SQL statement. For rows of type PLAN_ROW, contains a description of the ...