User Kirk Saunders - Database Administrators Stack Exchange

Kirk Saunders

Member for 7 years, 1 month
Last seen this week

Louisville, KY, USA

14 Questions

Score Activity Newest Views

4 votes

2 answers

821 views

Store VarChar(Max) [Notes] Column on Same or Separate Table

asked May 22, 2020 at 20:22

3 votes

2 answers

290 views

Referential Integrity - Indirect Foreign Key In "Depth"

asked May 14, 2020 at 21:55

3 votes

1 answer

324 views

SQL Merge Statement Spending Large Amount of Time Sorting on Primary Key

asked Apr 18, 2016 at 19:00

3 votes

1 answer

180 views

Reused Nested Decision Logic - CTE vs Copying Code

asked Jun 20, 2019 at 14:54

3 votes

1 answer

98 views

Does the Query Optimizer Prefer to Query on Constants before Columns?

asked Oct 29, 2019 at 15:31

2 votes

1 answer

1k views

Table Locking When using Unions

asked Nov 30, 2018 at 18:17

2 votes

1 answer

1k views

Backend Table/Row Locking Structure using CTE Queries

asked Dec 3, 2018 at 15:11

2 votes

1 answer

672 views

Utilizing a Right and Left Outer Joins in same SELECT [closed]

asked Feb 26, 2019 at 16:01

2 votes

2 answers

1k views

WHERE Clause Compare VarChar(n) Column = VarChar(MAX) Variable Results in Inequality Comparison and Poor Query Performance

asked Dec 7, 2020 at 18:21

1 vote

1 answer

98 views

Transactional Replication Architecture - One Article - Multiple Subscribers

asked Mar 21, 2022 at 21:39

1 vote

2 answers

482 views

SQL Server - Physical Table Design - Column Order - Null and Non Null Columns

asked Jun 6, 2019 at 14:37

1 vote

3 answers

338 views

Parameterized Dynamic TSQL - Dynamic Parameters

asked Jul 12, 2019 at 13:19

0 votes

1 answer

37 views

Method for Finding Top Record with WHERE conditions in Child Tables

asked Apr 1, 2020 at 19:42

0 votes

0 answers

284 views

Multi-Tenant Database Design - Tenant-specific Fields

asked Feb 22, 2021 at 16:33