Answer / Krishan Kumar Goyal

An index is a data structure used by SQL databases to improve the performance of queries. It provides a way to quickly locate specific rows within a table without having to scan the entire table. An index contains one or more columns from a table and allows the database engine to find rows based on the values in those columns.

What is the new security features added in sql server 2016? : sql server security

1 Answers  

---

What are the commands used in DCL?

1 Answers  

---

What is table level trigger?

1 Answers  

---

What are the differences between char and varchar in ms sql server?

1 Answers  

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

1 Answers  

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

1 Answers  

---

Explain the commands in sql server?

1 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

What is ACID Property of Transaction?

10 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

Do you know what is rank function?

1 Answers  

---

Explain foreign key in sql server?

1 Answers  

---