You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based
Read More...
How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology
Read More...
On one of the archive database (using SQL 2005) we have a monthly task to shrink the transaction log during every 1st week of the month, this is required due to clear up the space on one of the drives where the additional transaction log file located
Read More...