You're right. There actually is no way to set the file back to online without restoring it from a backup. ref: http://msdn.microsoft.com/en-us/library/bb522469.aspx

edit: Odd that it behaves like this. This is...

raistlinx (9/27/2010)

---

I prefer scripting everything I can. I want to know exactly what is happening, no surprises. You can easily port a script to another server if need be...

Try a DBCC DBREINDEX(tablename)

You have a file or filegroup offline.

You would need to run a command like this to get it back online..substituting your db name of course:

ALTER DATABASE [DB_NAME] MODIFY FILE (NAME...

I suppose you could run a job every minute or so that checks the log size on the database..something like this would check to see if the log is over...

Basically you just want to strip all non-numeric values, and add two hyphens.

There are a lot of variations on the function to remove non-numerics. The one I use is from:...

The point is, no matter what, there is a delay.

If it's continuously polling, it would pick it up within the next second anyway right? There is absolutely no physical way...

You can't update a record in two places at once at the same without at least a small delay (few seconds at most).

Is the app polling continuously? If it literally...

I'm pretty sure if you just set it to ignore data consistency errors, it will skip over deleting records that it can't find. There is no way to prevent blocking...

CURRENT_TIMESTAMP is the ANSI way to do it..so I guess if you're into such things, go with that.

I use getdate() because I've been using it for roughly a hundred years...

Do you have any views pointing to this table?

Check the dependencies through the SSMS gui and see what relies on it (right click -> view dependencies). You'll find the culprit...

Running the other instance on the other node of the cluster would also help free up some memory. If you have both set to use 5gb max on the same...

Check your execution plan to see where it's hanging. I assume all of those ID and Code fields that you're comparing on have indexes?

It would be a huge help if you posted the code you're using to insert data, and the table definition.

You need to have one table as your "master" table where...

Compare the estimated execution plans to ensure that all indexes are the same and enabled on both environments.

Check your MAXDOP on each server and make sure they're the same

Post the...