Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
4
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Nov
21
awarded  Popular Question
Mar
8
comment What is the maximum number of rows in a clustered index on datetime column?
Is there any way(TSQL) to find out max(uniquifier key value) in a uniquifier index table --Thanks
Mar
8
comment What is the maximum number of rows in a clustered index on datetime column?
Just would like to confirm, Yes, smallest tick is hour and if we exceeds 2,147,483,647 duplicate values then it would fail..
Mar
8
comment What is the maximum number of rows in a clustered index on datetime column?
@Martin - we do import 3 million/day and data granularity is hourly so with uniquifier on datetime column,how many duplicates per day would be? and what is the max duplicates could have in a table. Thanks
Mar
7
comment What is the maximum number of rows in a clustered index on datetime column?
@Martin - According to this link(details) with uniquifier if duplicates exceeds 2,147,483,647 then it will fail mssqltips.com/sqlservertip/2082/…
Mar
7
comment What is the maximum number of rows in a clustered index on datetime column?
Thanks Stevens,
Mar
7
comment What is the maximum number of rows in a clustered index on datetime column?
Is clustered index(non-unique) on datetime column key size is Bigint?
Mar
7
comment What is the maximum number of rows in a clustered index on datetime column?
Thanks, am in under impression that only 2 billion records because it internally creates integer(4 byte key size) range is -ve 2,147,483,648 To +ve 2,147,483,647 . since index key use positive number
Mar
7
asked What is the maximum number of rows in a clustered index on datetime column?
Aug
21
awarded  Scholar
Aug
21
awarded  Student
Aug
21
awarded  Supporter
Aug
21
accepted Rebuilding index has impact on mdf/ldf files SQL Server 2008
Aug
20
asked Rebuilding index has impact on mdf/ldf files SQL Server 2008