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 |
|
thelostboy
Starting Member
1 Post |
 Posted - 2012-09-19 : 05:00:16
|
| Can someone explain SQL partition to me!I am fairly new to the whole SQL server thing and have pretty much been forced into the role of DBA which I am not complaingin about as I have found I am quite enjoying reading they books on SQL however up to this point I have pretty much understood everyting I have read till I got to partition and it is completly went over my head.I am wondering can someone enlighten me and explain it in a way that is idiot proof?Thanks guys |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2012-09-19 : 10:16:13
|
| The very quick, non-technical explanation is: partitioning is to physically organize the data such that for any given statement the data can be accessed from a relatively small percentage of the total disk area. You can logically partition your data simply by creating a clustered index on a column (or columns) that will logically order your data in a sequence that makes sense for your use. For instance for time-based reporting it would make sense to sequence your data by date. So even if you have years of data stored if you want to show all transactions for one day they will all be found grouped together on disk. Accessing that day's data can be almost as fast as if that was the only data stored.Sql server allows numerous types of partitioning but the objective is to physically segregate your data to support your logical business cases. If you have specific questions regarding the partition techniques that you read about in books online please post them.Be One with the OptimizerTG |
 |
|
|
|
|
|
Can someone explain SQL partition to me!