Answer / Tushar Vishnoi

By default, SQL Server listens on TCP port 1433. You can change the port SQL Server uses by modifying the SQL Server Service configuration. Here's how to do it:

1. Open SQL Server Configuration Manager.
2. Right-click on your SQL Server instance in the left panel and select Properties.
3. Go to the TCP/IP Protocol tab.
4. In the IPAddress list, select the IP address that you want to modify.
5. In the TCP Dynamic Ports field, enter the new port number.
6. Click Apply and OK.

Explain log shipping?

1 Answers  

---

What happens if we shrink log file in sql server?

1 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

Are semicolons required at the end of sql statements in sql server 2005?

1 Answers  

---

how to delete duplicate rows from table

9 Answers   CSC,

---

What are the new data types are introduced in sql 2000?

1 Answers  

---

explain extended properties

1 Answers  

---

What is difference between Datepart() and Datename() in SqlServer?

1 Answers   Infosys,

---

What is difference between line feed ( ) and carriage return ( )?

1 Answers  

---

Does group by sort data?

1 Answers  

---

Tell me what is the order in which the sql query is executed?

1 Answers  

---

What is a rollup clause?

1 Answers  

---