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 - 2006-07-10 : 09:09:18
|
| Senthil writes "hi1. can u give me an example for how to create vertical and horizontal partition (updatable). And how to maintain it.2. i have 20 milion records in a table, how can i increase the query perfomance?.thanks in advance.regards Senthil" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-10 : 12:55:42
|
| 1. SQL 2000 doesn't support partitioning2. proper indexing is one possible answer..post your table ddl (including existing queries), problematic queries that include execution plan and some sample data and we can start to help with issue 2.-ec |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-10 : 13:08:55
|
quote:
Originally posted by eyechart
1. SQL 2000 doesn't support partitioning
SQL Server 2000 has partitioned views that allow you to partition horizontally.Tara Kizeraka tduggan |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-10 : 15:00:42
|
quote:
Originally posted by tkizerSQL Server 2000 has partitioned views that allow you to partition horizontally.
good point. anyone ever use this? :)-ec |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-10 : 15:04:58
|
| We've been considering it for one of our applications. I have never implemented it though.Tara Kizeraka tduggan |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-07-10 : 15:35:30
|
| I've implimented it in a datawarehousing application. It's one of those things that if you don't plan and test well, you will gain nothing. In my implimentation, it works VERY well. I've got nearly 100 million rows in it now, and I can find and return 500,000 rows in seconds on a relativly slow machine with very slow disks.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-07-10 : 15:36:11
|
| There's also Federated Database servers for partitioning. I've never done it, but it seems a bit cumbersome to impliment.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
|
|
|
|
|
Partition and maintainance in SQL Server 2000