No announcements
-
0 Votes
loading 250 million rows from a staging table to production table with 500 columns
Hi all, As the title says, we've created a view to convert the data type on the 500 columns and then use SSIS to fastload into the production ...Proposed | 5 Replies | 502 Views | Created by ChanUot - Sunday, September 8, 2019 12:33 AM | Last reply by Naveen Thummalapenta - Thursday, September 12, 2019 4:41 AM -
3 Votes
How to partitions a fact table with 250+ million rows
here, I have been advised to partition our main Fact table which has over 250+ million rows in in it. The SSAS databaseProposed | 12 Replies | 1195 Views | Created by amir tohidi - Wednesday, April 12, 2017 11:02 AM | Last reply by amir tohidi - Wednesday, May 3, 2017 2:24 PM -
0 Votes
Unable to insert 2 million rows in staging table
Hi I need to insert 2 million rows in a staging table as a part of SP. It has been working fine until now. But all of a sudden the process goes ...Proposed | 1 Replies | 230 Views | Created by cse_supriya - Monday, May 29, 2017 5:18 AM | Last reply by Uri Dimant - Monday, May 29, 2017 5:33 AM -
0 Votes
Update Production Table From Staging
I have a production table called 'County2' with the following columns: CountyID ...Answered | 1 Replies | 5207 Views | Created by cdun2 - Monday, September 8, 2008 8:44 PM | Last reply by cdun2 - Monday, September 8, 2008 9:31 PM -
0 Votes
Rebuild clustered index on 500 million row table???
My environment is SQL 2000. I have a table with 500 million rows. The table is consistently getting updated and inserted. I can not take ...Proposed | 7 Replies | 9027 Views | Created by andre cole - Thursday, January 17, 2008 12:21 AM | Last reply by Josh Patterson - Tuesday, January 22, 2008 2:31 PM -
0 Votes
Inserting millions of rows into a table
Hi, I have a DataTable in memory and I want to write a C# code to dump the data into a SQL database. Is there a faster way of dumping millions of rows ...Answered | 2 Replies | 7138 Views | Created by Jina - Thursday, August 10, 2006 9:32 PM | Last reply by Umachandar Jayachandran - MS - Thursday, August 10, 2006 11:40 PM -
0 Votes
Adding new column to the table with 16 million rows
If the table is replicated, then adding a new column would send 16 million transactions to the distributer if it is Transaction replication. What is the ...Answered | 3 Replies | 2618 Views | Created by '''HuuM''' - Thursday, July 11, 2013 8:43 PM | Last reply by '''HuuM''' - Friday, July 12, 2013 5:37 AM -
2 Votes
Staging tables to Production
How do you update data from Staging tables to production typically. Do we have any shortcut or something like that. In oracle we haveAnswered | 2 Replies | 2882 Views | Created by czarvk - Thursday, May 17, 2012 4:56 PM | Last reply by ArthurZ - Thursday, May 17, 2012 6:51 PM -
0 Votes
300 million rows in a table
Hello Gurus, I have a table with over 300 million records in it. I was wondering if you can give me some ideas on how to ensure performance of the database is ...Answered | 2 Replies | 2279 Views | Created by ebrolove - Thursday, September 12, 2013 2:23 PM | Last reply by ebrolove - Thursday, September 12, 2013 2:58 PM -
0 Votes
Updating a column in a table that contains 50 million rows
I'm looking for some performance assistance on updating a column value in a table that contains approximately 50 million rows. I have a permanent ...Answered | 7 Replies | 5314 Views | Created by rxmoore - Wednesday, February 27, 2008 1:16 AM | Last reply by Arnie Rowland - Wednesday, February 27, 2008 8:26 AM -
5 Votes
DELETE Rows From a Stage Table
the new monthly data into a staging table, looks for rows in the new data that are updates to those in the production table, deletes those ...Answered | 6 Replies | 438 Views | Created by Adam Quark - Wednesday, December 5, 2018 7:59 PM | Last reply by Adam Quark - Thursday, December 6, 2018 3:41 PM -
0 Votes
DML operations on more than 500 million rows table
Hi Naomi, each time it varies from hundred thousand to a million records. This particular table has business key which is a Varchar as the Clustered Index and this ...Answered | 7 Replies | 3548 Views | Created by CSharp Enthusiast - Friday, March 2, 2012 12:03 AM | Last reply by Kalman Toth - Friday, March 9, 2012 12:39 PM -
0 Votes
Dynamic loading of Staging tables to DW tables
Yes, it sounds like it will work. In a data warehouse though, sometimes loading a DW.[table[ is not as simple as copying from a stage to the ...Discussion | 4 Replies | 1289 Views | Created by RobFarley - Wednesday, April 13, 2016 2:15 PM | Last reply by s3l3ct - Tuesday, June 7, 2016 2:21 PM -
0 Votes
Accessing 3 million rows of table
3 million rows - this can adversely affect the performance. Instead create a view and SELECT TOP few records (say 1,000 or 10,000) from this table. To ...Answered | 6 Replies | 693 Views | Created by UltraDev - Friday, October 3, 2014 5:51 AM | Last reply by UltraDev - Friday, October 3, 2014 12:34 PM -
0 Votes
Best way for altering datatype of a column in a 500 Million record table
Hi, I'm looking for a best way for altering datatype of a column which is integer right now to varchar(32). The table has 500 Million records ...Answered | 2 Replies | 3553 Views | Created by amey c - Thursday, June 17, 2010 11:49 PM | Last reply by Gert-Jan Strik - Saturday, June 19, 2010 4:57 PM -
0 Votes
Transfer table with million rows from database to other
about tables with 50 million rows with size of 18.747.624 KB This is a minimal example USE ...Proposed | 8 Replies | 805 Views | Created by Charles Bukowski - Thursday, May 22, 2014 7:40 AM | Last reply by Charles Bukowski - Monday, May 26, 2014 11:14 AM -
0 Votes
Accessing 3 million rows of table
You shouldn't allow users to access 3 million rows - this can adversely affect the performance. Instead create a view and SELECT TOP few records (say 1,000 or 10,000) from ...Answered | 11 Replies | 847 Views | Created by UltraDev - Friday, October 3, 2014 5:48 AM | Last reply by Kieran Patrick Wood - Friday, October 3, 2014 12:37 PM -
2 Votes
General Scenario- Adding columns into a table with more than 100 million rows
I was asked/given a scenario, what issues do you encounter when you try to add new columns to a table with more than 200 million rows? How do you overcome ...Answered | 2 Replies | 911 Views | Created by czarvk - Tuesday, April 15, 2014 10:16 PM | Last reply by Koen Verbeeck - Wednesday, April 16, 2014 6:58 AM -
3 Votes
Alter a table with 800 million rows
Hello, I would like to alter a table with 800 million rows.Answered | 5 Replies | 1746 Views | Created by deppsos - Friday, November 23, 2012 4:48 PM | Last reply by Olaf Helper - Friday, November 23, 2012 5:31 PM -
0 Votes
Loading data from Staging to reporting tables
Hi I need to load the Reporting schema Tables every day from Staging tables Using SSIS.What is best way to load from ...Answered | 3 Replies | 4898 Views | Created by AmarReddy23 - Tuesday, December 14, 2010 11:13 PM | Last reply by Thirunavukkarasu-BI - Tuesday, July 23, 2013 6:23 AM - Items 1 to 20 of 1733613 Next ›
No announcements