"On the plus side, storing telephone number as int uses less storage than a varchar. Ok you won't need to use any numeric functions on it, but you probably won't...

• This reply was modified 1 month, 3 weeks ago by  andrew gothard.

Well,

while I agree with you that it's an abomination, and I would also go as far as to say it's a hallmark of absolute rank, wilful incompetence, and if you...

the lesser of 4 sockets or 24 cores, yes.  So realistically the limit on modern kit is 24 with the number of cores on chips these days.

That said, while I've...

One of my absolute pet hates.  I'm not quite sure whether this is because it's an abomination in itself (it just smells of "I couldn't be bothered to actually think...

Aye, but if you can manage to find anything in Dynamics or Sharepoint that could be considered good practice, I do believe there's a prize on offer

Given that the name is misleading, certainly in terms of how many people claim to understand it, I would personally change the NOLOCK hint name to IDeliberatelyCodedThisJoinToReturnCrap.  With immediate effect,...

Third party contracts like that are only as good as the last test.

Given some of the systems I work with, probably Plague Doctor

yet there are still thousands of scientists who argue climate change is not human caused, that it is the natural cycle of the earth. Ice sheets are breaking...

Hey, that approach worked brilliantly on the Chevrolet Corvair though, didn't it ...  um.

As far as natural / surrogate keys go, natural keys *may* be inappropriate as a PK.  However, whether it's the PK or not, if you do not assign a unique...

I believe that the actually probably refers to the fact that people now pay lip service to the need for security "security is a priority on our systems", while still...

This is not defined in the EU legislation, so it's...