How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1945

---

If a stored procedure is taking a table data type, how it looks?

6351

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2320

---

What are statistics, under what circumstances they go out of date, how do you update them?

2195

---

What are the steps you will take to improve performance of a poor performing query?

2791

---

How to start SQL Server in minimal configuration mode?

7805

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2358

---

What is normalization? Explain different levels of normalization?

62691

---

Where would you look for errors from the database engine?

2791

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2397

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2275

---

Explain materialized views and how they are used.

2381

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1987

---

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

2514

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2527

---