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 |
|
vicky.srm87
Starting Member
6 Posts |
 Posted - 2015-03-13 : 02:19:07
|
| Hi,Is really speed up the performance while we use the table partition ?How the performance is while inserting a records and selecting a records?Note: Table having around lacks of records.Can any one help me regarding this ?Thanks in advance..... |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2015-03-13 : 08:25:15
|
| Patitioning can give you better performance depending on what your requirements are. Watch this video - it will tell you a lot about when to use partitioning, how to use it, and whether you should even use it. It is a bit long - over an hour, but it will be time will be well-spent. https://technet.microsoft.com/en-US/sqlserver/gg545008.aspx |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2015-03-13 : 11:26:56
|
For only 100,000 rows I doubt partitioning will help you.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
|
|
|
Table Partition