Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Analyzer
Posting Yak Master
115 Posts |
 Posted - 2008-02-28 : 12:00:11
|
| Hi - have 150,000,000 row table receiving BULK INSERTS all day - I have also found out my client likes to performan READ opertions simultaniously against this table with of course chronic contention issues.Need to provide a quick-fix, will index views enable me to abstact the reporting data away from the BULK INSERT table and is there any connection issues between the base table and the Index View? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-28 : 12:12:01
|
| For 150 million, Table Partition will be best option if you have enterprise edition. Index views will also give good performance and they have to schema-bounded with tables. |
 |
|
|
Analyzer
Posting Yak Master
115 Posts |
Posted - 2008-02-29 : 04:28:09
|
| OK - Thanks. |
|
|
|
|
|
|
Will Index Views assist with contention issues