Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

Which TCP/IP port does SQL Server run on? How can it be changed?

SQL Server runs on port 1433. This is SQL Server's default port. It can be changed from the Network Utility TCP/IP properties.




Next 5 interview question(s)

1
Explain Transact-SQL optimization tips?
2
What is Foreign key?
3
How can a programmer enforce to use particular Index?
4
Explain the joins in SQL Server?
5
What is Index Tuning in SQL Server?