File Recovery

Understanding the concept of Table Partitioning in SQL Server

In this article we look at the concept of table portioning as implemented in Ms SQL Server Partitioning in SQL Server involves partitioning tables and indexes and storing them in multiple physical sections. This feature is available in the Enterprise edition of SQL Server, if you wish to use it for production. It is also available in the developer edition for trial. Partitioning is a complex feature of SQL Server, and allows splitting an index into multiple small indexes. Every partition has...

Read more »

How to Save Your Time by Creating and Using Excel Templates

Excel has a wide range of usage in our work. And we will talk about how to create and use Excel templates to save your time in work. In an Excel file, you will certainly input the data and information. And sometimes, you will find that you need to input some information repeatedly. Therefore, you may wonder if you can avoid input the same contents every time you open a new file. Thus, you can choose to create a template and store the contents. An Example of Excel File This image below is...

Read more »

How to Monitor the Changes of Important Cells through Watch Window in Excel

Excel is always used to manage important data and information. Thus, today we will introduce how to use the watch window to monitor the changes of some important cells. In an Excel file, you will always store some important data and information. But sometimes, you will inevitably need to change certain elements. But the data in an Excel has deep relation with each other. For example, you will use some formulas and the data may come from other worksheet. So one number changes, you need to...

Read more »