Identity insert has to be set per table, and may only be on for one table at a time.

My favorite was a java-based messaging app that passed all string literals as N'... despite defining the table with varchar columns.

Net result, index scan of around a million rows to...

Implicit conversion issues?...

Thanks for mentioning that you were running on SQL 2000.

That particular query would be helped by an index on datep, however I thnk you have bigger problems than one query.

Is...

The query being run by the processes is in the st.text column, and it's almost the same as what fn_getSQLHandle would return.

I've used this query for years to track blocking...

Did you run my code? The query been run is...

Index definitions and execution plan please?

Can you post the query please, the table definition, the index definitions and the execution plan?

You get the exec plan by running the query in management studio with the Include...

The following form of code will usually deadlock if run enough times.

Connection 1:

WHILE (1=1)

BEGIN

BEGIN TRANSACTION

update Table1 SET SomeNumberField = SomeNumberField +1

WAITFOR DELAY '00:00:30

UPDATE...

LISETH_T (7/15/2008)

---

'Call a function to create the sqlDatareader

objDataReader = getReader("Select *...

For SQL 2005, try this one. Create a table somewhere then have a SQL agent job doing the insert at whatever interval you like

SELECT er.session_id, blocking_session_id, wait_type, wait_time, wait_resource, database_id,...

That error's the generic 'I can't connect' error. It could be because the server doesn't allow remote connections. It could be that the service is stopped, or there could be...

Not on its own. Deadlocks require two connections wanting locks that the other connection holds.

It is a really, really inefficient way to do...

If you want any suggestions on improving the query more, please post the query, along with...

Please start a separate thread for your questions.