Profile Activity

Kirk Saunders

Network profile

Reputation

693

top 4% this year

693
383
73

Mar
Jun
Sep
Dec

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.5k

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

91

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,287

2

votes

1

answer

240

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

288

views

Table Locking When using Unions

sql-server sql-server-2012 locking union

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

2

votes

1

answer

328

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♦ 50k

1

1

vote

2

answers

84

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,569

1

0

votes

2

answers

121

views

Parameterized Dynamic TSQL - Dynamic Parameters

sql-server dynamic-sql parameter

Sep 30 at 18:57 John Eisbrener 7,375

0

votes

0

answers

58

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