rani_rahbani (3/14/2014)

---

In the mean while I am doing this because i am asked to check every night who made insert/update/delete to a certain table and check the old data (deleted...

Because the database has never had a backup, it's behaving as though it's in simple recovery model. A DB in full recovery requires a full backup to initialise the log...

Table definitions, index definitions (both as create statements please), execution plan please, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Which queries in the procedure are the slowest?

Jeff Moden (3/13/2014)

---

You're right of course. The problem is that a lot of folks in the field think that the term "fully logged" for TRUNCATE means the same as...

Anyone for a game of 'guess what index is on which table'?

http://www.sqlservercentral.com/Forums/Topic1550657-391-1.aspx

Yes, all too often. Worse, in...

Any chance you could edit this?

You're really not helping yourself here. Obfuscate the table, change the column names, do the same...

MyDoggieJessie (3/13/2014)

---

Or, if it's a procedure being executed, you could add "WITH RECOMPILE" - so an entirely new execution plan is generated each time. I would only use this...

If you posted what was asked, maybe.

Table definitions please, index definitions and the xml plan would make things a hell of a lot...

Suspect status occurs when SQL encounters corrupt or damaged pages in the database during a rollback or crash recovery. It could be that some of the writes which SQL had...

No.

What if you had a primary key in your...

Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

MyDoggieJessie (3/12/2014)

---

If you want to see more detailed information on what caused the deadlock and which one was the deadlock victim, you can have them written to the error log...

Lowell's told you how to do it. If you want a script run once off to encrypt all procedures, write one up that does what he said.

Why are you going...