Answer Posted / vidit tyagi

select BillDate, count(*) from AdminSalesDetailsItems group
by convert(BillDate,varchar,101)

What is the definition for sql server 2000?

576

---

What is a natural primary key?

517

---

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

99

---

How to execute function in stored procedure sql server?

532

---

What are cursors and when they are useful?

570

---

---

What is user-defined inline table-valued function?

510

---

What is an active database?

587

---

Explain different types of index?

585

---

Difference between Inner vs outer joins?

527

---

How do I find the sql server database version?

521

---

Which tools are available to manage SQL Azure databases and servers?

93

---

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

2055

---

Why should we go for stored procedures? Why not direct queries?

566

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

490

---

How to integrate the ssrs reports in application?

531

---