Thanks for this easy question ( especially when questions about Datetime2 data type seem usual since several months )

stuart.adair (1/19/2016)

---

Questions specific to a country should not be presented. I'm sure the American audience wouldn't like UK, China, etc related questions. This is topped by allocating 7...

Hugo Kornelis (10/30/2015)

---

I like the question. Good reminder of the intricacies of working with views.

There is a small mistake in the explanation, though. Changing data types will not cause conversion...

TomThomson (12/29/2015)

---

SQLRNNR (12/29/2015)

---

I was wondering that myself. It is easy enough to get a list of the configs from a simple select...

Interesting question but an easy one for me only because I remembered that the default value of the max length of a string is 4000. I have to admit that...

Thanks for this interesting QOD.

I have been able to select the good choice only because I have read the documentation of the next SQL Server version ( 2016 ) last...

Igor Micev (1/5/2016)

---

J Livingston SQL (1/4/2016)

---

Wayne West (1/4/2016)

---

Steve, I'd like to see your code because I can't duplicate it. I ran the following:

DECLARE @HashThis VARCHAR(20) = 'January 1, 2016';

SELECT...

Wayne West (1/4/2016)

---

Steve, I'd like to see your code because I can't duplicate it. I ran the following:

DECLARE @HashThis VARCHAR(20) = 'January 1, 2016';

SELECT 'MD2' AS HashType, hashbytes('MD2',@HashThis) AS...

TomThomson (1/4/2016)

---

Nice question

But just like the 29th December question it's more about the SMO object model than about PoSh. The first option is not the right one because a...

Thanks for this easy question ( SMO is my beloved part of SQL Server and I have written many pieces of code with it ). As PowerShell is often written...

So short and...

+1...

Excellent question for the last day of the year especially with an awesome trick : the comment for the 1st select in the 4th choice.

Before posting here , I...

It's working on SQL Server2014 Express and I have looked at the Spatial Results panel ( between the Results and Messages panels )

Eirikur Eiriksson (12/26/2015)

---

The explanation isn't correct, "This determines the storage for the type, but only in varying the storage from 6 to 8 digits of precision." should be "This determines...