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...

The question is asked clearly: "What is the limit for rows in a Table Valued Constructor?". The documentation states that there is a limit. So there is nothing left to...

• This reply was modified 2 years, 10 months ago by George Vobr.

I agree with Mark. QotD's explanation is incorrect. Both the reference attached to the explanation and the reference given by Mark clearly state that...

• This reply was modified 2 years, 11 months ago by George Vobr.

I had some time, so "I had fun" and put together another way to find the part name from the CTE.

The query below displays the text of the part name...

In SQL Server 2017 (14.x) and later, it is possible to use the TRIM (Transact-SQL) function:

;WITH ctePC
AS ( SELECT expression
    ...

The question is irrelevant to the possible answers and to the explanation given. The question asks about the type of database, not what Amazon Redshift is.

According to Docs AWS "

• This reply was modified 3 years, 8 months ago by George Vobr.

Very weird Qotd. The QotD title is "Azure MariaDB", but the question is about MongoDB workload. MondoDB is probably a typo. Possible answers are more for MongoDB.

Thanks Steve for your work. Yes, time seems to be running faster and faster, sometimes I have a hard time catching up ...: -