None of the references in the Explanation contain the keyword decimal.

The description of the Identity function states in the introduction that "IDENTITY

is used only in a SELECT statement with an...

God, how time flies, when Steve wrote about SQL Server on Linux 21 years ago, they wrote that Steve Jones has a side career as a carnival fortune teller. And...

• This reply was modified 2 weeks, 5 days ago by George Vobr.

Quite a tricky question without a clear explanation, which is not clearly given in the given Learn MS reference. The AI ??assistant had it right away... 🙂

Thanks Steve, a simple excellent question for learning what's new. 🙂

Function PWDCOMPARE returns 1 if the HASH of the clear_text_password matches the password_hash parameter, and 0 if it does not. So, two password hashes are actually compared.

Try DBCC CHECKIDENT (your_table_name)

I researched this for quite some time until I found a clear explanation

in SET IDENTITY_INSERT (Transact-SQL). Thanks for this question Steve.

This topic is described in the documentation in Use index rebuild to recover from data corruption

Implicit conversions generally do not prevent an index seek. If a VARCHAR procedure parameter were to be compared to an NVARCHAR column, SQL Server must implicitly convert the column...

It is also possible to use the DMV sys.dm_db_index_usage_stats, e.g. like this:

Run the following query to see how often each index in the current database

has been used...

Thanks, Happy Easter!

Quoting from the reference given in the explanation:

"The SQL Server Browser service lets users connect to instances of the Database Engine that aren't listening on port 1433 without knowing the...

Thanks for this question Steve, I had to at least find a link to the SQL Server previous versions documentation. By the way, the link to SQL...

Yes, me too. Using XE takes a lot more work.

Thanks for this question. I learned how to Find File Growths with Extended Events. Both references: system health session, and Finding File Growths mentioned in the explanation prove that it...