Answer Posted / maanu

Enterprise manager is a tool which comes with SQL Server 2k
and from there you can manage all the aspects of the SQL
Server 2k. But in order to write queries and T-SQL you have
to use Query Analyzer.
SQL Server Management Studio is combination of both SQL
Server Enterprise Manager + Query Analyzer of SQL 2k.

Is BCNF better than 2NF & 3NF? Why?

1106

---

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

965

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

113

---

How to link tables in sql server?

976

---

Explain the Ways to improve the performance of a sql azure database?

84

---

Can you index views?

935

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1067

---

What are the differences between char and varchar in ms sql server?

1125

---

Explain temporary table vs table variable by using cursor alternative?

1055

---

How do I find the sql server version?

1081

---

How to retrieve field values using mssql_result()?

1420

---

User wants only to display only pdf as export option in report manager. How to achieve this?

269

---

How do you create an execution plan?

1008

---

What is a db view?

951

---

How to rebuild indexes with alter index ... Rebuild?

1185

---