SQL Server Performance
  • Home
  • Articles
  • Tips
  • FAQ

SQL Server FAQs


Categories : Performance Tuning | DBA | Developer | Errors

Cannot create the clustered index “%.*ls” on view “%.*ls” because the index key includes columns that are not in the GROUP BY clause. Consider eliminating columns that are not in the GROUP BY clause from the index key.

Cannot use TEXTIMAGE_ON when a table has no text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml or large CLR type columns.

CREATE DATABASE permission can only be granted in the master database.

The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB.

FILESTREAM_ON cannot be specified when a table has no FILESTREAM columns. Remove the FILESTREAM_ON clause from the statement, or add a FILESTREAM column to the table.

Cannot bulk load. The file “%ls” does not exist.

Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query.

Cannot create index or statistics ‘%.*ls’ on view ‘%.*ls’ because key column ‘%.*ls’ is imprecise, computed and not persisted. Consider removing reference to column in view index or statistics key or changing column to be precise.

ALTER TABLE failed because trigger ‘%.*ls’ on table ‘%.*ls’ does not exist.

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = %ld, current count = %ld.

  • Page 14 of 83
  • <
  • 1
  • ...
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • ...
  • 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
CONTACT SQL-SERVER-PERFORMANCE.COM

© 2018 SQL Server Performance. All Rights Reserved

4281 Express Lane, Suite L7710, Sarasota, FL 34238,