OK, here are a few suggestions.

Run profiler overnight and filter so that you'll only catch this sp.

Recompile the stored procedure if you haven't already. (sp_recompile) or mark if for recompile...

What happens in you run the DTS package from DTS designer?

Does the stored proc have any params that could have different values?

Can you change the job so it calls the...

You can put an IF EXISTS around the drop constraint, just as you did for the drop table.

IF

exists

Thanks. That's great.

The windows resource kit may not be possible. My server is an IA-64 machine. I don't know if there is a resource kit for it.

The perfinfo is very...

Also note that if you truncate the transaction log, you will not be able to restore the database fully after a failure. Without an unbroken set of tran log backups,...

3 hours, 30 -40 questions (can't remember exactly) Pass mark is around 75%.

No reference materials of any kind are allowed. You don't have books online or web access and you...

One minor correction, a row size can be a limitation and since, for char and varchar, 1 character=1 byte can be measured in characters. SQL rows have a max size...

The where clause is executed before the aliases in the select are resolved. The only place (in a simple select) that you can use an alias defined in the select...

Switch traceflag 1204 on on the server and whenever SQL encounters a deadlock it will write a deadlock graph into the error log. that can help you track down the...

There's probably a simpler way, but this will work

SELECT CASE IsPage WHEN 1 THEN 'Page'

 ELSE CASE IsFolder WHEN 1 THEN 'Folder'

   ELSE CASE ISMenu WHEN 1 THEN 'Menu'

    ELSE...

SQL does not keep any form of rowid or insert time that you can use to pick up frst or last inserted record.

If you want to be able to get...

It should be doable as a table constraint

Something like something like (ColA IS NULL AND ColB IS NULL) OR (ColA IS NOT NULL AND ColB IS NOT NULL)

These are the RSS feeds that I watch. Note that my job is SQL performance tuning and optimisation, so some of these might be a much lower level than you're...

Is this comp sci homework?

I'd suggest a cursor (forward_only, read_only) over the instructors and use a select statement for each to build up the list of courses. Something like

SELECT...

I would suggest NOLOCK as a last resort. Look at optimising your select as much as possible to get it running faster, also look at optimising the update. Firstly you...