Issue with dynamic SQL to get JSON properties as columns when JSON is NULL...

How do I set a variable in an UPDATE statement, then use that variable in a xml.modify() statement?...

Literal datetimes as yyyy-mm-dd throw an exception...

SQL Calculate Consecutive hours...

bring down logical reads...

Convert HASBYTES function output to CHAR...

How to use SQL Case Expression using BETWEEN and OR?...

SQL server Date = @date but executionplan xml show it in inequality...

STRING_AGG with specific criteria...

rank smallest to largest...

Given 2 tables, how to consolidate them into a view?...

Replace of NCHAR(1600) is not working on SQL Server...

Select max and group by only one column...

Grant user rights to create new databases but deny rights to existing ones...

I wish to put this condition in a more sargable way...

Avoid repetition of aggregated column values from 2 left joined tables...

Get multiple column values from joined table in a comma separated list...

SQL Server STRING_AGG function sorting is not working as expected...

SQL Server - Dynamic multi column pivot...

Azure Devops Build Task executing SQL script aborts after a number of sp_rename calls...

Dropping Indices Before Bulk Load in SQL Server with Temporal Tables?...

Get Top 1 From Data For Every Employee...

DATALENGTH() works on literals but doesn't work on variables...

One column for each record/ row of a query's result...

Merge with Max value of another table...

Getting the sql server default backup folder on Linux with T-SQL...

Function to convert units based on conversion table...

Installing Two version of MSSQL SQL Server 2017 and SQL Server 2019 on same CENTOS 7 machine...

Running Balance per Account Number...

Is it safe to turn on Delayed Durability on a transaction replication subscriber?...