I'd guess that there are a lot of small and big shops out there, which uses bcp and sqlcmd regulary (e.g. bcp for simple import / export tasks where SSIS...

Another problem: JSON could be stored in a (N)VARCHAR(MAX) field which could not be added to an index (only included, but this would only allow full index scans, even if...

What happens, if you call the procedure again with an ID which has only one entry (so that the granted memory is now much to high)? Will it lower the...

I'm confused - the MS page you linked in your answer says in its head:
THIS TOPIC APPLIES TO: SQL Server (starting with 2016)

So...

Heterogenity may sound nice, but if I have x different systems, it multiplies the number of vulnerabilities too. And of course I would need staff, which knows this systems very...

Why is usefull stuff as this deprecated? Everyone is talking about normalisation, but I still have to write the same code in a CHECK CONSTRAINT again and again and again,...

Yes, a procedure RUNs and COMPILES with a separat scope / copy of the #temp table. But (as written) there seems to be a bug in the parser / syntax...

As long as 3rd party tools as SQL Prompt or SSMS Boost does not support SOS, it is unlikely, that I would use it regularly, except it implements all the...

Our database uses triggers on many databases. Some time ago, when the developers had to run a special INSERT/UPDATE/DELETE, which should not trigger the trigger :-), the always disabled the...

Nice article, but instead of using a slow multiline table value function, you should better use the well tested and fast inline table value function DelimitedSplit8K (except your...

Short question: I admit, that I do not work with R, but why should anyone else really wants to do this "graphical" plotting in R, while there are much more...

How did you get your result?
I used the following query and get other numbers:
WITH myBeers (<see CTE in the question> )
SELECT ISNULL(bt.OwedTo, bb.OwedBy) who, SUM(bt.Beer)...

To be honest, I did not even understand the question and felt like a newbie...

I'd prefer to use
FIRST_VALUE(pts) OVER (Partition by Team ORDER BY Year ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
since this performs better (does not spill to...

I guess they needed the 29 days to remove those silly clause, that everybody needs a vacuum cleaner in the basement, which was added by me in my youth while...