In my more than 3 decades of database design, development, and administration I have never used GUIDs in any of my systems. I did have this debate with a...

I got it right but I don't think Steve got the answer to his question.

I would interpret that question to...

I think the right to be forgotten should be way more inclusive then just correcting bad data. I don't think it should be about right or wrong data. I think...

Megistal (12/2/2014)

---

I had that in mind while reading this morning article:

Not exactly right on the article but I guess you understand the point, whatever the situation.

(Image taken from :

Stuart Davies (11/12/2014)

---

It was sparked by new dev here, who couldn't see the difference between any of the four possible answers :w00t:

As the question and answer showed mixed cases, case...

Brian.Klinect (11/5/2014)

---

I forgot RAND() was exclusive. So we can get .99999..., which multiplies to 9.999999..... I take it then that storing a floating point number as an integer...

The connection to SQL Server for this question where I work is that we use the SETSPN utility to solve the double-hop issue. We have ASP.NET applications on a...

GilaMonster (10/9/2014)

---

I prefer to put the COMMIT inside the try block, rather than outside where an IF is necessary

So....

BEGIN TRY

BEGIN TRANSACTION;

-- Generate a constraint...

Here's an example from MSDN.

BEGIN TRANSACTION;

BEGIN TRY

-- Generate a constraint violation error.

DELETE FROM Production.Product

WHERE ProductID = 980;

END TRY

BEGIN CATCH

...

My company takes a middle of the road approach. We don't upgrade every version but we do try to stay in a version that is supported. When a...

No, "it depends" is the default assumption for any SQL Server problem, question, or answer. :w00t:

Enjoy!

Thanks for the question Steve!

I was hoping one of the answers was going to be "A supervisor who had too much caffeine".

:hehe:

Enjoy!

SQLRNNR (8/18/2014)

---

Yeah, that's one that I didn't like either.

Also, just because it can be shared doesn't mean that it should be shared. The answer "all hardware" to me is...

nimbell (7/15/2014)

---

Question didn't really make an adequate distinction between the logical and the physical:

Does the logical definition of a Primary Key imply the presence of an index? No

In SQL Server,...

BUT THEY STARTED IT!!!

:hehe: