As someone who's tried to restore a tape that would no longer sync to the drive, I say that a test restoration is not just "ideal" but a standard. ...

Paul DB (3/4/2009)

---

Matt Miller (6/16/2008)

---

Having done some amount of testing on this - while this scenario is certainly convenient in some scenarios, it has a tendency to perform on par...

David McKinney (2/27/2009)

---

mdonnelly (2/27/2009)

---

This would have been on the bubble of being excusable had the original article not...

don_goodman (2/27/2009)

---

If you are going to write a piece of code then you have an obligation to the user. Why? This is a service business. The user experience is the...

This would have been on the bubble of being excusable had the original article not had a big,...

for what it's worth, I can give you a little simplification. The partitioning query doesn't have to be stated twice:

select acct.[Name], cont.fullname, cont.createdon

FROM [AccountBase] acct

JOIN...