Deletes always take locks. That cannot be avoided.

Delete in batches if there are a lot of rows, that keeps the lock duration down and reduces the chance of a lock...

What you may be able to do is:

Rename the damaged DB

Restore a clean backup as the original name (this lets users work)

Carefully sync over the data missing from the restored...

Without log backups, no.

To do a single page restore, there must be log backups covering the time between...

Licence...

Restore from backup. That's not repairable.

I would hope, that for the heart of your accounting, you have log backups. Assuming that you do, restore the clean full backup WITH NORECOVERY,...

UncleBoris (8/26/2014)

---

So just to make it clear in my head. If I was going to use four files as a starting point based on the core count would it be...

ShorePatrol (8/26/2014)

---

Some that I'm not sure of:

TABLE SIZE FRAG%

table2 3312K 97% ...

Yes. That you can't partition across databases, and partitioning across filegroups will involve time consuming maintenance to move files to slower storage and that...

?????

You mean the row header, column and data size entries and offset bytes (which add up to 10 bytes in total)?

Very small tables often don't show change on rebuild, and it's pointless trying to rebuild them. Often not worthwhile rebuilding indexes under a few hundred pages.

The length from sp_help just shows the max byte size of the column, not the extra 2 bytes needed for a variable length column. Therefore the 60 bytes.

However,

Nvarchar(n) length is...

Couple things first...

The concat function was only added to SQL Server in 2012. Are you using SQL Server 2012?

The error you mention (int64) is not a SQL error. How are...

SQL doesn't automatically reduce the file sizes. Unless autoshrink is on (very bad idea) or manual shrinks are done, there's nothing that will reduce the size of the files.

Bear in...

You can't have more than one TempDB per instance.

If you mean files, 4 files is fine to start with. Add more and spread across volumes if you see allocation contention...

I will repeat what I said earlier

GilaMonster (8/25/2014)

---

This is one of the flaws at looking at just perfmon counters. Sure, work tables are 'high', but you haven't said if they're...