Jason-299789 (2/19/2013)

---

Scott,

I would disagree with you on the under no circumstances comment, for a couple of reasons

1) the risk of fragmentation is significant on the clustered index, especially if...

Bhuvnesh (2/18/2013)

---

ScottPletcher (2/18/2013)

---

Under no circumstances should you cluster this table on Policy_transactional_ID.

Cluster the table by the most common WHERE conditions; make the clustered key unique by including the Policy_transactional_ID on...

David Moutray (2/18/2013)

---

ScottPletcher (2/18/2013)

---

All triggers are implicitly part of a transaction, with at least the SQL statement that caused the trigger to fire included in the transaction.

In implicit transaction mode,...

It is possible in SQL Server.

Maybe...

You don't want to issue your own BEGIN TRANSACTION in the trigger, since, as I noted before, you're already in a transaction.

That error message after the ROLLBACK is normal, to...

Jeff Moden (2/18/2013)

---

Except for Sean, we did forget to answer the original question. :blush: Thanks,...

Modest DBA (2/18/2013)

---

100% i agree with you, but the thing is also not data loads.

To curb this, i requested a data count, after every table re-load, and the difference between...

Under no circumstances should you cluster this table on Policy_transactional_ID.

Cluster the table by the most common WHERE conditions; make the clustered key unique by including the Policy_transactional_ID on the end...

declare @enddate datetime

set @enddate = getdate()

SELECT STUFF(CONVERT(varchar(10), DATEADD(DAY, -21, @enddate), 1), 3, 4, '')

Instead of constantly trying to adjust the max size, I'd suggest setting the max to "UNLIMITED", then monitoring and alerting for every file growth occurence instead.

All triggers are implicitly part of a transaction, with at least the SQL statement that caused the...

I've got scripts that will generate point-in-time recovery scripts. And generate and execute tail log backups.

I suspect you could get a script(s) from the web for that and modify...

Jeff Moden (2/15/2013)

---

ScottPletcher (2/15/2013)

---

Jeff Moden (2/14/2013)

---

ScottPletcher (2/14/2013)

---

That's a significant change!

In order, here's a quick list of the most important things to do first:

1) Make sure the DBA role will fit...

Jeff Moden (2/14/2013)

---

ScottPletcher (2/14/2013)

---

That's a significant change!

In order, here's a quick list of the most important things to do first:

1) Make sure the DBA role will fit you. As...

Do you want to test DateDesc for within the last 30 days?

If so, then maybe this (added that check to the WHERE clause):

select

activityname,

dd.datedesc,

dateadd(hour, - 5, DD.DateDesc) AS date_completed,

getdate()-1 as...