Consider this scenario: - You want to migrate your current database solution to SQL Server 2008 - You want to make the maximum use of multiprocessing and multithreading - You want to know about how SQL Server 2008 makes use of multiple processors ...

...you should first check these factors: o The SQL Server service might not be started. o The network protocols allowed might have benn disabled. o The network configuration of windows might be incorrect: - Try to ping the SQL Server using...

The question most people ask is why someone who is local administrator of a machine where SQL Server is installed, they automatically have administartive access to SQL Server? The answer is: "due to the BUILTIN\administrators login". By default when...

When setting up your SQL Server you are given the option to choose the Authentication Mode. The modes are: o Windows Authentication: With this option whenever a user tries to connect to SQL Server he has to use a Windows user account. The SQL Server...

Replication over a slow network can be a real problem. There are however some actions you can perform to improve replication performance over a slow network: - Make sure the retention of the replication is low (usually 72 hours or less will be fine...

Some key points to consider for Database Mirroring in SQL Server 2008 are: - The database that will be mirrored must be in the Full Recovery Model. - Both the Principal and Mirror instances must be of the same edition e.g. both are Enterprise edition...