Ah, that makes sense. I guess my problem was in lumping the NOLOCK hint in with the locking hints. To be honest, I know that it is an...

You don't. You...

Both. I always believed that the optimizer could escalte the lock type or scope as needed regardless of hints. In retrospect, that would mean that the optimizer would...

First off, I've never had to move data from SQL Server 2005 to an AS400 system, but I have had to go between SQL Server 2005 and other non-SQL Server...

How is the location changing? Are you using package configuration files?

Good catch Jack. I didn't even notice that one.

More snow....

I agree, this is news to me. I'll have to admit that I've only found the need to use...

Keep in mind that hints are just that, hints. They tell the optimizer what it should do, but the optimizer still has the ability to choose what it thinks...

You have to manually shrink the files. This is usually not a good idea as the files tend to grow back to their previous size during normal processing, but...

Good question. I am not a network administrator so I don't know. I'd imagine that it is identical to moving it to the new ou. Isn't that...

papapumpy (1/5/2010)

---

Yes, indexing helps but reducing logical reads does not help performance. maybe a tiny bit

read some article about buffer hit ratio and data cache. physical reads is the one...

Thank you. It's not that we don't want to help. Each of us has our own jobs with our own work to do. So the more work...

This should be treated just like any other server move within your network. This is a network access issue, not a SQL Server one. As long as the...

John Rowan (1/5/2010)

---

Can you give an example of what Table X looks like, along with some sample data, and an example of how you want the finished Users table to...