Answer / suresh babu

We can create more number of indexes for a table.It required
separate memory space for each and every index.It will be
fast when using the search condition.

But if we are going to do some DML operations such as
insert,update,delete the server performance should reduce.

Answer / naren

it will allocate more space on disk.

Answer / guest

index reduce server preformance

Difference between report and query parameter.

0 Answers  

---

Tell me what is use of except clause? How it differs from not in clause?

0 Answers  

---

How many ways to create table-valued functions?

0 Answers  

---

Can we use where clause in union?

0 Answers  

---

How to maintain a fill factor in existing indexes?

0 Answers  

---

Why transaction is important?

0 Answers  

---

Explain partitioned view?

0 Answers  

---

explain different types of joins? : Sql server database administration

0 Answers  

---

What are the advantages of using stored procedures?

0 Answers  

---

How to find the version of sql server? : sql server database administration

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

---