Get unique values using STRING_AGG in SQL Server...

Operand type clash: date is incompatible with smallint error in sql server...

Calculate the previous sundays date from a Date column?...

How to show day name in SQL Server?...

Entity Framework Core 8 Where IN vs Where IN OPENJSON...

What Size Value Should Be Used When Adding a Parameter of SqlDbType.Text?...

OLE DB provider 'for linked server returned data that does not match expected data length for...

SQL Convert Milliseconds to Days, Hours, Minutes...

How to debug SSIS package in SQL Server Management Studio 2017?...

How do I avoid the SSIS error "Unable to determine if the owner (MyOwner) of job MyJob has serv...

Where to download the old SQL ODBC driver version 10 (not the Native Client)...

Get actual execution plan for query taking more than hours?...

OPTION(QUERYTRACEON 9481), Dynamic SQL & DBCC TRACEON error...

Edit asterisk symbol into list of column names in SSMS by wildcard expansion...

Split Invoice Total into multiple Rows but Split always equals Total...

Continue record sequence in blank months until another record appears...

Produce DISTINCT values in STRING_AGG...

Import Json data from URL to SQL server...

Triggers for checking complex uniqueness for table with soft deletes...

Returning XML Data in Tabular format when it isn't stored as XML...

Can't parsing an array of objects with Dynamic Keys using OPENJSON And SQL Server 2017...

Remove duplicate values in JSON Array...

Excel dates stored in SQL Table in Decimal format - convert back to dates...

What is the purpose of setting a calculated column to be PERSISTED?...

How to page records, get the total number of records, yet stay performant?...

Why the procedure stats are getting cleared very often from the SQL server?...

Wrapper Function For Date Truncation...

How to solve 'Cannot authenticate using Kerberos' issue doing EF Core database scaffolding i...

Flatten JSON object using SQL Server...

Long loading time when opening OLE DB Source in SSIS Package...