Answer Posted / hari

in 2005--database mirroring,CLR Integarion,SIS,Data
paratition, xml datatype,Dynamic management views,Mirror
backup

What do you need to connect php to sql server?

1038

---

Determine when to use stored procedure to complete sql server tasks?

986

---

What does the update command do?

1050

---

Tell me what is fill factor?

907

---

How to handle error or exception in sql?

935

---

What are truncate options available in sql server? : sql server database administration

966

---

What is the difference between left and right outer join?

1016

---

State the difference between local and global temporary tables?

1048

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

850

---

What is the default server name for sql server?

1088

---

How would we use distinct statement? What is its use?

1022

---

List out the different types of locks available in sql server?

932

---

Is it possible to replicate data from sql server to oracle? : sql server replication

1034

---

How to bind a view to the schema of the underlying tables?

945

---

Do you know the isolation level that sql server support?

920

---