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...

There are lots of developers trying to use LINQ, though not necessarily just to SQL Server. You can use to to get to XML, and other data sources.

"practise" is the English spelling, where David is located. Practice, is the US spelling.

Personally, the more I teach my kids, the more I think English is a huge mess.

Trace the login event, Likely you will track down which application/machine is submitting the wrong credentials.

I think one big issue is that so many people are looking to share data and aggregate it in warehouses or reporting systems. How well does an OODBS allow the...

Interesting replies. I thought more people would go for scripting, but good to see them using maintenance plans.

The interest of the person, does make a difference, but I think I'd...