Select count(*) from sys.tables

Please don't type in all caps. It's the online equivalent of shouting at someone.

From what I can see from the exec plan, you have no indexes at all on a...

Yup, that's fine.

Were you trying to grow the data file when those messages appeared?

No need to shout.

Since there's no way that the resultsets can overlap (there's a literal string that's different in each one), use UNION...

My guess is that you have autogrow enabled, one of more files grew and completely overloaded the IO system.

Either set smaller autogrow increments or (preferably) monitor the free space in...

Maybe I'm missing something, but the two queries unioned look the same.

Why do you need to union 24 results sets? There may be a better way.

What I'm trying to get at is whether the...

Have you asked them?

I can't tell you what the best backup type is. Only...

Means either the SQL service is restarting every night, or there's a job that's cycling the error log (sp_cycleerrorlog)

Check the beginning of the new error log, either you'll see SQL's...

Please post in the correct forum in the future. If...

The question you should ask yourself in this situation is the following.

"If the DB fails 10 hours after the last full/diff backup, is the loss of all changes made in...

There's very little difference, as far as the query optimiser's concerned, between a join condition and a where clause predicate.

2) Restore all log backups up to the point of the corruption. Use the same STOPAT and NORECOVERY options on each one.

3) Immediately perform a full backup of the database...

sqlguy (12/6/2008)

CAST(Table1.Col1 AS INT) = CAST(Table2.Col1...

No. Same problem as in the where. Join conditions must be conditions, not statements.

Just trying to parse that query shows that it won't...