I concur.

Dearie me!

Reading the exact same doccumentation pointed out in the reference, I deduced that the result should be 'x' for the single char column, and 'xxxx' for the longer column,...

Yeah, I think I'll sit this one out for a bit...

Ooops!

This isn't the first time I've accidentally clicked on the "Featured Script" link instead of the "Question of the Day" link. And to add to my confusion, I misread  "Can...

You know, I kind of prefer the kinds of questions where there is a way to answer the question 😀

Well, this doesn't make sense. If 'radix' sort is named the fastest method for vectors of integers, and this is the method selected for those when 'auto' is specified, then...

Interesting.

How I parsed this is :

• The explicit BEGIN TRAN increases the @@TRANCOUNT to 1.
• The INSERT increases it to 2.
• The COMMIT decreases it to 1
• The SELECT ......

As far as I can tell, there are actually two correct answers to this one. Both

LEAD(currMonthSales) OVER (ORDER BY saleyear DESC, salemonth DESC) AS prevSales

and

            
February 16, 2021 at 7:30 am
            
#3845521

            
            
                                                
        

I'm sorry, but I just don't understand what is being asked here.

Doh!

Didn't spot the start at 1 condition. More coffee!

Yep. I think this stems from the how the original character wasn't an actual question mark, but rather an extended character, which the font used to present the question couldn't...

Also, for SQL Server 2019, you should use ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU=;

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-server-configuration-transact-sql?view=sql-server-ver15

The sp_configure option will be deprecated.

• This reply was modified 4 years, 11 months ago by Rune Bivrin.

Quite honestly, I can't be...

Good question to showcase a new feature!

From a BI/DS perspective, this is potentially very useful for data profiling.

Had to take a wild guess here, as Unit_Cost doesn't seem to be available in the data frame...