I am a firm believer in using data, facts, and science to prove things, but if it is digital it can be hacked.  So, there definitely needs to be a...

The correct answer should be E. None of the above.  Store postal codes as string values.

I would like slightly more verbose file names.  However as other have stated, we are still limited to 260 characters for the max path length in Windows.  I personally have...

I believe at some point machines will probably replace certain aspects of DBA work, but not all aspects soon or maybe never.  I would highly disagree with Microsoft's claim they...

I thought this was a good laugh.

https://ayende.com/blog/177729/emoji-encoding-a-new-style-for-binary-encoding-for-the-web

This is my list in basically chronological order.

• QBasic
• C
• C++
• LISP
• Visual Basic
• T-SQL
• VB.NET
• C#
• JavaScript

I've also dabbled in Java, Lua, Python, and most of your Windows scripting languages.

We only have 2 physical servers left that are in use. Which puts us at 78% virtual

Hugo Kornelis (5/20/2014)

---

Oh wow - that is so awesome! 😉

What error message do you get - directly related to the foreign keys, or just the optimizer crashing or running out...

We currently have a poorly designed audit system that requires 391 foreign keys to a single table. The interesting thing is once you get too many foreign keys SQL...

Then what time are you expecting?

Here is an example of adding 5 hours and 30 minutes as minutes with results from SQL 2008

SELECT dateadd(n,330,CAST(635302120392663258/864000000000.0 - 693595.0 AS DATETIME)),

CAST(635302120392663258/864000000000.0 -...

SwastikMS (3/12/2014)

---

I used the below statement:

e.g.,

SELECT dateadd(hh,5.30,CAST(635302120392663258/864000000000.0 - 693595.0 AS DATETIME))

It's giving me a difference of approx. 30 minutes.

When I don't add the UTC difference, the result has a...

First post the code you...

thierry.vandurme (11/22/2013)

---

Thx for the reply Robert.

I don't quite follow. If you can regenerate (reverse-engineer) the code using the .NET Reflector how can you protect your software? Ok, if it's...

L' Eomot Inversé (7/11/2013)

---

Jeff Moden (7/11/2013)

---

Even though the explanation of exceeding the max INT value is completely wrong, I'm absolutely amazed that more than 1/3 of the people that answered...