Answer Posted / latha.s

select distinct * from tablename;

What to perform pattern match with the like operator?

861

---

How do I save a stored procedure in sql server?

969

---

Which trace flags are enabled in sql server?

988

---

Explain Reporting Life Cycle?

124

---

Do you know what is user defined datatypes and when you should go for them?

947

---

How do you improve the performance of a SQL Azure Database?

137

---

Can we take the full database backup in log shipping?

930

---

What is an execution plan?

1117

---

What is meant by dirty read?

976

---

What is the use of keyword with encryption. Create a store procedure with encryption?

944

---

How each E-R model constructs can be mapped to the relational model?

983

---

How to attach adventureworkslt physical files to the server?

1087

---

Define synonym?

1154

---

How to generate create procedure script on an existing stored procedure?

994

---

What is sql profiler. What are the default templates with it? : sql server database administration

1009

---