What is the Avg Queue length on the log disk?

Regards

Piotr

I'd try to create server level DDL trigger and hook it up to ALTER DATABASE event. Then depending on the EVENTDATA and login executing the statement you might decide to...

I think I came across something alike in the past. It turned out that after GO, newline was encoded 'unix style' with one character only (0x0A) instead of the sequence...

It may be probably worth to mention that having the right table conditions in the WHERE clause made the left join effectively an INNER join, because the conditions filtered out...

SSIS Ole DB Destination also has checkbox to keep identity values from the source. In general, this component has all features available in bcp.

Regards

Piotr

Wow, that's a good one Andrew :blink:

Andy, have you tried to run the query with exactly same data for join on the SQL 2000 locally? Would it pick the index?...

Is there a possibility that an index on one of the tables was dropped?

Can you post the execution plan of the view?

Regards

Piotr

It is REMOTE join hint:

From BOL:

REMOTE

Specifies that the join operation is performed on the site of the right table. This is useful when the left table is a local...

Hi, I found my login has appended number. Tried to strip it off in profile editor, but it says that "Piotr Rodak" cannot be used because it's taken. So now...

I mean, from the design point of view: you have the same set of parameters and the same set of return values unless an exception occurs. If you have a...

Maybe the amount of data eventually changed the execution plan and you are getting table scans? Did you check fragmentation of indexes on the tables in the view? Maybe you...

I think you may come across various sorts of performance issues if you have more data. Sometimes it is better to create a dynamic SQL, fit it with parameters and...

Hi,

I think that you may need to think about the issue again. If you 'do nothing' in one case and return a rowset in the second, it means that your...

Ok, there was an old issue in SQL 2000 with undetected deadlocks, and though it was fixed, I saw 'hanging' (CXPacket locks) SELECT.. INTO query not longer than 2 weeks...

Would you mind showing the CREATE INDEX statement? As Gail says in this thread, CXPacket waits may stem from lagging parallel operations. Have you tried to set MAXDOP to lower...