On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

565

---

Explain the cube operator?

601

---

How would you design a database for an online site, which would average a million hits a day?

576

---

What are the constraints on severity level in raiseerror?

582

---

Why does this query return 0?

623

---

Which four data types cannot be used as a return type from a user-defined function?

581

---

How can you log an error to the server event log from a stored procedure?

557

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

590

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

591

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

547

---

How can I detect whether a given connection is blocked?

581

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

576

---

Explain the rollup operator?

612

---

How many types of stored procedures are there in sql server?

558

---

What is the purpose of linked server configuration in sql server?

553

---