User Kirk Saunders

1 vote

1 answer

214 views

Transactional Replication Architecture - One Article - Multiple Subscribers

asked Mar 21, 2022 at 21:39

0 votes

0 answers

654 views

Multi-Tenant Database Design - Tenant-specific Fields

asked Feb 22, 2021 at 16:33

2 votes

2 answers

2k views

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

asked Dec 7, 2020 at 18:21

6 votes

2 answers

1k views

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

asked May 22, 2020 at 20:22

4 votes

2 answers

418 views

Referential Integrity - Indirect Foreign Key In "Depth"

asked May 14, 2020 at 21:55

0 votes

1 answer

63 views

Method for Finding Top Record with WHERE conditions in Child Tables

asked Apr 1, 2020 at 19:42

3 votes

1 answer

143 views

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

asked Oct 29, 2019 at 15:31

1 vote

3 answers

660 views

Parameterized Dynamic TSQL - Dynamic Parameters

asked Jul 12, 2019 at 13:19

3 votes

1 answer

243 views

Reused Nested Decision Logic - CTE vs Copying Code

asked Jun 20, 2019 at 14:54

1 vote

2 answers

685 views

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

asked Jun 6, 2019 at 14:37

2 votes

1 answer

847 views

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

asked Feb 26, 2019 at 16:01

2 votes

1 answer

2k views

Backend Table/Row Locking Structure using CTE Queries

asked Dec 3, 2018 at 15:11

2 votes

1 answer

1k views

Table Locking When using Unions

asked Nov 30, 2018 at 18:17

3 votes

1 answer

386 views

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

asked Apr 18, 2016 at 19:00

Stack Exchange Network

14 Questions

Transactional Replication Architecture - One Article - Multiple Subscribers

Multi-Tenant Database Design - Tenant-specific Fields

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

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

Referential Integrity - Indirect Foreign Key In "Depth"

Method for Finding Top Record with WHERE conditions in Child Tables

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

Parameterized Dynamic TSQL - Dynamic Parameters

Reused Nested Decision Logic - CTE vs Copying Code

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

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

Backend Table/Row Locking Structure using CTE Queries

Table Locking When using Unions

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