Tag Info

New answers tagged

0

Table partitioning may improve performance if you are able to work within the limits of how the partition works. See the description at: http://technet.microsoft.com/en-us/library/ms177411(v=sql.105).aspx However, partitioning can also make your server run slower if your partitions are not set up "just so" and your queries cannot remain within a single ...


3

Using partitioning is only going to help your query performance if the partitioning scheme is built serve your specific queries. Your going to have to review your query patterns and see how they are accessing the table in order to identify the best approach. The reason for this is you can only partition on a single column (the partitioning key) and this is ...


0

Read this on the partitioning -- SQL Server- Table partitions on SSD. As far as #2, you're table will be fragmented if you design it this way. You should switch places of the columns. Make DateTime the first column, this way the new rows will be added at the bottom, instead of finding room for every Unit_Id everyday -- lots of page splits. Then you can ...



Top 50 recent answers are included