Welcome to MSDN Blogs Sign in | Join | Help

June 2007 - Posts

NUMA Connection Affinity and Parallel Queries

The SQL Books Online states that using NUMA port affinity helps co-locate the resources used by the query (CPU, Memory, ….). This is true for serial plan execution but not completely the case for parallel query execution. You might assume that you can
Posted by psssql | 0 Comments
Filed under: ,

How to configure Database mirroring for use with ODBC applications?

If you have an ODBC application that is connecting to a mirrored database and if The application uses a connection string without a database name ( for e.g: dsn=ssistest;uid=ssistest;pwd=*********) The DSN is configured to use SQL authentication with
 
Page view tracker