SQL Server FAQs

Categories : Performance Tuning | DBA | Developer | Errors

SQL Server Destination remote server error

Will Check Constraints Improve Database Performance?

The Excel Connection Manager is not supported in the 64-bit version of SSIS

Is there a difference between fill factor 0 and 100

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode

XQuery [query()]: Attribute may not appear outside of an element

Cannot find either column “%.ls” or the user-defined function or aggregate “%.ls”, or the name is ambiguous.

%sThe operator “%ls” cannot be applied to “%ls” and “%ls” operands.

%sOnly ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed in conditions and with logical operators, found ‘%ls’

XQuery: Unable to resolve sql:variable(‘%.*ls’). The variable must be declared as a scalar TSQL variable.