Trying to preserve data types when duplicating a table, dynamically...

sp_executesql In Loop Taking FOREVER to Run. Slowing down as it runs. Memory Leak?...

Why does using CONVERT(DATETIME, [date], [format]) in WHERE clause take so long?...

Optimizing SQL Server performance: merging budget and actuals tables after same CTE transformations ...

Combining (concatenating) date and time into a datetime...

How to see the execution plan of a multi-statement table valued function in SQL Server?...

Used statistics from XML plan cache for query with given QueryPlanHash...

TSQL: ORDER BY - either use a column or nothing (empty)...

Workaround maximum key length for a nonclustered index in SQL Server...

Query to create new data column with alphabetical concatenating the data...

String_Agg concatenating duplicated value when there is multiple Ids exist...

Convert varchar to datetime without millisecond...

GROUP BY clause with a sum of zero (and non-zero) data...

Difference from the first row but aggregating from second row till the end...

XML output from SQL Server based on header and details...

Can I add a not null column without DEFAULT value...

Filter out codes under certain conditions...

Identify and label each branch in a hierarchical structure...

SELECT INTO USING UNION QUERY...

STRING_SPLIT and ROW_NUMBER() - maintaining order...

Get top 1 row of each group...

How to convert number of minutes to hh:mm format in TSQL?...

Retrieving last record in each group from database - SQL Server 2005/2008...

What is the difference between using a cross join and putting a comma between the two tables?...

How to split a single column values to multiple column values?...

Loading JSON file with nested elements into a T SQL table...

Given a view in SQL Server with a union query, can I find out which source columns from each source ...

Generate row for each month year if product sold in that year...

Make database column value dependant on another column...

SQL Server remove milliseconds from datetime...