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

1012

---

What are the constraints on severity level in raiseerror?

986

---

Why does this query return 0?

1015

---

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

1024

---

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

1106

---

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

1002

---

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?

1068

---

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?

969

---

How can I detect whether a given connection is blocked?

1054

---

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?

997

---

Explain the rollup operator?

1076

---

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

1015

---

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

1048

---

In how many ways you can invoke ssrs reports?

139

---

Explain the advantages and disadvantages of stored procedure?

1148

---