You should see little difference if the collation is SQL_Latin1_General_CP1_CI_AS or Latin1_General_CI_AS, but both have instances where they are faster or slower than the other.

All none numeric columns in the stored procedure have the COLLATE database_default specified. I have'nt posed the code for the main stored procedure as it's around 500 lines and ran …

The product seemed to have severed the connection with SQL Server and the instance name. Even the SQL Server maintenance jobs can not find the instance name and fail to do steps on …

Waiting for Sql Server to allow connections. Operation attempted was: Verify Connection On Start.Unable to connect to server ' (local)'; SQLServerAgent cannot startSQLServer Error: 802, …

I can make a connection to the database I want successfully using the MS SQL ODBC driver, so I know the database is there and the SQL Server is responding with data.

As a yearly activity in out organisation, our Database team has taken a decision to change the database server. This will be SQL 2014 to SQL 2014 Change only, where the Old SQL servers …

Found few blogs pointing to installation of a new SCCM site on a standalone SQL server and then migrating the database to SQL Always on Availability Group. There are no specific documents …

" It turns out that not everything that appears in Management Studio’s “messages” tab directly comes from SQL Server, at least in literal text format. Setting NOCOUNT OFF doesn’t cause …

Hoy cuando intente conectarme al SQL no pude hacerlo, y al entrar al servidor del SQl me di cuenta el servicio del SQL estaba parado. Al tratar de iniciarlo me da un error: Windows no …

Answers 0 Sign in to vote assuming Fact table has companyid as foreign key you can do this ;With SalesComparison AS ( SELECT CompanyID, DATEADD (mm,DATEDIFF …