What index fill factor did you use?

Grant Fritchey (3/28/2014)

---

JoshDBGuy (3/28/2014)

---

New Born DBA (3/28/2014)

---

JoshDBGuy (3/28/2014)

---

If it's simple recovery, after a transaction has been fully committed the space used should be reused. If it's in full recovery, you...

Couple issues.

Your database settings aren't optimal, I would set the growth to something closer to 1000 MB. 1 MB will cause frequent DB autogrowths...

New Born DBA (3/28/2014)

---

JoshDBGuy (3/28/2014)

---

If it's simple recovery, after a transaction has been fully committed the space used should be reused. If it's in full recovery, you need to run...

vigneshkumart50 (3/28/2014)

---

Hi,

select '$ '+ CONVERT(varchar,CONVERT(decimal(10,0),CONVERT(money, Amt_Value)),1) as [Amount]

from Products

How can I sum this column values and need to set a validation like the column has null values it has...

If it's simple recovery, after a transaction has been fully committed the space used should be reused. If it's in full recovery, you need to run t-log backups for the...

Just so I understand your question. Your log file is filling up, meaning the % free space is decreasing at around the same time every other day? You're also asking...

Great, glad I could help.

Did you check the history of the job to see how it was invoked? Usually you'll see something like "The job succeeded. The Job was invoked by Schedule XXXX...

The fact that it's sporadic is weird. Are there other jobs that run, that could trigger this job to run as well, after they are complete using an EXEC Sp_start_job...

WebTechie38 (3/26/2014)

---

This is an incredible day!!

I want to thank all of you for your responses. I am in constant learn mode with SQL Server. From asking one question,...

Timestamp should be the same. I'm guessing the application is reporting it wrong.

Huh, maybe that really isn't a deadlock which makes me worried about the app. I see a lot of entries here going back a couple weeks, but nothing that correlates...

Thanks Sean.

Could you provide more detail as...