Good one, thanks Steve and happy holiday. I didn't expect that the DATEDIFF function can also use the abbreviations dw or just w as a day datepart.:rolleyes:

Fortunately, I found in the documentation an example with ALTER TABLE ... SWITCH into non-partitioned table ... 😉
Thanks Sknox for an interesting question and also for the very good...

Thanks for this interesting question Steve. I learned a lot from this, especially when I found this old post on the SSC forum and even this request on MS...

I was interested that in the description of the argument MAX_FILES = { 'max_file_count' | DEFAULT } I couldn't find the default value. I've overlooked
the above link to

Thanks Carlo for such a interesting prepared question. I had a little help in an article on this topic recently mentioned in the Newsletter section.😉

Thanks Thomas for this question. Yes, back to the basics, but I still looked into MSDN before answering ...😉

Thanks for this question Steve. It reminds not only computer science, but also some great scientists such as Sir Charles Antony Richard Hoare and others.

Thanks for this question. Life is easy when it's Friday and the author of the QotD is Mr. Stanley... 🙂

Thanks for another lesson in R-language. I was a bit confused by the title of today's QotD "Testing values in R", but I tried again something new.
The usage of...

Thanks Devendra Kumar for this question. According to the answers it is seen that the new documentation is to put it politely, misleading
and old documentation is hard...

Thanks Steve for this question. Intuitively, I translate the question as follows: "Which types of algorithms can be entered for argument WITH ALGORITHM =", and this without further context.
More...