Please no more responses on modifying system tables. It's not safe, and in this case, it should not be done.

To InfiniteError, you cannot modify the transaction log after, nor...

I'll check and see. I'd have thought the "/" was universal, but changing to "-" shouldn't be hard.

We'll be correcting things soon. Some of the idea behind SQL Monitor was to show you what an average instance looks like at many companies. Both Brad and I have...

This white paper should help: http://msdn.microsoft.com/en-us/library/ee523927%28v=SQL.100%29.aspx

Note that what you need is a big limiting factor. What types of data loss, recovery interval, administrative cost, etc. can you talk about for...

print out your SQL, look at it, execute it in stages. You are getting a syntax error here.

I still think my old method of using scripts is a good one. It handles dependencies, and it integrates VCS with a release process.

Building a stored procedure for a release...

Good advice above. I'd also add that what you want will change as you mature. There is no "best" to recommend for anyone in general, but there is a "best"...

It came out when I was 9, so that's when I saw it (10 times).

I think my son watched it at 6 or 7, but my daughter managed to see...

WayneS (11/29/2010)

---

CirquedeSQLeil (11/29/2010)

---

On the flip-side, I see your point and think that weekends are the times for doing deployments. Less impact to the business and make sure we have...

For e-comm, holidays don't make sense, and maybe not weekends. My point is more that the downtime is the time to do deployments, though often that doesn't match up with...

Craig is correct. Service Broker guarantees delivery, but not timing. The transactions in the other servers should still be there.

FWIW, to some extent I think that IT is the group that should work on holidays, and do deployments since this is downtime for many businesses. Of course I think...

Can you provide more information on what didn't work?

Back after a week gone, or most of a week. Somewhat refreshed, and ready to work.

Everyone has different ways to consume this and working with most of the world, the yyyymmdd is the most acceptable. The US prefers mmddyyyy, but that doesn't work in Europe.

I...