Answer Posted / dharmesh tandel

Differential Back: Only those files will be included which
have been changed since the last FULL backup.

http://www.orionsoftlab.com/backup/backup_anywhere.gif

Explain what is lock escalation?

766

---

Is the order of columns in the set clause important in ms sql server?

708

---

What are the different types of normalization?

809

---

How to optimize stored procedures in sql server?

833

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2032

---

---

What is sharding?

103

---

Explain how you can deploy an SSRS report?

122

---

Explain indexes disadvantages?

752

---

How can you append an identity column to a temporary table?

624

---

Explain cdc and sql injection?

718

---

Explain the concept of view and Types of views in SQL server?

774

---

What is query and its types?

684

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

732

---

What is collation sensitivity? Explain different types.

721

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

782

---