Skip to main content
Kirk Saunders's user avatar
Kirk Saunders's user avatar
Kirk Saunders's user avatar
Kirk Saunders
  • Member for 8 years, 3 months
  • Last seen this week
  • Louisville, KY, USA
6 votes
2 answers
1k views

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

4 votes
2 answers
403 views

Referential Integrity - Indirect Foreign Key In "Depth"

3 votes
1 answer
380 views

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

3 votes
1 answer
239 views

Reused Nested Decision Logic - CTE vs Copying Code

3 votes
1 answer
138 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
826 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
184 views

Transactional Replication Architecture - One Article - Multiple Subscribers

1 vote
2 answers
654 views

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

1 vote
3 answers
586 views

Parameterized Dynamic TSQL - Dynamic Parameters

0 votes
1 answer
60 views

Method for Finding Top Record with WHERE conditions in Child Tables

0 votes
0 answers
627 views

Multi-Tenant Database Design - Tenant-specific Fields