Answer Posted / poornima k

create table &t_name(&f_name1 &datatype1);

Explain filtered indexes benefits?

1000

---

What is forward - only cursors / read only cursor?

1091

---

Tell me what is difference between view and materialized view?

938

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

978

---

What the different topologies in which replication can be configured?

1092

---

What is a trigger in sql server?

1176

---

Explain the commands in sql server?

1041

---

whats new about truncate in sql server 2008?

2502

---

What is a mutating table error and how can you get around it?

1051

---

How to connect to SQL Azure Database by using sqlcmd?

136

---

what stored procedure would you use to view lock information? : Sql server administration

976

---

Explain sql server authentication modes?

1134

---

How to modify the underlying query of an existing view?

991

---

Where in ms sql server is ’100’ equal to ‘0’?

1091

---

What is the difference between a "where" clause and a "having" clause?

1160

---