SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties -> Port number, both on client and the server.
Subscribe to:
Post Comments (Atom)
SQL Server 2008 (IT version) is a new and latest experience by myself. I connect it through my Dynamics AX. i feel it much faster (Data fetching) than SQL Server 2005.I faced some questions in interview Board regarding SQL server. Those Qusetion & Ansewers I am publishing in this blog with the Reference : Pinal Dave (http://blog.SQLAuthority.com). These answers I took from several sites as well as Pinal Dave's site for my knowledge development and I also share with you... Rajdip Das.
Original Site: Pinal Dave's
Blog Archive
-
▼
2008
(25)
-
▼
September
(25)
- What is PIVOT and UNPIVOT?
- How to rebuild Master Databse?
- What is CLR?
- Which are new data types introduced in SQL SERVER ...
- What is MERGE Statement?
- What is CTE?
- What does TOP Operator Do?
- What is Replication and Database Mirroring?
- Where SQL server user names and passwords are stor...
- How to implement one-to-one, one-to-many and many-...
- What is BCP? When does it used?
- Can SQL Servers linked to other servers like Oracle?
- How to get @@ERROR and @@ROWCOUNT at the same time?
- What is SQL Server Agent?
- What is SQL Profiler?
- What is OLTP (Online Transaction Processing)?
- What are the difference between clustered and a no...
- Which TCP/IP port does SQL Server run on? How can ...
- What is DataWarehousing?
- What are different Types of Join?
- What is Cursor?
- What is a Linked Server?
- What is De-normalization?
- What is RDBMS?
- Overview of SQL Server 2008
-
▼
September
(25)
No comments:
Post a Comment