Answer Posted / virgilio

A covering index is when you run a Query and you use an
indexed field in you where Clause:

*--Primary Key Creates aclustered Index
Create table Students
(
Studentid int Primary Key not Null, *
StudentName Nvarchar(20) Null,
StudentLastName Nvarchar(20) Null
)

Se;ect * from Students where StudentID = 20

What are the restrictions applicable while creating views? : SQL Server Architecture

1031

---

What is difference between equi join and natural join?

1046

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1267

---

Why do you want to join software field as you have done your BE in Electronics?

2150

---

What are indexes in ms sql server?

1065

---

Write a SQL query to make a column as unique?

1045

---

How to create new table with "create table" statements?

1114

---

What is raiseerror? What is raiseerror?

1147

---

How do you open a cluster administrator?

1057

---

What are binary string data types in ms sql server?

1303

---

What are policy management terms?

987

---

How to create function without parameter in sql server?

1063

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1403

---

Explain how to maintain a fill factor in existing indexes?

997

---

What do you understand by the data quality services in sql server?

953

---