You are welcome. The change was small, and a deployment occurred today.

Snowboarding (winter is here 😉 )

I've seen it work many times. My wife has had this help her a...

Excellent article. Thanks for this bit of SQL Spackle.

I would expect that behavior. It works uplevel, but not downlevel.

Mirroring is built for HA/DR, which means that you are trying to protect your data with another copy. I'd...

http://msdn.microsoft.com/en-us/library/aa174503%28SQL.80%29.aspx

I think I should add in a prize for last place. That way @speedracer, myself, Texas Engineers, and DBCC Go Team have something to shoot for the next few...

I'd like to switch the ratings myself. Though I'd like a couple of axis along which to rate things. They would all be a simple +1, -1 that you could...

blandry (12/1/2010)

---

Our jobs are jobs, NOT recruitment into someone's army. Stand up for yourself, show your value, and if sadly, you work for a company that cannot appreciate that,...

Greg Edwards-268690 (12/1/2010)

---

We usually find that some columns are best frozen, some always updated with current value, and some with both a frozen and a current column meets most of...

the constraint checks are very small and don't impact performance in a significant way. Adding them in there is a way of ensuring that your data is correct and accurate,...

Grant Fritchey (12/1/2010)

---

Oooh, good question. I haven't. I...

I'm with Alvin. I'd question the design.

I just saw a request for a beginner "how to back up and restore your databases to keep them safe" presentation.

My guess is this is one that should get written,...

If you assign the account to SQL Server using the Configuration Manager, it will determine the rights for SQL Server to run.

If you mean that the account you used for...