The idea in checksum is to reduce work. ALL hashing algorithms have the possibility of collisions. The faster/shorter/cheaper the algorithm is, the more likely there are collisions. CHECKSUM() is dangerous...

Wow, fourth highest score and a loss. Quite a good matchup week according to the scores.

Agree with Gianluca.

Copy the error logs to another machine and open them with a text editor.

Always do this before any update/insert/delete.

begin tran

-- your insert/update/delete code here

-- select code to test your changes

rollback

-- commit

This will run the commands, then undo them. Be careful if your commands...

Wayne West (9/14/2015)

---

I'll be honest: I currently do not use a version of VCS. I did back in the Dos days using BRIEF, someone came out with a source...

Kristen-173977 (9/14/2015)

---

Matt Miller (#4) (9/14/2015)

---

The time you and your dev team spend building out your own RDBMS isn't "free": it's time you're not spending on building out actual useful functionality...

Not angry at all. Just responding. I think you are likely correct that this is needed for DQS. What I'm not sure if if it's needed as a restore or...

No, diagramming is nowhere on our radar...

I (not surprisingly) use Redgate's SQL Source Control..

I have in the past worked as Rod has and kept a VCS client open along with my SSMS. In those cases, we...

patricklambin (9/13/2015)

---

Please , could you have a look at this link ?

I think that you have to restore this database to the same state as it was before the modifications...

Thanks, I'll get someone to take a look at the hosting provider.

That's cool....

It's helpful to know what you mean here, and you should clarify if you need to see the geo codes in the result.

If not, this is really a simple query....

Wade_S (9/11/2015)

---

hakim.ali (9/11/2015)

---

I'm going to play devil's advocate, and ask this question: why bother with creating or maintaining the ER diagram? What purpose does it serve after the very initial...

Hopefully SQL Relay Bristol and Cardiff are on. Grant and I have been wrestling to get travel booked for those two.