Answer / Devesh Singh

To hide SQL Server instances, you can configure SQL Server to listen on a dynamic port or use named pipes instead of TCP/IP. However, it is important to note that these methods are not recommended for production environments as they may cause connectivity issues.

Can a table have 2 primary keys?

1 Answers  

---

What are the main control-of-flow T-SQL constructs?

1 Answers  

---

What is full form of XP ?

42 Answers   Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

1 Answers  

---

What is use of except clause?

1 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1 Answers  

---

What is field in algebra?

1 Answers  

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1 Answers  

---

What is the use of nvl work?

1 Answers  

---

What is the new security features added in sql server 2014? : sql server security

1 Answers  

---

why would you use sql agent? : Sql server database administration

1 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1 Answers   HCL, Wipro,

---