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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Table Partition

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -