Reputation
433
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 6 16
Newest
 Caucus
Impact
~48k people reached

  • 0 posts edited
  • 3 helpful flags
  • 18 votes cast
4h
revised Should the PK on an identity column be non-clustered?
added 79 characters in body
5h
revised Should the PK on an identity column be non-clustered?
added 25 characters in body
5h
comment Should the PK on an identity column be non-clustered?
@JustinCave Looking for a rang of A only is not the primary case. Looking for B, C are common too.
5h
revised Should the PK on an identity column be non-clustered?
added 16 characters in body
5h
comment Should the PK on an identity column be non-clustered?
@ypercube In my question, the query I listed is the common one. The ID is more like a surrogate key. It may be only used to join another table. I want to find out which case, CI or non-CI is better in my case.
6h
revised Should the PK on an identity column be non-clustered?
added 22 characters in body
6h
revised Should the PK on an identity column be non-clustered?
added 70 characters in body
6h
comment Should the PK on an identity column be non-clustered?
@ypercube The link kejser.org/clustered-indexes-vs-heaps said that the non-CI will have less LIO.
7h
revised Should the PK on an identity column be non-clustered?
added 2 characters in body
7h
asked Should the PK on an identity column be non-clustered?
Jul
27
awarded  Caucus
Jul
24
awarded  Notable Question
Jul
10
awarded  Popular Question
Jun
30
awarded  Popular Question
Jun
23
awarded  Notable Question
Apr
14
revised Grant Windows logins to read a secondary database of log shipping?
added 65 characters in body
Apr
14
awarded  Yearling
Apr
14
asked Grant Windows logins to read a secondary database of log shipping?
Mar
24
accepted Delayed transactional replication setup?
Mar
24
asked Delayed transactional replication setup?