Answer Posted / mythili

select BillDate, count(*) from AdminSalesDetailsItems group by BillDate

Differentiate between mongodb vs. Sql server?

1035

---

Do you know query execution plan?

1079

---

How many tables can be joined in SQL Server?

1006

---

What are the advantages of partitioning?

1047

---

What is a scheduled job or what is a scheduled task?

915

---

Can you create a logon trigger in sql server 2005 express edition?

1032

---

Explain what is analysis service repository?

928

---

Explain the concepts and capabilities of sql server?

923

---

What is the difference between count and distinct count?

844

---

what authentication modes does sql server support? : Sql server database administration

1004

---

What is the difference between stored procedure and user defined functions?

1132

---

Do you know what are pages and extents? : SQL Server Architecture

944

---

Some queries related to SQL

937

---

What is a dbms wizard?

971

---

How to create a stored procedure with a statement block in ms sql server?

990

---