We’re rewarding the question askers & reputations are being recalculated! Read more.

Profile Activity

Kirk Saunders

Network profile

Reputation

693

693
358
23

Feb
May
Aug
Nov

Top tag

sql-server

Next privilege

1,000 Rep.

See votes, expandable usercard

Badges

3

10

Newest

Yearling

Next badge

0/1

Impact

1 post edited

0 helpful flags

54 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

9 Questions

Views Newest Activity Votes

3

votes

1

answer

45

views

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

sql-server index query-performance

Oct 29 at 20:00 Justin Cave 18.4k

3

votes

1

answer

69

views

Reused Nested Decision Logic - CTE vs Copying Code

sql-server query-performance cte

Jun 20 at 15:40 Kirk Saunders 693

3

votes

1

answer

89

views

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

sql-server sql-server-2012 merge sorting

Apr 19 '16 at 7:11 Cody Konior 3,277

2

votes

1

answer

224

views

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

sql-server

Feb 26 at 17:34 Kirk Saunders 693

2

votes

1

answer

275

views

Table Locking When using Unions

sql-server sql-server-2012 locking union

Dec 4 '18 at 18:38 Paul White says GoFundMonica♦ 49.8k

2

votes

1

answer

319

views

Backend Table/Row Locking Structure using CTE Queries

sql-server sql-server-2012 locking cte union

Dec 4 '18 at 4:47 Paul White says GoFundMonica♦ 49.8k

1

1

vote

2

answers

81

views

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

sql-server database-design ssms table

Jun 7 at 12:34 Jonathan Fite 5,476

1

0

votes

2

answers

119

views

Parameterized Dynamic TSQL - Dynamic Parameters

sql-server dynamic-sql parameter

Sep 30 at 18:57 John Eisbrener 7,221

0

votes

0

answers

53

views

Sql Server - Execution Plan - Query Cost (relative to batch) calculation [duplicate]

sql-server sql-server-2012 query-performance execution-plan

Feb 12 at 19:05 Kirk Saunders 693

Database Administrators Stack Exchange works best with JavaScript enabled