Connection pooling, which Microsoft introduced in Open Database Connectivity (ODBC) 3.0, lets an ODBC application reuse a connection within the same shared environment (henv) without having to perform the complete connection process. In addition ...
Linked servers are a new feature in SQL Server 7.0 that lets you do distributed heterogeneous queries. (Distributed means on multiple machines and heterogeneous means different data sources. SQL Server 6.5 supported heterogeneous replication, but...
SQL Server Security Modes and SMS
You can set up SQL Server with one of three security modes: standard, integrated, or mixed. The method you use to enter the SQL Server login determines the security mode you use. But whichever security mode you u...
Blocking means that one query (Query1) is locking resources that another query (Query2) is waiting to use. Blocking can seriously affect response time and throughput. Response time measures how long it takes for a user who issues a query to get a...
