Home
Articles
Tips
FAQ
SQL Server FAQs
Categories :
Performance Tuning
|
DBA
|
Developer
|
Errors
Cannot create plan guide ‘%.*ls’ because type ‘%.*ls’ provided is not allowed.
Cannot create plan guide ‘%.*ls’ because its name is invalid. Plan guide name cannot begin with a ‘#’ character.
Cannot create %S_MSG on view “%.*ls” because it references derived table “%.*ls” (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.
Cannot create plan guide ‘%.*ls’ because parameter @hints is incorrect. Use N’OPTION ( [ ,…n ] )’.
Cannot specify included columns for a clustered index.
Cannot create %S_MSG on view ‘%.*ls’ because it contains an INNER join that specifies a join hint. Consider removing the join hint.
Cannot create plan guide ‘%.*ls’ because the statement specified by @stmt and @module_or_batch, or by @plan_handle and @statement_start_offset, does not match any statement in the specified module or batch.
COMPUTE clause #%d, aggregate expression #%d is not in the select list.
Cannot create %S_MSG on view “%.*ls” because it uses a LEFT, RIGHT, or FULL OUTER join, and no OUTER joins are allowed in indexed views. Consider using an INNER join instead.
Cannot create plan guide ‘%.*ls’ because parameter @stmt has more than one statement.
Page 17 of 83
<
1
...
12
13
14
15
16
17
18
19
20
21
...
83
>
Popular
Latest
Tags
Setting up Transactional Replication in SQL Server 2008 R2.
November 30, -0001
Backing Up a SQL Server Database Directly Onto a Remote Server
November 30, -0001
Recovering a SQL Server Database from Suspect Mode
November 30, -0001
SQL Server T-SQL Tuning - NOT IN and NOT Exists
November 30, -0001
SQL Server T-SQL Tuning - Temp Tables, Table Variables and Union
November 30, -0001
TroubleShooting SQL Server Memory Consumption
April 11, 2018
Tuning your SQL Query – Generating a Proper Execution Plan.
April 10, 2018
Tips For Minimizing Deadlocks in SQL Server
April 8, 2018
Product Review: dbForge SQL Complete
April 7, 2018
SQL Server Hardware Optimization
March 27, 2018
Forum posts...
2008 R2
2012
Agent
AlwaysOn
Analysis Services
Backup
Clustering
Data Mining
deadlock
Denormalization
Disaster Recovery
Email
Entity Framework
Excel
Geo
high availability
Identity
Identity Column
index
Jobs
Log Shipping
mail
Monitoring
Oracle
Query
Query Plan
range
Replication
Reporting Services
Report Manager
Restore
Security
Spatial Data
SSIS
SSMS
SSRS
Stored Procedures
T-SQL
task
Temp Table
Transactional Replication
transactions
TSQL
Tuning
UNION