Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility
Read More...
One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that
Read More...
I believe since Windows 2000 server days you can take advantage of Indexing Service that creates indexes of the contents and properties of all files on local and network drives in order to increase file searching speed. It's quite similar to "Find Fast"
Read More...
I have seen mounting questions asking on support for SQL Server 2005 on Vista & Windows 2008, what a surprise! As Windows Server 2008 (aka Longhorn) is still in CTP (BETA 3) stages it is hard to comment or confirm any sort of support arrangements
Read More...