Reputation
533
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 7 20
Impact
~67k people reached

  • 0 posts edited
  • 3 helpful flags
  • 20 votes cast
Apr
19
awarded  Popular Question
Apr
13
awarded  Popular Question
Mar
14
awarded  Notable Question
Jan
29
awarded  Popular Question
Jan
17
revised Should the index on an identity column be nonclustered?
deleted 6 characters in body
Sep
28
comment Allow user to do anything within his own schema but not create or drop the schema itself
But the user will be able to create objects under other schema too?
Aug
19
revised Should the index on an identity column be nonclustered?
edited title
Aug
17
revised Should the index on an identity column be nonclustered?
added 100 characters in body
Aug
17
revised Should the index on an identity column be nonclustered?
added 74 characters in body
Aug
17
awarded  Nice Question
Aug
13
revised Should the index on an identity column be nonclustered?
added 287 characters in body
Aug
3
revised Should the index on an identity column be nonclustered?
added 79 characters in body
Aug
3
revised Should the index on an identity column be nonclustered?
added 25 characters in body
Aug
3
revised Should the index on an identity column be nonclustered?
added 16 characters in body
Aug
3
comment Should the index on an identity column be nonclustered?
@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.
Aug
3
revised Should the index on an identity column be nonclustered?
added 22 characters in body
Aug
3
revised Should the index on an identity column be nonclustered?
added 70 characters in body
Aug
3
comment Should the index on an identity column be nonclustered?
@ypercube The link kejser.org/clustered-indexes-vs-heaps said that the non-CI will have less LIO.
Aug
3
revised Should the index on an identity column be nonclustered?
added 2 characters in body
Aug
3
asked Should the index on an identity column be nonclustered?