Adam Angelini (6/17/2010)

---

The default trace keeps 5 files, and they roll over at about 20MB. This means the time frame that is available varies according to how many transactions you...

Thank you Grant for your excellent suggestions.

Excellent work Adam. This is really useful article for any DBA.

Thank you. I just wanted to confirm that 🙂

homebrew01 (5/18/2010)

---

Something like this will give you a history of backups. You can specify the database & time period if you want.

SELECT sysdb.name, bkup.description, bkup.backup_finish_date,

case

when type='D'...

I came across the answer now in SQLServerCentral itself.

http://www.sqlservercentral.com/Forums/Topic731376-110-1.aspx#bm731472

We need to query msdb..backupset and there is a TYPE column where we can see the values for

different kinds of backups.

Dear All,

Thanks for all your prompt response. I was working with an application team member and it was his job which was failing. I was helping to fix it. Looks...

No error messages recorded on log.

There are no triggers or constraints. Here is the...

Thank you all for the wonderful inputs.

Thanks for the quick response. Sorry, I had give the wrong instance name to connect.

I checked the SQL Server Log at this folder and got correct instance name.

C:\Program Files\Microsoft SQL...

To add, the database is in bulk-logged recovery model

Another question is, creating indices would generally help select statements. But in this case as it is a update, would it have any negative impact ?

CirquedeSQLeil (5/12/2010)

---

mohammed moinudheen (5/12/2010)

---

Leo.Miller (5/12/2010)

---

Also where in the index are these 2 columns? If they aren't the first 2 columns you are doing a table or clustered index SCAN, of...

CirquedeSQLeil (5/12/2010)

---

mohammed moinudheen (5/12/2010)

---

We have a situation.

UPDATE stagingtable

SET DeleDate = @A1, IncrementLoadCd = @A2

WHERE TransactionId = @A3 and RangnDsTx = @A4

is taking too...