I think what you want is a way of paging, but it's confusing because sometimes you're saying values and sometimes rows.

You also need to decide if there is some order,...

I haven't been able to figure this one out. What's worse is that SPs seem to want to unpack to the c: drive as well.

The MS Press book I got (blue) was pre-release, and had lots of errors.

Honestly I think most of these books cover 80-90% the same material, and they'll work for you....

How is Agent configured, and how is the owner configured? PS has it right in that this is a permissions issue.

Like Lynn, I'd question that requirement. I'm not sure I can think of a good reason someone would want this done.

Get some reasoning and perhaps we have other advice or...

I would drop and recreate log shipping. Make sure you are a sysadmin when doing it, and make sure you server is correctly registered in sysservers.

Don't shrink. Manage your space, make sure you have enough free space to handle operations, and leave it at that. Shrink is for emergencies, not maintenance.

Also, the checks should happen...

I will second Lynn's answers. We are happy to help, but we are not here to do your job, or answer questions you haven't done any work on.

I'd prefer it...

Note that you do this in anyone's profile as well, top pane, lower right.

Also, MAXDOP is based on the CPUs/cores, not files.

Check the white paper, but definitely move the files to their own LUNs. That will let you better troubleshoot where the issues are.

What about a hybrid GUID/sequential system? It is easy to generate a GUID on the client, let the GUID move to the database and then when it's inserted into a...

I typically only close duplicates or runaway, offensive threads.

We want to encourage discussion, and just because someone gives you an answer that works for you, doesn't mean it's a good,...

I'll admit I had to back up the video and listen again. It surprised me.

You can watch it here: http://www.youtube.com/watch?v=NWHfY_lvKIQ

Off topic, but since we're talking slow, I saw a talk Joel Spolsky gave to Google about StackOverflow. He said they went on a C#/SS2K8 platform. He joked about search...