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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-04 : 21:38:52
|
| sushil writes "Dear SQL experts,I am dealing with performance tuning in MS SQL Server 2000.I have a view with more than 2 million records and to optimize my selects I am looking for having a partitioned view on it.The issue is that my table has primary key composed of two columns.For ExampleTable t with columns a int and b datetime.I have other columns also , but my primary key is on these two columns. I cannot make primary key on any one column.When I create tables with primary key on these two columns and a check constraint on column b with date range. At the time of updating it says partitioning column not specified.Can you pls help me in finding a way.Tks & regds,sushil." |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-03-04 : 21:38:52
|
| Are you really sure you need a partitioned view? 2 million records isn't very many for a decent sized computer. Maybe if you post your table and query we can help out. Also, how big is your server? |
 |
|
|
|
|
|
partitioned view on a table with composite primary key