Answer Posted / maskfriend

Normalize the data from the detabase.It reduces by the
normalisation rule like(there are 4 normalization rule and
BCNF)

What are the two modes of authentication in sql server?

518

---

Can you explain what are commit and rollback in sql?

485

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1465

---

What is the sql profiler?

539

---

Can we use where and having clause together?

506

---

---

Where are stored procedures in sql server?

564

---

How dts is used to extract, transform and consolidate data?

594

---

optimization techinques

2194

---

Ways to improve the performance of a SQL Azure Database?

103

---

How you can get a list of all the table constraints in a database?

511

---

Name 3 ways to get an accurate count of the number of records in a table?

569

---

What protocol does sql server use?

515

---

What are system databases into sql server (2005/2008) : sql server database administration

565

---

What is isnull() operator?

566

---

Explain transaction server explicit transaction?

502

---