Answer Posted / naveen

Each hardware can interact with the other with a specific
path dedicated for it during its installation. That path is
decided either by the processor or by manually.

For eg. consider the port where you install the mouse, or
consider even the keyboard port, etc.,

for any outsiders a specified path will be dedicated as
such. Even for the modem to communicate with the outside
world. For the server to compile and run the programs, it
needs one particular port that it maintains during its
service in that system. That port is mentioned manually of
our interest so that those server can run at that specified
port. So that the request and response will be under one
port. The servers will keep observing that port whether any
request has arrived, if so will send the response in the
same port.

How do you troubleshoot errors in a SQL Server Agent Job?

1038

---

How can we migrate from SQL server to SQL Azure?

113

---

Give a example to search fr a string in all stored procedure in sql server.

962

---

What is the correct order of the logical query processing phases?

917

---

What is the dbcc command and why is it used?

1030

---

List all types of constraints in sql server?

991

---

What is meant by Active-Passive and Active-Active clustering setup?

1143

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1116

---

explain the storage models of olap? : Sql server database administration

929

---

What do you mean by an execution plan?

1090

---

What is the difference between clustered and non-clustered indexes in ms sql server?

983

---

What are number line correlation administrators will use while working with a subquery?

1149

---

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1021

---

What is named calculation? : sql server analysis services, ssas

959

---

Explain what role entity and relationship play in an ER diagram.

1055

---