I think that you get what you pay for. For most 4x4 and smaller machines, it's a retail, commodity purchase. If you are large enough and purchase in bulk...

It's hard to stay in the top 5-10 here since you get points for questions. It seems that we'll have a few people every month answering 500 questions and jumping...

Grant,

You're always welcome to come speak (and ski) at the user group meetings. We have 3 in the same week, consecutive nights. Lynn's in the Springs.

I believe that sys.objects has all objects, but your best bet might be to bookmark the page on MSDN that lists all tables.

A database snapshot is not like a SAN snapshot. Once the SAN snaps the disks, a complete, and separate copy is available on separate disks. That takes advantage of the...

You always want to pass in the data at the lowest level. I assume that you have indexed the mid and pid in the middle table, you'd use those for...

Sorry, I didn't run that script. I didn't have time to dig through it last night before trying it. I've got a more testable instance now and I'll try it...

Typically you separate out heavily used indexes from the tables, not necessarily all indexes. Or you move data from a heavily accessed table.

That being said, are you not getting anything...

You'd have to provide more details, and likely log things from the package.

Was the destination empty?

What was the transfer method? Any dups? Any PKs issues? continue on error? batch size?...

You base indexes on the queries and joins that you need. Doesn't matter if they are in a stored procedure or not, you check the queries (SELECT, INSERT, UPDATE, DELETE)...

I'd be curious to know if anyone has tested this. It's one transaction v many, and I would tend to agree with Bob, but on anything less than hundreds or...

Either you are not allowing remote connections for some reason, or the connection string is wrong.

How are you coding the connection? Have you tried connecting from the Control Panel |...

I am seeing more and more questions about "all known issues" between 2000 and 2008. Tells me that MS should have spent more time on this upgrade.

Run the batch jobs with Windows auth, and set the password in the Windows scheduler, or other scheduler. That way the account running the batch has the rights.

Not sure. The HELP section for BOL seems to reference the get-help command.

http://msdn.microsoft.com/en-us/library/cc281954.aspx

The learning item references the Windows shell.

http://msdn.microsoft.com/en-us/library/cc281945.aspx