Partitioning the table seems like a very good idea.  For query performance have you looked at your explain plans to make sure things are running optimally.  I don't use it...

Here's a try at it not knowing how all of it works.  This is assumming that the sales.your_reference and sales.order_code are the same in some of the records and not...

As a clarification, I used int to varchar as an example.  But the same would happen with your dates august would be less than July if you convert dates to...

Truncate table command.  It is not a logged operation. Fast. No need to rescript entire database trying to get permissions etc done.

Tom

I will second Amit with the varchar comparison.  We just ran into a problem with some vendors code where it converted an int into a varchar and did comparison on...

For the lack of a better solution.  Have that company run the traces for you and send you the output files.  Worst case is, it's your code that is running. ...

It's the identity value.  Books online has a lot of information on it.

Tom

If I remember right the SQL Server Service Manager is not a cluster aware application.  You have to use the cluster manager to stop and restart the nodes on the cluster. ...

How did you get your databases back online.  A restore??  Jag might have stated it correctly, with the actual database file being fragmented.  Is the database set to autogrow.  How...

You can try setting implicit_transactions.  It is limited commitment control on the last statement run.  By default it is set to off.  If you set it on it will allow...

Unless your odbc was setup incorrectly.  To the machine ip instead of the virtual.

Tom

My view selects both.  It grabs the blocking spid with the or clause.

SELECT BLOCKED FROM MASTER..SYSPROCESSES WHERE BLOCKED<>0

The blocked column is the blocking spid.  Test it, it works like a...

Are you sure your node didn't failover.  That's what it sounds like to me.  It would explain why the odbc didn't work, different machine.  What steps did you take to ensure...

Here's a view I use.  I suppose you could turn it into a stored procedure.

create view vw_BLOCKERS

AS

SELECT * FROM MASTER..SYSPROCESSES WHERE BLOCKED <> 0 OR

SPID IN( SELECT BLOCKED FROM...

It could be that it is trying to use the default database that the user is setup with.  Try to use the new database and change the logins default database...