I have found that using the open query syntax has better performance than using 4 part name.

Hope that helps.

Tom Goltl

How big is the transaction log files for the actual database for each. I thought I read somewhere that 2000 uses tempdb more extensively than 7 did.

I'll try to...

When you change the owner all permissions on the object are lost. You might have to script them out before you run that sp.

Tom Goltl

Steve,

I don't think they can, and I offer one solution to why it shouldn't if it could. The whole point of clustering is to have a highly available server....

Which version of sql are you using?

Are you calling through QA or application when the violation occurs?

Generally when I have experienced exception violations is when a procedure is expecting parameters...

Is it tsql code. If so, you might be able to turn it into a stored procedure and then execute the stored proc through your dts.

Tom Goltl

We do use primarily all IP connections to the database.

I haven't reindexed for a while but the showcontig is not reporting extreme amounts of fragmentation.

I was using dbreindex to rebuild...

You hit it on the head. After much research and work we have concluded that this cannot be done. We're now trying to do it with an oracle...

This is also assuming that these are commited transactions in your log. If you are running a very large transaction, a database and/or transaction log backup will not effect...

Thanks for the links, but I've already looked at all of those.

We don't have AWE enabled. We don't have the auto shrink, but do use autogrow. ...

It's not in tempdb it is in one of my user db's. I figured out what I needed to do though. I found an undocumented sp on the...

I disagree with getting the biggest. The more access points you have to your ram the faster it will be.

ie: If you have 4 slots and want a...

If you have Sql Agent running, several of its processes have connections to Sqlserver running under the account that you specified at startup. You could look in sysprocesses table...

I too have used Sql Probe and did find that it really hurt performance on my machine. We run a compaq quad 700 with 2 gig ram. Not...

It sounds maybe like you have granted permissions to the public role. By default, everyone that has access to the database is defaulted to the public role. Hence...