Great question! Thank-you for sharing!

David in .AU (7/31/2011)

---

This article might be interesting: note the reply from microsoft at the bottom

Replace of char(0) does not work in DB with Windows collation

I know it isn't exactly...

Thank-you for the interesting question!

It is strange that VARCHAR(MAX) would behave differently. Has this ever been reported to Connect?

Thank-you for the question. It is good to know that such a bug ever existed with SQL Server.

Undoubtedly, Raw Materials!

Good question, but I beg to differ:

1. The definition of platform is not clear - is platform a version of SQL Server or a version of the hardware or OS?

2....

Books On Line simply states that it is a DATETIME value, and default for DATETIME is NULL, so I choose NULL.

DECLARE @MyVar DATETIME

SELECT @MyVar

I would be interested to know why...

That is very strange. SQL Server itself would not do this. Are you sure that there is no code that would tell the SQL Server service to stop every Sunday?...

Great question!

While there is no golden rule of thumb, but I would say that if the log file does not grow by leaps & bounds or if you have limited...

david.wright-948385 (7/11/2011)

---

No criticism of the article, but I would argue that the only way to verify a backup properly is to restore it fully and perform the usual checks on...

Unfortunately, I did not get to attend any boot-camp trainings as I made my forray into the database world.

That being said, I am a strong advocate in favour of boot-camp...

steveb. (6/30/2011)

---

Nakul Vachhrajani (6/30/2011)

---

A new table may not be feasible in all cases. If you have triggers deployed by interfacing applications, then dropping and recreating the table will loose...

A new table may not be feasible in all cases. If you have triggers deployed by interfacing applications, then dropping and recreating the table will loose these triggers.

A look-up table...

SQL Server has a built-in function to do this:

select UPPER('sql server')

Which will yield:

SQL SERVER

You migh end up in a long-running query. Please look at other approaches from my article - http://www.sqlservercentral.com/articles/T-SQL/72606/%5B/url%5D