Topic profile page for Bigint.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Bigint.
Topic "Bigint" was discussed 0 times on 0 sites in last 3 months
Started 4 days, 18 hours ago (2009-12-19 06:53:00)
by x0x
I have about 50 tables of which each have about 10 fields whose values will likely be 100,000,000,000-100,000,000,000,000. No negative values. I know that having that many big fields will eat my servers memory. Since bigint can hold up 18,446,744,073,709,551,615 it seems such a waste to use it. Should I use decimal instead for better performance? I'm trying to utilize my script because ...
Started 4 days, 23 hours ago (2009-12-19 01:39:00)
by Dave
I’m going to alter the CommandId column from int to bigint in the following table, and the table as about 1.7 billion rows. My DB is set to recovery model of simple so that will help keep the transaction log down, and the box is decently beefy with no other activity on it. I was wondering if someone could give me some idea of how long the operation may take? (I apologize for the generic nature...
Started 5 days, 6 hours ago (2009-12-18 18:16:00)
by Dave
I’m going to alter the CommandId column from int to bigint in the following table, and the table as about 1.7 billion rows. My DB is set to recovery model of simple so that will help keep the transaction log down, and the box is decently beefy with no other activity on it. I was wondering if someone could give me some idea of how ...
Started 5 days, 10 hours ago (2009-12-18 14:51:57)
by kirred
Does visual studio 2008 ship with a microsoft javascript library for bigint, I've reached a point where I need bigint's and it seems as if I'll have to download a free bigint library for javascript. Unless there is something for bigint in any of the js supplied by microsoft for asp .net. Does anyone know ? or can anyone recommend a good/free bigint library for js ? Thanks, Kirred...
Started 3 days, 13 hours ago (2009-12-20 11:25:00)
by Tarvo
I don't know what field type to choose for my numeric fields. I have about 50 tables of which each have about 10 fields whose values will likely be 100,000,000,000-100,000,000,000,000. No negative values. I know that having that many big fields will eat my servers memory. Since bigint can hold up 18,446,744,073,709,551,615 it seems such a waste to use it. Should I use decimal instead for better...
Started 3 days, 12 hours ago (2009-12-20 13:10:00)
by tkizer
> Although your question could be answered by either Microsoft SQL Server professionals or MySql professionsls since it's a simple data type question, for future questions related to your database I'd suggest posting them on a MySql forum instead since this site is specifically for Microsoft SQL Server. Both dbforums.com and mysql.com have MySql forums, so you'll get ...
Started 1 week, 1 day ago (2009-12-16 01:11:00)
by Ben Goh
Hello there people. I'd like to select only records from the table below, where certain bit is set in the "Flags" column: TABLE: USERS Uid: BIGINT (User ID) Name: NVARCHAR(64) Flags: BINARY(32) "Flags" column contains bits that carry various information. For example, a banned user will have its 4th bit turned-on (0x00000008). If I were to get all banned users I will ...
Started 1 week, 1 day ago (2009-12-15 10:35:00)
by Jassim Rahma
I am using the code below to generate a new transaction number but getting the following error: Arithmetic overflow error converting expression to datatype varchar DECLARE @trxn_number bigint SET @trxn_number = ( SELECT MAX (trxn_number) FROM accounts_trxn) SET @trxn_number = @trxn_number + 1
Started 19 hours, 6 minutes ago (2009-12-23 06:09:00)
by Dave
I was away due to travels so could not read these great responses until now. Given the CommandId column is a clustered index / PK and IDENTITY column - I agree with making a copy of the table, and moving data over in batches. Can you suggest some optimal batching techniques? I can think of using BCP, or SSIS or perhaps the ROWCOUNT property somehow. I would like to to do it all in SQL Server...
Started 4 days, 15 hours ago (2009-12-19 10:01:00)
by Erland Sommarskog
Gert-Jan Strik (sorrytoomuchspamalready@xs4all.nl) writes: > In step 2, the alteration from int to bigint will be instanteneous. That > is, because this schema change is not propagated to the data pages until > this is necessary I don't think so. Look at this: CREATE TABLE test (a int NOT NULL, b ...
Started 3 days, 5 hours ago (2009-12-20 19:28:00)
by jedi.knight
If you have indexed the database properly, the variable size won't be a big problem. Your problem with bigint is performance, not space, right? Can you give an example of a query? May be we can figure out the proper indexes.
