Datagod-309892 (3/3/2014)

---

I went to Amazon's first big AWS conference with a client. We attended a session included a discussion on Netflix's chaos monkey. My client was so impressed...

Backup/restore for me as well.

I might script this as a daily process that moves the latest backup from production to test, but doesn't necessarily restore it. This would make it...

I haven't typically seen connection issues taking many resources in SQL2K5+ instances. In SQL 7, it could be an issue, but usually in the 1000s of connections.

Does the app have...

+1

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