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

I think that it's because a group used as a login, as in this case, doesn't need the user to be added.

FYI, with 2005, you ought to be using ALTER...

Now THAT put a smile on my face this morning. Apparently I'm not the only one that has bad days. I'll have to bring that up next week to Phil.

Well outside of conferences I go throw < a case of beer a year and 3-4 bottles of wine, but I will have a few tonight. Came home to a...