User Kevin

8 votes

3 answers

23k views

Parent/Child Relationship Table Design - What's The Best Practice?

asked May 17, 2018 at 17:20

5 votes

2 answers

2k views

NonClustered Index not being Used

sql-server sql-server-2008-r2 index-tuning nonclustered-index

asked Mar 6, 2018 at 13:49

4 votes

1 answer

3k views

Poor Performance When Calling Query From Another DB on same Server

t-sql sql-server-2014 performance query-performance

asked Jan 4, 2018 at 12:59

3 votes

1 answer

3k views

Replace all Numeric Values with Single Character

sql-server t-sql replace

asked Sep 7, 2018 at 16:52

2 votes

1 answer

127 views

PIVOT with SQL Server

sql-server sql-server-2008-r2 t-sql pivot

asked Jul 2, 2018 at 17:05

2 votes

1 answer

203 views

Table Design - Storing Mulitple Parameters Required for Data Warehouse Report [closed]

sql-server database-design

asked Feb 15, 2018 at 14:04

2 votes

2 answers

12k views

SQL Native Client 11 - SQL Server 2017

sql-server sql-server-2017 oledb native-client

asked Aug 28, 2019 at 15:38

2 votes

1 answer

827 views

SSIS - Setup OLEDB Connection to SQL Server Always On Listener

availability-groups ssis sql-server-2017

asked Mar 19, 2020 at 17:50

1 vote

1 answer

383 views

SQL Server Migrate Database - Set Compatibility Level

sql-server migration compatibility-level

asked Feb 6, 2018 at 15:12

1 vote

1 answer

5k views

Multiple PIVOTs SQL Server

sql-server t-sql pivot

asked Apr 6, 2018 at 15:00

1 vote

2 answers

2k views

TSQL Remove Characters from Text Value

sql-server t-sql replace

asked Jul 10, 2018 at 14:26

1 vote

1 answer

495 views

SSIS Installation on Dedicated Server

ssis installation etl ssis-2016

asked Nov 9, 2018 at 12:25

0 votes

1 answer

4k views

Install SSDT for VS 2017 - Missing Integration Services

ssis ssdt visual-studio-2017

asked Nov 12, 2018 at 12:24

0 votes

1 answer

69 views

Query Locks Table And Takes Long Time to Run

sql-server performance cte performance-tuning query-performance

asked Oct 30, 2018 at 17:19

0 votes

1 answer

47 views

TSQL - Finding Similar Values

sql-server t-sql string-searching

asked Jul 31, 2018 at 14:19

0 votes

2 answers

288 views

Query Plan - Estimated Row Count Very High

sql-server-2008-r2 performance execution-plan query-performance

asked Jul 3, 2018 at 11:50

0 votes

1 answer

44 views

M:M Table Design - Use of PK

sql-server primary-key many-to-many surrogate-key

asked May 22, 2018 at 9:41

0 votes

1 answer

4k views

SSIS - Disable Task Based on Variable Value

ssis-expressions ssis-2008 data-flow

asked Feb 22, 2018 at 13:56

-1 votes

2 answers

600 views

TSQL Query to Remove Dates in Multiple Formats from Text Values [closed]

sql-server sql-server-2008-r2 query date-format string-manipulation

asked Aug 8, 2018 at 11:14

Stack Exchange Network

current community

your communities

more stack exchange communities

19 Questions

Parent/Child Relationship Table Design - What's The Best Practice?

NonClustered Index not being Used

Poor Performance When Calling Query From Another DB on same Server

Replace all Numeric Values with Single Character

PIVOT with SQL Server

Table Design - Storing Mulitple Parameters Required for Data Warehouse Report [closed]

SQL Native Client 11 - SQL Server 2017

SSIS - Setup OLEDB Connection to SQL Server Always On Listener

SQL Server Migrate Database - Set Compatibility Level

Multiple PIVOTs SQL Server

TSQL Remove Characters from Text Value

SSIS Installation on Dedicated Server

Install SSDT for VS 2017 - Missing Integration Services

Query Locks Table And Takes Long Time to Run

TSQL - Finding Similar Values

Query Plan - Estimated Row Count Very High

M:M Table Design - Use of PK

SSIS - Disable Task Based on Variable Value

TSQL Query to Remove Dates in Multiple Formats from Text Values [closed]