Answer Posted / mruganandam(guru) mca saranath

The some features of sql server 2005 are,

1.Database Mirroring
2.Online Restore
3.Online Indexing Operation
4.Fast Recovery
5.Standards based Information Access
6.Sql Server Information Access
7.Dedicated Administrator Connection
8.Snapshot Isolation(SI)
9.Data Partitioning
10.Replication Enhancements.
which are the top ten features of Database Administration
in Sql Server 2005.

What is table level trigger?

1026

---

Can sql server be linked with other servers like oracle?

967

---

How can you list all the columns in a database?

934

---

How to enter comments in transact-sql statements?

946

---

How to create a simple table to test triggers in ms sql server?

979

---

How many triggers you can have on a table?

997

---

What is indexing explain it with an example?

1014

---

What is the dbcc command and why is it used?

1053

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

1043

---

explain extended properties

994

---

What do you mean by tablesample?

1083

---

Is it ok to shrink transaction log?

1008

---

What is the log shipping?

1010

---

What is optimistic concurrency?

1039

---

What is the difference between migration and upgradation in sql server?

1099

---