Nice article but while reading it I could only thing about one thing.

Why do you call these Myth's?

A Myth is something that people believe is true that is not. ...

Post removed for being way too sarcastic.

Nice question and Answer!

Two great questions two days in a row.

Awesome!

Steve - I have only had two things that over 12 years of use I would recommend in any new updates to the site. These things are not IMHO...

Yes from what I read in your initial post you should either remove the first Begin after as or add another END as the...

L' Eomot Inversé (8/4/2013)

---

Nice question.

The answer seemed a bit obvious though - the phrase " Import Project Wizard" suggested that importing an SSIS project would be what was...

This is one of the best questions in a while.

I can tell by the answers provided that a lot of us learned something today.

Thanks so much. 😎

Nice question igorMi and great explanation. I had not though about these types of locks for a while.

You are welcome. As someone that suffered with other peoples DTS and loved BCP and scripts for SQL/shell commands,...

If you are familiar with DTS designer and the new look and feel of Visual Studio 2008 or 2010 then highly recommend using SSIS. Also you can use the...

Hugo Kornelis (8/1/2013)

---

This time I remembered to refresh before posting....

Seems like understood everything as well as I...

Hugo Kornelis (8/1/2013)

---

PHYData DBA (8/1/2013)

---

Phillip would you mind posting a link to the article your quote comes from? I not trying to say anyone is right or wrong. ...

DECLARE @var money = 123456789101118.12345

DECLARE @nvarchar nvarchar(21)

DECLARE @char nchar(22)

--Select 1

SELECT LEN(N'123456789101118.12345'), DATALENGTH(N'123456789101118.12345') ,N'123456789101118.12345'

--Select 2

SELECT LEN(@var), DATALENGTH(@var), @var

--Select 3

SELECT @nvarchar = convert(nvarchar(21), @var)

SELECT LEN(@nvarchar),...

philip.cullingworth (8/1/2013)

---

PHYData DBA (8/1/2013)

---

Hugo Kornelis (8/1/2013)SELECT LEN(@var) implicitly converts @var to string, because that's the only data type supported for LEN. This conversion is independent of the clients' Windows locale...