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 happens if null values are involved in datetime operations?

903

---

What is difference between group by and having?

908

---

Can we delete data from a view?

881

---

Why use view instead of a table?

880

---

Explain hostprotectionattribute in sql server 2005?

959

---

Which sql server is best?

953

---

Difference between report and query parameter. Why do we need different type of parameter?

904

---

Explain what you mean by 3 tier architecture.

1017

---

How do you clear a log file?

983

---

How many triggers are possible per table?

1038

---

Explain sql delete command?

1003

---

Explain how you can configure a running aggregate in SSRS?

155

---

What is database architecture? : SQL Server Architecture

974

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

893

---

How to find out the list schema name and table name for the database?

893

---