Answer Posted / mandar kavishwar

Indexes in databases are similar to indexes in books. In a
database,an index allows the database program to find data
in a table without
scanning the entire table.
There are two types of Index in MS-SQL.
1.Clustered
2.Non-Clustered
In MS-SQL Server 2005,
Only 1 Clustered & 249 Non-Clustered Possible.So (Total 250)
But in MS-SQL Server 2008,
Only 1 Clustered & 999 Non-Clustered Possible.(Total 1000)

What are the transaction properties?

1070

---

What are indexers?

1134

---

How much space does sql server 2016 take?

1033

---

Is sql server 2016 free?

981

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5977

---

Why olap is used?

1035

---

What is the use of group by clause?

993

---

List all types of constraints in sql server?

1094

---

What is function of master database?

116

---

explain the storage models of olap? : Sql server database administration

1015

---

How do I install sql server?

937

---

What is difference between rownum and row_number?

1024

---

Define full outer join in sql server joins?

1054

---

Disadvantages of the indexes?

1184

---

Explain linked server in sql?

1295

---