Which data type cannot be used as a parameter in a udf?
In which database can extended stored procedures be added?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
How you can make a parameterized view?
Can an extended stored procedure be called from inside a user-defined function?
How long can an error message be in raiseerror function?
Write the fastest query to find out how many rows exist in a table?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
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?
Explain the cube operator?
How would you design a database for an online site, which would average a million hits a day?
What are the constraints on severity level in raiseerror?
Why does this query return 0?
Which four data types cannot be used as a return type from a user-defined function?
How can you log an error to the server event log from a stored procedure?