User Tom.Wheater

5 votes

4 answers

1k views

Giving EXEC (@Variable) a Column name and Concatenation

asked Mar 15, 2019 at 10:47

2 votes

1 answer

2k views

Using the same table twice in a select returns duplicate rows

asked Mar 21, 2019 at 9:42

2 votes

2 answers

485 views

Availability Group - Deleting old backup files

asked Aug 27, 2019 at 12:47

2 votes

1 answer

730 views

Recommended Permissions for SQL Account that will be creating new SQL Accounts

asked Apr 4, 2019 at 10:52

1 vote

2 answers

182 views

Performance - Looking for Some Advice on Improving this Query

asked Mar 4, 2020 at 17:12

1 vote

1 answer

94 views

Best way to speed up requests using date columns

asked Dec 4, 2018 at 12:17

1 vote

2 answers

3k views

Dynamic SQL - How can you use it to run a SELECT against all schema's and Tables?

asked Dec 4, 2018 at 17:04

0 votes

2 answers

1k views

Returning a variable from Dynamic SQL

asked Mar 11, 2019 at 16:07

0 votes

1 answer

567 views

Removing all Schemas and Objects from a database, excluding specific Schemas and Objects

asked Sep 20, 2019 at 13:00

0 votes

1 answer

520 views

IndexOptimize is successful, but sys.dm_db_index_physical_stats still shows huge fragmentation

asked Nov 28, 2019 at 17:05

0 votes

2 answers

1k views

INSERT INTO... SELECT over a LinkedServer in smaller batches

asked Jan 3, 2020 at 12:12

0 votes

2 answers

1k views

Creating a SQL Agent Job using Dynamic SQL

asked Jul 3, 2019 at 11:12

0 votes

1 answer

159 views

Delete Trigger - Linking to a table with a PK made up of three columns

asked Jul 12, 2019 at 14:07

-2 votes

2 answers

522 views

Concatenating Dynamic SQL commands with UNION returns inconsistent results

asked Mar 27, 2019 at 14:08

Stack Exchange Network

14 Questions

Giving EXEC (@Variable) a Column name and Concatenation

Using the same table twice in a select returns duplicate rows

Availability Group - Deleting old backup files

Recommended Permissions for SQL Account that will be creating new SQL Accounts

Performance - Looking for Some Advice on Improving this Query

Best way to speed up requests using date columns

Dynamic SQL - How can you use it to run a SELECT against all schema's and Tables?

Returning a variable from Dynamic SQL

Removing all Schemas and Objects from a database, excluding specific Schemas and Objects

IndexOptimize is successful, but sys.dm_db_index_physical_stats still shows huge fragmentation

INSERT INTO... SELECT over a LinkedServer in smaller batches

Creating a SQL Agent Job using Dynamic SQL

Delete Trigger - Linking to a table with a PK made up of three columns

Concatenating Dynamic SQL commands with UNION returns inconsistent results