How long would it take to insert that many rows? ☺ Regards,
Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Friday, 11 September 2015 10:15 AM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: Re: Odd text encoding but because they were concerned about the possibility of running out of bigint values. (Clearly it’s a pity more maths isn’t taught at schools). My PC can do a for int loop up to 2^30 in about 20 seconds. To get to 2^63 non-stop it will take 5444 years -- GK