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 is 2nf normalization?

1087

---

What is a deadlock and what is a live lock?

1040

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

1088

---

what is the difference between a primary key and a unique key? : Sql server database administration

1041

---

What is sql server replication? : sql server replication

1037

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1183

---

Write the SQL query to drop, truncate and delete table.

1026

---

What are the instances when triggers are appropriate?

1019

---

How to add an address record into adventureworkslt?

1027

---

What part does database design plays a role in performance of an sql server-based application?

1032

---

How to check if a table is being used in sql server?

1007

---

What are statistics?

1050

---

What is difference between views and stored procedures?

1028

---

What are the dis_advantages of stored procedures, triggers, indexes?

2273

---

If the job running very slow what is the action you do

1942

---