Code cleanup, not much to do with optimisation

That's more a style decision than anything else...

Simple recovery = log truncated on checkpoint, meaning it'll get overwritten when the log wraps around.

Hang on, if the database that the delete was run on was in simple recovery model, why did you tell me it was in full recovery?

When restoring a database, all...

saidapurs (4/24/2013)

---

Hi GilaMaster,

Sorry, i have updated allocation error for my privies comment and consistency purpose below command can use..

use master

go

alter database DBname set...

Yes.

Yes, rebuild the system DBs sets them all back to default and you will need to restore all three backups later, and the process to restore system databases is documented...

Can you not just take a log backup (or take the regular log backups), restore the lastest full to a new DB, restore all the logs and STOPAT just before...

pdanes (4/23/2013)

---

I assume then, that the reading of log records is a one-time event? That is, after doing the primary read, it catches up with the log records once, and...

Not many. It may give slightly faster inserts but there's enough downsides that it;s not usually a good idea. Unless you've tested and know that a heap is faster for...

Nope, completely useless.

The only thing that will fix is incorrect space used information. Run that on...

Did you read the article I referenced?

At this point, it may be easier to rebuild the system tables and then restore master, model and msdb.

What recovery model?

Have a read through this, see if it helps

https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

It may be easier to just rebuild the system databases then restore the backups after.

Eugene Davydov (4/23/2013)

---

I said that information: c# code calls in loop some simple procedures which perfoms only atomic insert/update/delete (by one row). There's no reason for escalation. More loop amount,...

Eugene Davydov (4/23/2013)

---

GilaMonster (4/23/2013)

---

I think a lot more information is needed to say anything useful. Oh, except for the fact that changing temp tables to table variables will do nothing...