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 dmvs?

998

---

What are the triggers in sql?

1071

---

Does a sql server 2005 select statement require a from?

997

---

When would you prefer to have a minimum number of indexes?

879

---

What is difference between table aliases and column aliases? Do they affect performance?

949

---

What is BCP? When does it used in sql server 2012?

1042

---

What is difference between order by and group by?

987

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

980

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

978

---

Create and insert into temp table in sql server?

1006

---

What is b tree index?

899

---

What it means to be triggered?

961

---

Do you know what is difference between stored procedure and user defined function?

1080

---

How many categories of data types used by sql server?

999

---

What are various ways to enhance the ssrs report?

964

---