Answer Posted / andy

to move physical files to physical path.

What is difference between sql and sql server?

937

---

What happens if we shrink log file in sql server?

910

---

What is a fill factor?

1033

---

Which are ddl commands?

973

---

What is the default value of an integer data type in sql server 2005?

910

---

Explain filtered indexes?

932

---

Explain left outer join and right outer join?

972

---

What does it mean if @@cursor_row returns a negative number?

942

---

What is cross join in sql server joins?

1073

---

How to find related tables in sql server?

871

---

What is spatial and temporal data?

931

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

862

---

Define primary key?

1077

---

What is cached report?

135

---

How to enter comments in transact-sql statements?

893

---