Personally, I like the logic clear so if I glance at this in a year, or someone else does, it makes sense. I'd do this:

DECLARE @year INT

, @DateFirstIssued...

Was the series...

Don't commit, but if you think of ideas, make notes, or post them here. It would be good to have a nice set of 5-10 situations where cursors are replaced.

Feel free. Shouldn't be too long. Give a procedure and show how it works with a test user or two.

Can you track when changes are made to tables?

The replication process looks like any user sending a DML change to the server. To trigger on that, you'd need a trigger...

Potentially you have some sort of open transaction, close mirroring/ replication, that prevents the log from being cleared completely.

In terms of the size, I guess it's possible you need that...

call.copse (2/28/2014)

---

I don't think it could be a movie - maybe a HBO show or something - but I'd love to see the Foundation series adapted well. Tricky one mind...

That would be quite a thriller. I need to pick up his new one.

You don't write a trigger based on a range or partition. You write it based on the table.

If the read only groups are 3 months old, then your trigger just...

email the webmaster, or use the "Write for Us" link to the left and submit as an article.

I'll edit the piece to note that.

FYI, placeholder.

http://www.sqlservercentral.com/Forums/Forum61-1.aspx?Update=1

Good luck next year, Ray.....losing to the way0utwest Cowboys

Bits is great and there was a post on their Facebook page hinting that a contract was sent back today.

I'd guess they'll announce something in the next week

Are you saying you can add data to the partitions that are marked as read-only in the filegroups? It's possible there is a bug here wtih the partitions that doesn't...

roughly a page.