mtassin (2/28/2011)

---

I got this right but...

SELECT 0%0

gives

Msg 8134, Level 16, State 1, Line 1

Divide by zero error encountered.

So it seems you can use it to divide 0 by 0 and...

So happy that over 80 percent of us know math.

Can you imagine how hard it would be a SQL developer or DBA if you didn't learn higher level math?

The command line utility should return a better error message and let you...

SanDroid (2/25/2011)

---

CynthiaD (2/24/2011)

---

Oh believe me, I did. Multiple times. It still didn't work. It could be that it's not Management Studio but some weirdness in the registry, or something like...

CynthiaD (2/24/2011)

---

Oh believe me, I did. Multiple times. It still didn't work. It could be that it's not Management Studio but some weirdness in the registry, or something like that....

Peter - It can be somewhat configured using the createdomain method.

http://msdn.microsoft.com/en-us/library/yk22e11a(VS.90).aspx

What the question is...

dvdwouwe 72544 (2/24/2011)

---

In this case, you can use hints on the UPDATE statement but NOT NOLOCK or READUNCOMMITTED, that isn't allowed, this means that updating a row always use a...

john.arnott (2/24/2011)

---

A user obtaining a value for key "PR1" in your code would not have a conflict with one obtaining a value for "PR2", but would still block a second...

dvdwouwe 72544 (2/24/2011)

---

So, I have show that the lack of constraints can lead to too much locking and this can have major impact on the system throughput. The optimizer...

Steve Jones - SSC Editor (2/24/2011)

---

My apologies, This was a question from Jamie Thomson and I have corrected that.

I have no idea what options there are in various editions of...

John - I think there is a lot of interesting things that are misunderstood about this article. Could be the reason...

Nice article but I did not read anything in it about the options in the Visual Studio Database/Refactor menu when you have...

Steve,

Are these options the same in all three versions of Visual Studio that had a Database edition?

I obviously got it right, but just curious why you did not specify.:w00t:

gdolghin (2/24/2011)

---

The "no-gaps-number" column is a business requirement and has nothing to do with the database structure. That one is usually managed through a trigger that selects next available value....

adam.everett (2/24/2011)

---

Can I ask why in the original code the lock on the kvp was required for the duration of the whole buniness transaction. Could they just not of...