Can you post the query and which columns are indexed on which tables?

Could be a valid run time, or could not. Hard to tell.

Look in the plan for table scans,...

Indexes are updated automatically as data changes. You do not need to do anything here.

You should have auto-update statistics on.

Run dbcc checkdb (includes checktable) at least weekly to look...

I used to also keep a branch in VSS that shows what's being deployed at any point in time. So once you've decided what needs to move, branch (copy) that...

Typically you do not want 2 FKs to one table. I think there's a concern that this will create a loop with tableA referencing TableB, which references TableA for some...

Thanks for the feedback and I understand.

The podcast follows the editorial, so if you get the editorial, then you have an idea of the subject.

What other data are you putting in these tables? It might be that they should be the same table?

You shouldn't need the FK if this is a 1:1 as mentioned...

There isn't another way, and the way to do it is script out the removes, the alter of the function, and the adding back of the constraints and put it...

The data is sorted in clustered index order, but this isn't the idea of SQL Server.

Are you thinking to edit data in SSMS? If so, you could move the clustered...

I'm with George. Nothing jumps out. The clocks shouldn't cause this, though you probably want them to get in synch. Could possibly be something there, but I'd think the job...

sp_helprevlogin is the procedure, but it's a 2005 one only now. They updated it. The original for 7/2000 is available in the script library here.

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31711/

Nice article, Tim!

It's probably a limitation of the forum software.

I tend to open the active threads and then pop all the interesting ones into new tabs. Then I go back through them...

You can also download Log Rescue from Red Gate (I work for them). It's free because they're no longer selling it (hard to make money from this product), but it...

My guess is that the endpoint owner got "orphaned" similar to how a user can be orphaned when you restore on a new server without the login.

Glad it's working!

Any of the direct to disk products have burned many people here in the past. I have not heard of issues from Litespeed, Red Gate Backup, or the third party...

Very strange. Is it only the Litespeed jobs?

I wouldn't think that Litespeed has anything to do with it. The only thing that would make sense would be a time adjustment...