SqlServer-QA.net

It is a good practice to determine the required capacity for a database application before it is deployed on the Production environment. As it speaks the I/O system is ''most'' important to the performance of SQL Server, in the event of any performance loss or even configuring a new server for SQL Server you would need to assess the disk ...

As it sounds this is an interview question, but if you look at the logical level of nothing much changes. There are two major concerns using such way, Performance and Storage space. In this using fixed char fields can be queried faster than varchar fields. But there is a relative difference in fetching the results using with CHAR vs ...

Achieving the performance for slow running queries is not a rocket science to understand. The database performance is dependant on implementing optimum database design with sensible hardware-based configuration and capacity planning. So how you can identify where the performance is degraded, say when you desing it is easy to identify the large ...

You might be aware that now a days many high-end and high-spec disk subsystems provide high-speed cache facilities to reduce the latency of read and write operations. In general this cache is supported by a battery-power backup facility, which is necessary to maintain the data in cache in case of any power surge in hardware. But the implementation ...