Good catch!

Thanks.

From your link:

Compression can allow more rows to be stored on a page, but does not change the maximum row size of a table or index.

So, the "Compression can allow...

Please, post an example with RANGE!

I tried this one, so the right answer is PARTITION BY:

SELECT SUM(object_id)OVER()

,SUM(object_id)OVER(PARTITION BY NULL)

FROM sys.objects

WHERE object_id < 100

I use this function with recursion and @top of 1000000 is enough for me, but I don't n know if it performs better:

-- by Carlo.Romagnano

CREATE FUNCTION dbo.fn_tally(@top INT)

RETURNS TABLE

AS

RETURN WITH...

Explanation doesn't match with the "pseudo correct" answer.

From documentation:

The "radix" method generally outperforms the other methods, especially for character vectors and small integers. Compared to quick sort, it is slightly...

Little typo: newletters vs new_letters

newletters<- c("q","w", "e", "r", "t", "y", "u", "i", "o", "p", "q", "w", "e" )

> which (new_letters=="q")

"In this code, the SET IMPLICIT TRANSACTIONS ON sets a @@trancount of 1. I am not sure why this occurs, but it means that after the COMMIT, there is still...

• This reply was modified 3 years, 9 months ago by  Carlo Romagnano.
• This reply was modified 3 years, 9 months ago by  Carlo Romagnano.

-- correct

declare @d tinyint = NULL

RAISERROR(' %s is the current value', 1, 0, @d)

-- incorrect

declare @d tinyint = 1

RAISERROR(' %s is the current value', 1, 0, @d)

You can avoid COALESCE with this code:

SELECT *

,LAG(CAST(b AS VARCHAR(10)),1,'N/A')over(ORDER BY a,b)

FROM (VALUES

('a',1)

,('b',2)

,('c',3)

,('d',4)

) AS V([a],)

-- P.S. I did not test for performance.

• This reply was modified 3 years, 9 months ago by  Carlo Romagnano.

A little typo:

name, value, level0 type of schema, level0 value of dbo, level1type of table and level1name of dbo.Adverts.

level1name should be only the name of table without the schema.

That's right!

It's good to know.

Here's to force the minus precedence:

SELECT (-100.0)/(-100.0)*10.0

The increment also is out of transactions. So, rollback doesn't restore the original value.

Also, you can not remove the property IDENTITY from a column.

This adds the IDENTITY to a column:

ALTER...

The same:

SELECT 0x00006B61+0

Here states different:

A.difference(B) it's the same as A-B

https://www.geeksforgeeks.org/python-set-difference/?ref=rp

This is not a correct answer. There's no -m flag. From the documentation, @@cursor_rows returns -m if the cursor is being asynchronously populated. That just means a negative value m is returned by...