Database Administrators
Kirk Saunders's user avatar
Kirk Saunders's user avatar
Kirk Saunders's user avatar
Kirk Saunders
  • Member for 7 years, 5 months
  • Last seen this week
  • Louisville, KY, USA
Profile Activity

14 Questions

Score Activity Newest Views
2 votes
1 answer
1k views

Backend Table/Row Locking Structure using CTE Queries

2 votes
2 answers
1k views

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

2 votes
1 answer
1k views

Table Locking When using Unions

5 votes
2 answers
953 views

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

2 votes
1 answer
712 views

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

1 vote
2 answers
550 views

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

1 vote
3 answers
420 views

Parameterized Dynamic TSQL - Dynamic Parameters

0 votes
0 answers
386 views

Multi-Tenant Database Design - Tenant-specific Fields

3 votes
1 answer
344 views

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

3 votes
2 answers
325 views

Referential Integrity - Indirect Foreign Key In "Depth"

3 votes
1 answer
203 views

Reused Nested Decision Logic - CTE vs Copying Code

1 vote
1 answer
122 views

Transactional Replication Architecture - One Article - Multiple Subscribers

3 votes
1 answer
103 views

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

0 votes
1 answer
38 views

Method for Finding Top Record with WHERE conditions in Child Tables

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.