Answer Posted / visala

.mdf is extention of primary file,
.ndf is extention of secondary file,
.ldf is extention of log file,

sp_helpfile

Explain how many normalization forms?

968

---

Can we write ddl in trigger?

865

---

What is efficiency data?

904

---

What is simple indexing method?

970

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

993

---

What is the partitioning method?

973

---

What does top operator do?

963

---

How to check if stored procedure is running in sql server?

960

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

981

---

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

900

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1007

---

When you use @@error and try-catch?

983

---

Explain the disadvantages/limitation of the cursor?

915

---

What are types of storage modes? : sql server analysis services, ssas

985

---

What are the joins in sql server? : sql server database administration

962

---