Viewing 15 posts - 31 through 45 (of 332 total)
Thanks Steve for this explanation, I understand. The current state is well stated in What you can do with Language Extensions.
November 20, 2020 at 6:50 pm
It might help to read the 3rd sentence of the @language argument description in the docs sp_execute_external_script (Transact-SQL).
I have. But see also the...
November 20, 2020 at 5:19 pm
In SQL Server 2019, Java, Python, and R runtimes are supported.
So not every language can be added with a language extension, or am I misreading this?
It might help to...
November 19, 2020 at 6:48 pm
Thanks Steve for this question, it's a good reminder about useful preference variables.
November 15, 2020 at 3:40 pm
I answered "Only a SCH-M lock". I didn't test it, I was based on DOCS Lock Compatibility, where SCH-M is not compatible with IX.
November 3, 2020 at 1:57 am
I like the way you have it well thought out, how the questions follow each other logically after weeks. There is a small detail on today's QotD from which one...
May 31, 2020 at 1:53 pm
But still, this question gave me new knowledge, such as what are base packages in R, how to make a list of installed packages, because without plyr package you can...
May 13, 2020 at 3:47 pm
I'm sorry, but your explanation is incorrect. Numpy.info, to which you refer, is a numpy-specific help function that does not give such an output about the data frame that is...
May 6, 2020 at 3:59 am
Thanks for this question, but is the ranking 1, 2, 2, 4, 5 given in the explanation correct? For the default SKIP, I would expect the ranking 1, 2, 2,...
May 2, 2020 at 12:24 am
Write me a question. George 🙂
Sorry, I have no question, I just wanted to point out the 3rd parameter for the ROUND function;-)
April 27, 2020 at 3:49 pm
Thanks Steve for this question. You can also try this:
SELECT ROUND(-7.7, 0, 1) as Round_truncated, CEILING(-7.7) as 'Ceiling';
GO
April 27, 2020 at 2:57 pm
I don't work with memory-optimized tables so I searched the web for the answer. Two sources state that DBCC CHECKTABLE will return: "Msg 5296, Level 16, State 1, Line 86...
March 27, 2020 at 4:39 am
Yesterday I gave up QotD after I couldn't decide which way was best. I wrote DecToHexa (n) function, which may be the answer # 1.
March 26, 2020 at 7:27 am
I had more time on Sunday, but I didn't believe I'd spend nearly half a day with it. I will try to explain this using the examples below, which I...
March 22, 2020 at 10:27 pm
Thanks for this question Steve. Today's Qotd could not be done quickly at breakfast with morning coffee. It was necessary to study DOCS well, you could "slip" in the recently...
March 19, 2020 at 4:25 pm
Viewing 15 posts - 31 through 45 (of 332 total)