SQL Server FAQs

Categories : Performance Tuning | DBA | Developer | Errors

Backup and restore operations are not allowed on database tempdb.

Cannot create %S_MSG on view “%.*ls” because it contains the TOP keyword. Consider removing TOP or not indexing the view.

Cannot create plan guide ‘%.*ls’ because object ‘@module_or_batch’ is encrypted. Consider tuning query using other techniques such as indexes and statistics.

Derived table ‘%.*ls’ is not updatable because a column of the derived table is derived or constant.

Cannot create %S_MSG on view “%.ls” because it uses aggregate “%.ls” with the DISTINCT keyword. Consider not indexing this view or eliminating DISTINCT. Consider use of a GROUP BY or COUNT_BIG(*) view to simulate DISTINCT on grouping columns.

Cannot create plan guide ‘%.ls’ because the module ‘%.ls’ does not exist or you do not have needed permission.

ALTER TABLE SWITCH statement failed because column ‘%.ls’ does not have the same collation in tables ‘%.ls’ and ‘%.*ls’.

Cannot create plan guide ‘%.*ls’ because parameter @hints is incorrect. Use N’OPTION ( [ ,...n ] )’.

Cannot create plan guide ‘%.*ls’ because @module_or_batch can not be compiled.

Cannot create plan guide ‘%.ls’ because value ‘%.ls’ provided for @module_or_batch is not legal two-part name. Use ‘schema_name.object_name’.

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |