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 |
|
reyboy
Starting Member
12 Posts |
 Posted - 2004-11-19 : 00:38:08
|
| What is Partitioning Databases?What are its in's and Out's?Proud To Be Pinoy |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-19 : 08:08:45
|
| What problem are you trying to solve? Sounds like you're telling me your preferred solution, rather than the problem you are trying to solve!Kristen |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-19 : 13:24:39
|
| Partitioning should be towards the bottom of the list of things to do to get increased performance. There are usually easier way to get performance.Describe the problem, and we can help you find a solution that fits.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-19 : 13:27:26
|
| Teacher asks: "Please describe SQL Server partitioning. Provide its positives and negatives."Student asks SQLTeam: "What is Partitioning Databases?What are its in's and Out's?"SQLTeam responds: "Is this a homework question? If not, then please describe your problem so that we can help you determine if partitioning is a good solution for you."Tara |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-19 : 15:53:52
|
| Doh! I didn't pick up on the homework question thing. I usually do.Thanks for the post Tara!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
reyboy
Starting Member
12 Posts |
Posted - 2004-11-20 : 00:24:02
|
| Im sorry but this is not a "home work".Partitioning Database is really new to me, I was thinking that its like having a hard disk with many partitions like:Main_data.mdf = AccountingMain_data1.ndf = Sales and marketingMain_data2.ndf = Ware HouseMain_Log.ldfor just like having an application using 3 databasesAccounting.mdf, Sales.mdf & Warehouse.mdf.But As I tried it, It seems to have different use and does not conform to what I though It is. That is why its difficult to understand. Can't Even find a good resource materials on web.Proud To Be Pinoy |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-22 : 13:42:24
|
| Well, you can partition things out into different MDF files and load them onto different disk subsystems. I'm not sure on the name of that technique.Horizontal partitioning is where you take a single table, and split ti into several smallker tables to make inserts / selects faster.Example:Lets say you have a transaction table. It stores all transactions since the beginning of time. There will be LOTS of rows in that table, and most of them you don't need to look at all at the same time.So, you split that table up into smaller tables by year,month, etc.Give some of these articles a read:http://sqlteam.com/searchresults.asp?SearchTerms=horizontal+partitionMichael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
|
|
What is Partitioning Databases?