Yes, interesting question. Can be fooled by the fact that ...

SELECT len (@str),@str

Returns:

----------- ----------

5 1, 2,

...with a...

Yes, please explain the difference between answers 1 and 2 because it is very subtle.

Implicit type conversions have been shown to work differently from one SQL Server version to another. We had a question recently that exposed this behavior. We witnessed it...

If you rely on implicit conversion, is it going to convert the CHAR to DATETIME or DATETIME to CHAR? You are never really sure so you explicitly convert...

I agree. That was my first thought as well.

I have always been able to fix the broken database. I restore the backup with a new name and then drop and recreate any broken tables from the restored...

I would highly recommend you watch Paul Randal's TechED presentation.

http://www.sqlskills.com/BLOGS/PAUL/post/TechEd-80-minute-video-of-Corruption-Survival-Techniques-presentation.aspx

Thanks for the explanation. I missed that 'Statistics' was in the last answer. When I first read the answers I thought you were saying that is...

Five people got the question correct so far, I am not sure how that happened.

I set the default fill factor at %90. Then for tables which have static data that does not change much on a daily basis I explicitly set the...

So what kind of an error message does the author recieve when running CHECKDB agains the tempdb? I am not seeing it.

I agree. I was torn by DBCC CHECKDB, REPAIR_ALLOW_DATA_LOSS answer becuase it didn't...

Hugo Kornelis (8/5/2009)

---

You'll see that after the TRUNCATE TABLE, the space used is zero - but after the INSERT INTO, it is right back at its original size, even though...

Yes, I am a little worried about Artur. 😎

Yes, really nice question that illustrates the perils of naming a stored procedure using the naming convention 'sp_' which is used for system stored procedures.