Kirk Saunders's user avatar
Kirk Saunders's user avatar
Kirk Saunders's user avatar
Kirk Saunders
  • Member for 7 years, 10 months
  • Last seen more than a week ago
  • Louisville, KY, USA
5 votes
2 answers
1k views

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

3 votes
2 answers
360 views

Referential Integrity - Indirect Foreign Key In "Depth"

3 votes
1 answer
369 views

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

3 votes
1 answer
227 views

Reused Nested Decision Logic - CTE vs Copying Code

3 votes
1 answer
120 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
1k views

Backend Table/Row Locking Structure using CTE Queries

2 votes
1 answer
771 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
152 views

Transactional Replication Architecture - One Article - Multiple Subscribers

1 vote
2 answers
598 views

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

1 vote
3 answers
501 views

Parameterized Dynamic TSQL - Dynamic Parameters

0 votes
1 answer
43 views

Method for Finding Top Record with WHERE conditions in Child Tables

0 votes
0 answers
537 views

Multi-Tenant Database Design - Tenant-specific Fields