IO latch waits are an indication of disk activity. What are your sec/read and sec/write currently? What are the other wait types in the top 10. Just the page latches...

SELECT * FROM sys.partitions;

SELECT * FROM sys.dm_db_partiton_stats;

Personally, I'd keep it really simple. Are they starting a new projects? SQL Server 2014. If they're going to go and purchase brand new software, right now, they might as...

Are you hitting any other memory problems? What are the top waits? Just looking at PLE in isolation doesn't really say much about the system.

Yeah, probably rolling back those transactions. Glad the recovery on the other end wasn't as long or longer.

Good luck with the tickets. If you do get a more complete answer,...

That's awesome. Well done.

What Gail said.

I don't know how that started, but I've seen examples of that approach to naming files going back to when I started working with SQL Server 4.2... Sybase...

You could try looking at third party tools then. Redgate SQL Compare for the structures and SQL Data Compare for the data. You'll have to do manual mapping on the...

Break apart the transactions so that they're smaller. Only move chunks of the data in order to make the transaction size smaller. There are a number of different documents online...

Unless we're looking at some of kind of terminology mix up. Maybe you meant RID, or Row Identifier, which is a marker placed on rows in a heap table. Just...

You could use the ROW_NUMBER function and just add your starting value to output of the query. For example, if you want to start counting at 7, you add 6...

I would just script out the dependent objects, drop them and recreate them. That's going to be the safest way to ensure you get it right.

I'm pretty sure that's...

I've seen the output of ROW_NUMBER() referred to as row index (incorrectly), but other than that, I'm with Gail. I don't understand the question.

You really can't. You're telling the engine to do anything it has to in order to remove the corruption within the structures. That will result in, at minimum, the loss...

Maybe I misunderstood the question then. You're saying that they already have built an empty database, but this time it's got new structures, different table layout, etc., in addition to...