Reputation
515
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 13 25
Impact
~128k people reached

  • 0 posts edited
  • 1 helpful flag
  • 48 votes cast
Apr
29
accepted Fastest way to disable indices and drop constraints and rebuild SQL Server table
Apr
29
comment Fastest way to disable indices and drop constraints and rebuild SQL Server table
I don't know. I'm not an expert in this area. :-\ I just know that with Netezza, our data warehouse's DBMS, it doesn't even have indices in it when they do bulk inserts. They run RI checks after ETL loads. But we are using SQL Server, so I don't know the best approach.
Apr
29
comment Fastest way to disable indices and drop constraints and rebuild SQL Server table
Well, isn't it a bad idea to have an index if you have 3 billion rows inserted into it? Isn't it better (and more efficient) to not have the index so it doesn't have to do referential integrity on each insert?
Apr
29
comment Fastest way to disable indices and drop constraints and rebuild SQL Server table
MarkSinkinson - how do I handle the other 6 commands, if we do a simple truncate?
Apr
29
comment Fastest way to disable indices and drop constraints and rebuild SQL Server table
Yes, after dropping that index, and adding data, we're creating the same clustered index again. Not sure why I have ONLINE = OFF. I'm moving this code from Pentaho Kettle to Informatica. So if we TRUNCATE TABLE OBS_FACT, what should the exact steps, and order be?
Apr
29
revised Fastest way to disable indices and drop constraints and rebuild SQL Server table
added 74 characters in body
Apr
29
asked Fastest way to disable indices and drop constraints and rebuild SQL Server table
Apr
13
answered Why does Informatica hang and say “Not Responding” when connecting to ODBC Data Source
Apr
13
asked Why does Informatica hang and say “Not Responding” when connecting to ODBC Data Source
Apr
13
answered ODBC Data Source Administrator: Driver name is an empty string
Apr
8
accepted What causes disk space growth from Informatica load onto SQL Server?
Apr
7
answered What causes disk space growth from Informatica load onto SQL Server?
Mar
24
revised What causes disk space growth from Informatica load onto SQL Server?
added 483 characters in body
Mar
24
comment What causes disk space growth from Informatica load onto SQL Server?
@Aaron, not necessarily. We are a datawarehouse but this database only represents the latest facts, so our type of facts don't change very much in this application. Only the date in which they are being represented. We basically just take the latest facts, so it doesn't grow very much considering we have data from 1988. From the last year, we may have grown a few dozen GB.
Mar
24
comment What causes disk space growth from Informatica load onto SQL Server?
@Kin, we are using Informatica 9.1. Our mapping is fairly simple, in that we have a source definition, a source qualifier, and a target definition. Nothing fancy. So just a single table with about 2 billion rows.
Mar
24
comment What causes disk space growth from Informatica load onto SQL Server?
@Aaron, we are almost hitting our disk space limit.
Mar
24
asked What causes disk space growth from Informatica load onto SQL Server?
Mar
12
awarded  Notable Question
Feb
4
awarded  Notable Question
Dec
5
accepted Database storage limit for open source PostgresSQL