Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Kirk Saunders's user avatar
Kirk Saunders's user avatar
Kirk Saunders's user avatar
Kirk Saunders
  • Member for 8 years, 1 month
  • Last seen more than a month ago
  • Louisville, KY, USA
6 votes
2 answers
1k views

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

3 votes
2 answers
388 views

Referential Integrity - Indirect Foreign Key In "Depth"

3 votes
1 answer
378 views

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

3 votes
1 answer
234 views

Reused Nested Decision Logic - CTE vs Copying Code

3 votes
1 answer
130 views

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

2 votes
1 answer
1k views

Table Locking When using Unions

2 votes
1 answer
2k views

Backend Table/Row Locking Structure using CTE Queries

2 votes
1 answer
802 views

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

2 votes
2 answers
2k views

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

1 vote
1 answer
161 views

Transactional Replication Architecture - One Article - Multiple Subscribers

1 vote
2 answers
630 views

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

1 vote
3 answers
534 views

Parameterized Dynamic TSQL - Dynamic Parameters

0 votes
1 answer
53 views

Method for Finding Top Record with WHERE conditions in Child Tables

0 votes
0 answers
596 views

Multi-Tenant Database Design - Tenant-specific Fields