Viewing 15 posts - 16 through 30 (of 325 total)
In the Docs Client Protocols Properties (Order Tab), there is a note that the protocol order settings are not used by Microsoft .NET SqlClient. The protocol...
November 12, 2021 at 2:39 am
You'll probably make fun of me for not ending it yet but I had some time, so maybe:
"Which permission, at a minimum, should a user have to execute DROP AGGREGATE?...
November 9, 2021 at 4:04 pm
Hi Steve, and what about this: "Which database permission levels below can I use to run DROP AGGREGATE in SQL Server 2019?"
November 8, 2021 at 5:37 pm
Thanks Alessandro for this question and an excellent explanation.
September 29, 2021 at 4:18 pm
When you execute a lambda function on a single value as:
(lambda y: y+5) (5)
then the result is 10. So the answer (5) is not correct?
August 11, 2021 at 3:29 pm
"Confers ownership-like capabilities on the grantee." Yes, I read this sentence several times and also SQL Docs "ALTER AUTHORIZATION (Transact-SQL)". Then I found links to "
February 16, 2021 at 12:45 am
Thanks for this interesting question Steve but I'm not sure why the bcp command doesn't specify the connection to SQL Server? See Docs bcp Utility.
January 7, 2021 at 3:25 pm
Thanks Steve for this question and all the work on SSC.com. Merry Christmas and Happy Holidays to you. Good luck in the new year.
December 25, 2020 at 5:45 pm
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
Viewing 15 posts - 16 through 30 (of 325 total)