Another technique is to create a new table containing the rows you DON'T want to delete. You can create the new table using SELECT INTO (which is not logged), then delete the...

No issues that I know of.

SQL Server will not shrink the end of the log if it hasn't been backed up.

I can't test out an exact solution, as I don't have access to SQL Server at the moment, but you may be able to do what you want with something...

Enterprise Manager uses ODBC to run the query, and hence gets the default ODBC timeout (either 30 or 45 seconds, I can't remember which).

I couldn't find a way of changing...

Scan Count is the number of times SQL Server performs an action on the table e.g. If you have a query that Selects all orders and order details, you may...

It means that tempdb (or the disk it is on) has filled up.

If it is a primary key, then it will already be indexed.

Are there any delete triggers on the table?

If so, do they do anything that is taking the time?

Is retailmemberid indexed?

If not, the delete statement will have to search through the whole table looking for rows with the relevant retailmemberid.

Also, if any any inserts are done to your table, and the transaction is rolled back, the identities don't get re-used and will therefore cause gaps.

Mark

quote:

---

The @@rowcount will not have a value at that beginning stage of your trigger (ie. it IS set by statement that fired...

What account is SQL Server starting up as?

If it is the localsystem account, then it has no network access, regardless of permissions.

Have experienced exactly the same myself.

I'll bet that your function is a Scalar function, in which case, SQL Server seems to execute the function just like a stored procedure.......

Does your maintenance plan include a FULL database backup as well?.

A full backup will block the transaction log backup until it completes

Thanks Jonathan

The comparison tables in the link you supplied contain the 'definitive explanation' I was searching for.

I have had exactly the same performance problems with Scalar functions.

I suspect that if you run Profiler when running the function, you will see Profiler flooded with...