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

942

---

What are the constraints on severity level in raiseerror?

932

---

Why does this query return 0?

967

---

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

963

---

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

1029

---

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

947

---

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?

1000

---

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?

918

---

How can I detect whether a given connection is blocked?

980

---

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?

944

---

Explain the rollup operator?

991

---

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

956

---

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

995

---

In how many ways you can invoke ssrs reports?

132

---

Explain the advantages and disadvantages of stored procedure?

1077

---