File Recovery

How to Find and Delete Duplicate Contents in Your Excel

You will always deal with a bunch of data and information in Excel. So today we will talk about the Excel tips to find and delete duplicate contents in Excel. It is widely admitted that you will sometimes input some wrong information into an Excel file. One of those errors is inputting repeatedly. And most of the time, the small error is not easy to be found. Hence Excel has a very smart feature that can help you rectify this problem. Thus, you can sort out the values that appear more than...

Read more »

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 »