Edward:

Have you checked if you have 'Auto Close' turned on in all your databases? If you open up 'Databases' in SQL Enterprise Manager it will take alot of time to...

Oh, I didn't know this feature!

Thanx,

Hanslindgren

Hello!

Just to mention... Of course you can use "normal" temporary tables in DTS.

Just create it and use it as normal. The tricky part is that it will not exist during...

Has anyone come up with a good solution if you are using an OUTER JOIN instead of an INNER JOIN?

//Hanslindgren

Could it be that your batch size is very large and it is trying to commit the batch? I.e the 'first' million lines are fast when it might be dumping...

Try checking/optimizing your indexes, maybe your DELETE scanned your table?

The suggestion made by Justin will probably only e efficient if your amout of data-to-be-deleted is very large compared to total...

I also believes that it happends when you get some files from UNiX, since the CrLfs are often stored differently. Try UltraEdit and do a conversion and see if that also solved...

Shendricks>

I can confirm this problem and I do not know why. It seems that there is a problem in the optimizer that 'guesses' the value of the input parameters and...

2 cents:

I think 'the guy' on the course did it with VB Script, ADO Recordset, foreaching all records, foreaching all fields and comparing the values.

Regards, Hanslindgren!

What about indexing? Did you remember to move your indexes as you moved to the New server?

Regards, Hanslindgren

Thanx but I meant Application Locks. Not if there is a Block from an Application Lock.

Ex:

DECLARE @result INT

DECLARE @myspid INT ; SET @myspid = (SELECT @@SPID)

EXEC @result...

Hello!

Just for pointing out: There is an undocumented SP by MS that is called sp_MSforeachdb. It is very similar to a) but if you want, read more at:

http://www.mssqlcity.com/FAQ/Devel/sp_msforeachdb.htm

Regards, Hans!

Hello!

Just a thought. Didn't you Quote from BOL: 1 Open objects include all tables

Wouldn't that indicate objects that are Open. I.e not just Tables that are existing but Tables that...

Take a look at Lumigent Schema Alert.

Desc:

Lumigent® Schema AlertTM is a utility for real-time detection of database changes. This utility tracks all activity of type CREATE TABLE, DROP TABLE, ALTER...

Hmm, we are not very clear on this subject. We are all saying things about Terminal Services but in the end it seems like it is a question of interpretation...