Answer / Gajraj Mathur

"The default TCP/IP port assigned for SQL Server is 1433. This is the port number that clients will connect to when connecting to an instance of SQL Server using standard connection methods such as SQL Server Management Studio or ODBC/JDBC drivers.

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

---

Define the term DML, DDL and DTL?

1 Answers  

---

What is indexed view?

1 Answers  

---

Is it possible in sql table to have more than one foreign key?

1 Answers  

---

What is merge?

1 Answers  

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

1 Answers  

---

Explain index in sql server?

1 Answers  

---

What are different types of views?

1 Answers  

---

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

---

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1 Answers  

---

what type of index will get created after executing the above statement? : Sql server database administration

1 Answers  

---

How to include text values in sql statements?

1 Answers  

---