Fill Factor in sql server performance tuning server level, index/table level

Fill Factor: Working in performance tuning area, one has to know about Index and Index Maintenance. For any Index the most important property is Fill Factor. Fill Factor is directly related to Indexes. Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In an SQL Server, the smallest unit is a page, which is made of Page with size...

Read More »

What is bit, nibble, byte, kilobyte, megabyte, gigabyte, terabyte, petabyte, exabyte, zettabyte, yottabyte etc.?

How much is 1 byte, kilobyte, megabyte, gigabyte, etc.? Thanks to Computer Hope for sharing this knowledge. Below is a list of each of the accepted disk drive space values. It is important to realize that not all manufacturers and developers list their value using binary, which is base 2. For example, a manufacturer may list a product's capacity as one gigabyte (1,000,000,000 bytes, a metric...

Read More »