Quick Fix Strategies on a live application: In a scenario where the client requires a quick fix on a live application, but I want to avoid any downtime, what would be the best approach to resolve the issue?To address a live application issue without downtime, here are a few strategies you can consider: Rolling Updates: If you're using a scalable system, you can deploy fixes incrementally across servers. This way, you can ensure that only a subset of servers or containers is updated...

Read More »

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 »

C# Interview Questions and Answers

Here is a list of most popular C# interview questions and answers with their details explaination and code examples. The interview questions are for both, beginners and professional C# developers.    1. What is C#?   C# is a computer programming language. C# was created by Microsoft in 2000 to provide a modern general-purpose programming language that can be used to develop...

Read More »