Where's the clustered index?

What are the primary keys?

Is that the only query that will be run on the tables?

What's running on Node A?

The error indicates that there's not enough memory to bring SQL online, which indicated that something else is running and is consuming the memory.

Have you limited the server's max memory? If not it would be a very good idea to do that. Set the max memory to around 29GB.

Also have a look at...

Can you post the execution plan please (saved as a .sqlplan file, zipped and attached to your post)

Also, you say it's slow. What do you mean by slow? (5 sec,...

Please don't cross post. It just wastes people's time and fragments replies.

No more replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic577330-146-1.aspx

Only the moderators can delete an entire thread. If you do create a new post on an existing issue, please post in the old thread and put the url of...

What does the SQL error log say?

What's you cluster config (how many nodes, how many are active?)

Please run the following and post the output here

DBCC CheckDB(<Database Name> ) WITH NO_INFOMSGS

Do you have any backup that doesn't have corruptions in it?

Have you considered partitioned tables? Depending on what you're inserting it may be possible for you to create a new table, insert into that and then switch that table with...

That means that the backup was striped across two backup files when it was created, and you only have one of those files. Most commonly this happens because when the...

The form of update that has a from clause is probably what you need.

update table1

set col2 = table2.col2

from table1 inner join table2 on table1.col1 = table2.col1

Stored procedures have no length limit. The max size of a variable on SQL 2000 is 8000 characters (varchar(8000).

You can build the query into multiple variables and exec them...

You could try using a text editor (a good one). Notepad++, ultraedit, etc

You can cycle the error log and SQL will start a new one, then you can read the...

Does the SQL service account have rights to that directory?

Is anything else using that file (an antivirus, a text editor, etc)

Only as part of a primary key. That's one of the...