You should be able to attach them. SQL should be able to recreate the log files. Do you not have any db backps?

I hope this is not a production...

DBCC commands are T-SQL statements. Run them in your query tool of choice (management studio, query analyzer, sqlcmd, etc)

You can see the thread you're responding to. Scroll down below the reply box. The box is collapsed by default, but once you expand it (icon in top right of...

I can't seem to see the list of latest posts I've made. Maybe I'm missing it. I use that frequently when away from my work machine to follow up on...

I must've missed that MS session on wednesday. With only a couple of exceptions, I found the presentations to be good and relatively informative. The ones I didn't, I left...

Try this

select cast(Msg_ID as varchar(36)), count(*)

from AgentsStateChanges

group by cast(Msg_ID as varchar(36))

having count(*)>1

Update the table's statistics. Out of date stats can result in exactly the problem you describe. Index defrag doesn't update stat, an index rebuild will. Otherwise, run UPDATE STATISTICS [table...

Not in SQL 2005. You'll have to write the code somewhere. In a trigger, or in a procedure if all data modification is done through procedures.

I would recommend a trigger...

I don't think studio has perfmon on it

Performance monitor is a windows app, not a sql tool. All the windows OSs since windows 2000 (at least) has it.

There are other...

p.s. Use perfmon to see if it really is SQL Server. Task manager's memory reading is hard to understand.

Process(sqlsrvr.exe)/private bytes (What it has comitted)

Process(sqlsrvr.exe)/virtual bytes (virtual memory pool)

Process(sqlsrvr.exe)/working set (memory...

In addition, the index definitions would assist and, if possible, the xml query plan (link, not post, it will be huge)

How much memory do you have on your server?

What service pack of SQL 2005 do you have?

Have you set max and min server memory?

What else is running on the server?

Run...

SQL already automatically adds random numbers to temp table names. Adding your own will just make scripts more complex, nothing else.

Nolock will help with the shared locks, but will not...

Jay, I do apologise. This completely slipped my mind on the run up to PASS. I hope this makes up for the delay.

I don't normally recommend cursors, but this...

Select... into puts locks on some of the TempDB system pages until the select is finished. Try using Create Table... Insert into...

Post the entire code if you can. Maybe someone...