Rudy,

Have you tried to run a stored procedure in the master prefixed with sp_* and worked for you? if the stored procedure is accessing local objects to the database e.g....

Check execution plans of your query; if you find the estimated number of records way lower than the actual returned records, then that's sign of stats. Also, check the stats...

SQL 2005 has a default trace running in the background; you can find the trace in SQL logs directory. Look for event 46 or 146 (i think

Thanks Greg for bringing this to my attention. I didn't know that the article was under...

Try to create more files for the TEMPDB on more disks and use the SORT_IN_TEMPDB option.

Hope this would help

You can also use the Log Parser exe file. It's free download from microsoft and it has so many usages. You can also use it for the event viewer logs...

I totally agree, the correct answer should be no. 1. The comma at the end of the last field will generate syntax error message.