Solutions

3 Different Methods to Refresh Pivot Table when the Source Worksheet Data are Updated

Pivot table is quite potent in Excel. In this article, we will talk about 3 methods to refresh pivot table in Excel. The pivot table will not refresh automatically in Excel. Thus, if you have modification on the original data, you will certainly need to refresh it. For example, this worksheet records the sales volume of two products.   Besides, in another worksheet, there is a pivot table for the data and information. If you modify the original worksheet, you need to refresh the...

Read more »

Database Partitioning – Key concepts every DBA must know

In this article we would go through the key concepts associated with Database partitioning in SQL Server Partitioning in SQL Server is used for easy maintenance and improved performance of the database. It allows splitting of large tables along with individual tables. Queries which require access to limited data can be performed quickly as the data to be scanned is lesser. Maintenance task like rebuilding indexes or backing up tables, can be performed quickly. Partitioning does not always...

Read more »