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

Getting list of tables, and fields in each, in a database...

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

Using RegEx in SQL Server...

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