This is a very good question, thank you. I did not have any problems answering after posting the datalength question expanding on the original question on len function by Ron...

paul.goldstraw (4/8/2010)

---

Any idea what the latest date is? I got as far as 500,000 days into the future before i gave up, I doubt i'd have much use for this...

The "Exponent Engima"...

Paul White NZ (4/7/2010)

---

I have never come across one. Apart from the bizarre rules illustrated by the...

This is a very interesting question, thank you Carla. I knew that 1753-01-01 was selected as the first available date, but had no clue why the SQL Server team chose...

Thank you for an excellent explanation Hugo. The code like this should not be present anywhere near production of course, but the question is definitely a good one. One of...

This is a very good question, thank you Ron. Looks like today I was the first one to answer it. I had to take a guess because I don't have...

Nice question, thank you.

I got it wrong because I checked first 3, but failed to check the last checkbox, and it looks like the latter is the one which causes...

sjimmo (3/16/2010)

---

Oleg,

I wasn't arguing the point. I think it is a great question, causing a of of thought and good conversation. I just got it wrong, I admit it. My...

sjimmo (3/16/2010)

---

Hugo, after getting the questin wrong;-) and re-reading a few times in disbelief I found on <http://msdn.microsoft.com/en-us/library/ms175477.aspx&gt; - Each data backup includes part of the transaction log...

This is a very good question, which definitely required some thinking to answer. Thank you.

It looks like I am the first one who answered this one correctly :-). The full...

This could be another option to the two I suggested in the list...

Very good question, not very difficult to answer, but prompting reading on the subject. Thank you.

The word Extensible does the trick I guess. It is nice to have to answer...

This is a very good feature of the...

This is a very good article Jason, thank you.

When recovery model is full, proper handling of the log file growth is of utmost importance, and your article is going...