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

Don't turn on auto-shrink, it's a bad idea.

If this is a server, then you probably want regular log backups to control the size of the log, and give you recovery...

Keep in mind that the order of rows returned is never guarenteed without an ORDER by clause. You should include that if you are looking for the first anything.

Chris,

You are welcome, and best of luck with that. I haven't met many people that didn't learn a lot from additional education. Even if it didn't directly help in their...

You'd want to run a trace/Profiler for permission changes while using the tool. The tool must be doing something. SQL Server never loses permissions or changes them itself. Some user...