A quick introduction to files and filegroups in SQL Server

In this article we take a close look at the structure of files and filegroups present in SQL Server SQL Server makes use of binary files and not textual files and it consists of two types of files Log files and Data files; these can further be grouped into Filegroups for the purpose of allocation and administration. Data files understandably consist of data and objects like tables, indexes, views etc. Log files on the other hand keep a record of all transactions and also stores information...

Read more »

How to Compare Values Side by Side via Bi-directional Bar Charts in Excel

You will certainly use the bar chart to analyze important values. And now we will demonstrate the creation of a bi-direction chart in Excel. There are many methods about charts in Excel. Now if you want to compare the values in cells, you can also realize it in a bi-direction chart. In the image below, you can see that there are values about two different sales representatives. Now you can insert such a chart and compare their sales volume. Insert a Bi-direction Chart Here are the...

Read more »

5 Minutes to Create an Attractive Doughnut Chart in Your Excel

Chart in Excel can make the data and information more intuitive. In this article, we will have a brief understanding of doughnut chart in Excel. If you want to analyze the percentage of data in Excel, the doughnut chart is a very good choice. It is in the form of a doughnut, and you can see the percentage directly from the chart. Create a Doughnut Chart The process of creating a doughnut chart is very easy. In the image, you can see the sales volume of each season. And you can create a...

Read more »