Answer Posted / sri

Experience

What is meant by datasource?

521

---

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

539

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

644

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

571

---

What do you mean by acid?

578

---

---

How to join two tables in a single query in ms sql server?

542

---

What’s the distinction between dropping a info and taking a info offline?

598

---

What does executeupdate return?

541

---

What is the use of “join” in sql server?

574

---

What is the difference between composite index and covering index?

513

---

Write a SQL query to make a column as unique?

632

---

What is extent? Types of extents?

594

---

Mention a few common trace flags used with sql server?

544

---

Do you know the policy based administration feature of sql server 2008?

580

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

509

---