Ah, I never finished one of my thoughts in my previous post. Instead of having 10 sets of columns, your table should only have one Status, Time, and Comment...

OK, I think I've got where you are going with this and Barry is absolutely correct. What you are trying to do can, and should, be done in one...

Are you getting an error? What do you mean by ' can not seem to restore the DB to the new server'?

SQL Server creates a checkpoint in order to keep the recovery time to a minimum (as you've already read if you're getting into changing the recover interval). When a...

I'm going to have to agree with Grant here. I think that the ANSI joins are not only a better place to start, but they are easier to read....

Well, if you know for sure that table B only holds the first 8 (plus the period, so 9) of the ID, just change the JOIN predicate to reflect that....

SELECT...

Another comment here. If you are seeing the physical size of your data file decrease without running a shrink file, check your DB settings and make sure auto shrink...

As your indexes are being rebuilt, it may appear that your database is 'shrinking' in logical size but what is really happening behind the scenes is that SQL Server is...

David is right here. Your explanation of what is happening doesn't help us give you a place to start.

Can anybody let me know that a store procedure...

SELECT a.*

FROM TableA a

LEFT JOIN TableB b

ON a.keyid = b.keyid

WHERE b.keyid IS NULL

So you are loading this data into a table and you want to create a column on the table that holds this incremental value and you want to be able...

Is there a specific memory problem that you are having?

I suppose more background on why the OP wanted this would have been helpful. I agree that scanning the table to get the row count on very large tables...

The query optimizer is 'smart' enough to create the execution plan for a query based off of the actual data within a parameter. It can use the value of...

Yes, I'll agree 100%. Not performing periodic restores of your backups is not being diligent. If you don't test the restores, you can't rely on the quality of...