Answer Posted / preeti singh

xp_Sendmail

What happens if strings are casted into wrong code pages in ms sql server?

1066

---

Explain about sql server login?

1029

---

Explain about SQL server 2005?

920

---

Explain indexing and what are the advantages of it?

964

---

Explain what are the database objects? : SQL Server Architecture

1006

---

How do you migrate data from mssql server to azure?

165

---

What is the recommended total size of your memory optimized tables?

912

---

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

304

---

Write a query to find 5th highest amount paid from the customer table.

881

---

List some case manipulation functions in sql?

968

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

986

---

Explain left outer join and right outer join?

973

---

How will you monitor replication latency in transactional replication? : sql server replication

1089

---

How to configure and test odbc dsn settings?

1100

---

What is row_number () and partition by in sql server?

1007

---