Answer / guest

Indexes improve database performance by allowing faster retrieval of records.
Types of indexes:
• Clustered Index – Reorders table records for faster access.
• Non-Clustered Index – Stores index separately for faster lookups.
• Unique Index – Ensures all values in a column are unique.

What is #table in sql server?

0 Answers  

---

Security Question- SQL DBA exparts, need your help...

3 Answers  

---

How to create user messages with print statements in ms sql server?

0 Answers  

---

What is bcp? When does it used?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

---

Can primary key be a foreign key?

0 Answers  

---

Explain concepts of analysis services?

0 Answers  

---

Do you know query execution plan?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

---

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---