In the outer select you refer to the 'customer' table, but in the inner selects you refer to 'dw.dbo.customer'.

Are you sure that these are the same table?

I you use a literal, SQL Server can use the index statistics to work out reasonably accurately how many rows will be affected by the delete clause. If this is...

I always add the linked server using an alias e.g "HEADOFFICE". Your 4 part query can use HEADOFFICE.databasename.dbo.tablename.

You can then map the alias to the real server using sp_setnetname, which can...

It doesn't have to be Perfmon itself that is running to cause the problem, it can be other forms of monitoring software that hook into the performance counters.

If it is...

The was a problem introduced in SQL2000 SP3, where the performance counters would not be available if perfmon was running at the time SQL2000 was started.

There are more details...

I raised the same issue with Microsoft some months ago, because restore time were highly variable for similarly sized log backup files.

The support people looked through the SQL Server...

You can find details about backup and restore files by joining various backup* and restore* tables in MSDB.

Does any of the input have one of your delimiter characters ";" as part of the data, possibly in the line before or after it appears to fail.

How is the COM object going to run the query?

If the COM object is going to run the query using something like ADO, then it's easy to change the ODBC query...

What you are setting is the CONNECTION timeout (how long to wait while making a connection to a SQL instance, not the QUERY timeout (how long to allow a query to...

The trigger will fire only once for each Insert statement, regardless of the number of records inserted by the statement (if will even fire once if 0 records are inserted).

The...

I have encountered something similar before, and spent some time trying to get to the bottom of the problem, using SQL Profiler, and watching the query run by the user,...

Temp tables (i.e # tables, not table variables) belong to a connection, and don't get deleted at the end of a stored proc. They remain until explicitly deleted, or the...

Just give the table variable an alias e.g.

declare @tblVar table ( id int)

insert into @tblVar select uid from tableA where some condition

select thisField from dbo.tableB inner join @tblVar x on...

Full database backups and transaction log backups work independently.

Your transaction log will continue to grow until you back it up using something like this:-

BACKUP LOG [ASWebDB] TO DISK =...