Have you checked a trace on tempdb to see what's building up crud in there?

The problem you're running into is because the table violates third normal form. Assuming you can't do much about that, I'd say a calculated column will do what you...

B is probably your best bet with those drives. Hard drive arrangement is part of server optimization, but it's usually far less important than well-written code.

It can be a good thing to split data into current and older tables. I've used that idea a few times very successfully.

Log shipping is a way of keeping...

krypto69 (2/2/2009)

---

I think I can get a pretty good list of the kinda stuff they query the most,...

I don't think it's a problem with SQL Server. I think it's a problem with your network. Looks like something might be up with you DNS. I...

I'm not clear on what you're asking for. Can you expand on it?

You'd have to know before-hand what kind of stuff they query.

Is that a local account or a domain account? The error is saying it can't connect to the domain server to get credentials for the owner of the job....

In SQL 2005, unique constraints are enforced by an index, so there's no gain to that.

You might try MSDN for that. All the data is there, as published by Microsoft.

Luke L (2/2/2009)

---

Heh.. I still do the wood/axe/fire thing for heat. The price is right and the exercise is good too. Nothing like smacking a piece of wood...

tosscrosby (2/2/2009)

---

You should see the faces of the young-un's here...

This article has some data on that, and there's more in the discussion:

http://www.sqlservercentral.com/articles/Auditing/63248/

What I've done since then is work out an audit trigger that looks something like this:

create trigger dbo.MyTable_Audit...

One thing you could do is post specific stored procedures on this forum, and ask for help with them. Make it clear in the post that you're new to...