Nice question but to get the good answer , I had to find the way used to calculate this date ( in France , Thanksgiving is not an holiday and...

Thanks for this nice question which I answered in the good way only because I knew the history of the imbrication between Access and SQL Server.

Thanks also for the valuable...

SQLRNNR (12/4/2015)

---

Of the three options posted, I have to disagree that one is more correct than another based on the givens in this question.

Granted that a precision of less than...

Ken Wymore (12/4/2015)

---

I guess this is what I get for going back and answering an old QoTD. 😛 Not sure if I can still get points back for this question...

My last reply about this exciting QOD.

I have appreciated all the posts as each one learnt me something , even the "joke".

When I installed my SQL Server 2008 Developer (...

Thank for this easy question foreseeing the week-end.

Hi Hugo ,

Thanks for your quick reply.

It means that I have understood the Jens's blog who helped me so much when I started on the forums.

Without him , I would...

What do you think about this old blog ?

Do you agree with the explanations given by the author to reject the sp_ prefix at the beginning of the name of...

good joke

patrickmcginnis59 10839 (11/18/2015)

---

patricklambin (11/18/2015)

---

Thanks for this interesting question. I have been able to answer it only because I have studied jobs ( and used them ) in September.

As several posters...

Thanks for this easy question because there are very few modifications in the syntax of CREATE TYPE since its appearance with SQL Server 2005.

I have begun to use SQL...

Thanks for this interesting question.

I knew the "special" format YYYYMMDD as I am curious and I have studied the sysjobschedules table. The format for the date and time is maybe...

Hi Steve ,

Interesting question but I am not understanding exactly its meaning and more exactly its usefulness.

1) we are to surround the name by brackets because . symbol is not...

Thanks for this interesting question. I have been able to answer it only because I have studied jobs ( and used them ) in September.

As several posters , I am...

Thanks for this interesting question on a difficult topic.

I have been able to guess the good choice only because I have studied the chapter 10 of the Microsoft SQL Server...