Answer Posted / anil rajwadi

the task for database design is to structure in way that
eliminated unnecessary duptication and provide rapId path
search to all necessary information.the process of refining
table,column,key and relationship to create efficent
database is call normalization

What gets stored inside msdb database?

1248

---

What language is sql server written in?

1035

---

How to select all columns of all rows from a table with a select statement in ms sql server?

1115

---

Define union, union all, minus, intersect?

980

---

Can we linked SharePoint to a SQL database?

1029

---

What is the function of inner join?

1074

---

How can I tell if sql server is 32 or 64 bit?

966

---

Detail about query optimizer?

1108

---

What is check constraint in sql server?

1003

---

Write a sql query to delete duplicate records from a table called table1

1037

---

Does hive support indexing?

962

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

964

---

How can I check that whether automatic statistic update is enabled or not?

1042

---

What is a rownum?

978

---

How to install sql server 2005 express edition?

1123

---