Kirk Saunders

Louisville, KY, USA
Member for 5 years, 6 months

Reputation

959

959
491
23

2018
2019
2020
2021

Top tag

sql-server

Next privilege

1,000 Rep.

See votes

Badges

5

15

Newest

Revival

Next badge

110/300

Impact

1 post edited

0 helpful flags

110 votes cast

13 Questions

Votes Activity Newest Views

1

4

votes

2

answers

262

views

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

sql-server database-design varchar

May 23 '20 at 18:37 David Browne - Microsoft 36.1k

3

votes

2

answers

153

views

Referential Integrity - Indirect Foreign Key In "Depth"

sql-server database-design foreign-key referential-integrity

May 15 '20 at 17:54 David Browne - Microsoft 36.1k

1

3

votes

1

answer

59

views

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

sql-server index performance query-performance

Oct 29 '19 at 20:00 CommunityBot 1

1

3

votes

1

answer

102

views

Reused Nested Decision Logic - CTE vs Copying Code

sql-server performance cte query-performance

Jun 20 '19 at 15:40 CommunityBot 1

3

votes

1

answer

215

views

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

sql-server sql-server-2012 merge sorting

Apr 19 '16 at 7:11 Cody Konior 3,397

2

votes

2

answers

212

views

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

sql-server query-performance execution-plan string

Dec 8 at 14:46 Erik Darling 31.3k

2

votes

1

answer

495

views

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

sql-server

Feb 26 '19 at 17:34 Kirk Saunders 959

2

votes

1

answer

759

views

Table Locking When using Unions

sql-server sql-server-2012 locking union

Dec 4 '18 at 18:38 Paul White♦ 64.1k

2

votes

1

answer

843

views

Backend Table/Row Locking Structure using CTE Queries

sql-server sql-server-2012 locking cte union

Dec 4 '18 at 4:47 CommunityBot 1

1

1

vote

3

answers

155

views

Parameterized Dynamic TSQL - Dynamic Parameters

sql-server dynamic-sql parameter

Oct 29 '20 at 16:46 mv ٠〳comment ٠〳answer 662

1

1

vote

2

answers

249

views

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

sql-server database-design ssms table

Jun 7 '19 at 12:34 Jonathan Fite 7,148

0

votes

0

answers

62

views

Multi-Tenant Database Design - Tenant-specific Fields

sql-server database-design best-practices multi-tenant

Feb 23 at 4:24 Doug Deden 1,222

0

votes

1

answer

32

views

Method for Finding Top Record with WHERE conditions in Child Tables

sql-server t-sql optimization

May 26 '20 at 5:35 Graham 556

Database Administrators Stack Exchange works best with JavaScript enabled