Answer Posted / sk akbar ali

eXPerience

Explain log shipping?

587

---

How can you insert values in multiple rows using one Insert statement?

619

---

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

575

---

What is partition, how will you implement it? : sql server analysis services, ssas

604

---

What is subquery? Explain the properties of a subquery?

513

---

---

What is dbcc? Give few examples.

578

---

What is a ddl statement?

511

---

What are different types of subquery?

721

---

What are the tools available in market as an alternative to sql server reporting services?

88

---

How can change procedure in sql server?

524

---

What is the difference between push and pull subscription? : sql server replication

615

---

What is join and name different type of joins?

584

---

What is raiseerror? What is raiseerror?

646

---

Can primary key be a foreign key?

564

---

What stored procedure would you use to view lock information?

528

---