123 reputation
4
bio website
location Australia
age
visits member for 1 year, 7 months
seen Mar 11 '13 at 3:57

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