What ahutchens says and check the configuration manager.

Yeah, but did you log in from a different machine to the server? The reason is, you need to confirm that it's allowing external connections.

ODBC works fine with instance names....

leea (2/28/2008)

---

Does the case not cause very similar performance problems, I remember having to rewrite an SP a little while ago to improve performance by removing the case from a...

Verify that you've got the names correct. Can you connect using management studio from a different machine?

GSquared (2/28/2008)

---

Good article.

One small quibble with it. In one of the examples, you use "((FullName1 = 'Ed Jones') OR (FullName1 IS NULL))", as an example of how to get...

What about using DATEDIFF on days where it equals zero?

Still, joining on something like this is going to be problematic. Most problematic of all, you're joining on columns that clearly...

You can even go into the tempdb and watch the tables being created. You don't need to worry about the users stepping on each other. You do need to make...

I'd try using a derived table with a BETWEEN clause to identify all those that are within the service period and then left join that back to the table again...

Dave (2/27/2008)

---

I concur, Matt, with both your points. It's been a long time (thankfully) since I've been subjected to Myers-Briggs or whatever the one with the quadrants is named....

The company I work for puts us through a variety of tests, either administered by HR or through classes with the managers. Unfortunately, I don't know them all. One...

I truly love the concept of Connect. When I first got introduced to it, early on working with Data Dude, I was all over it, constantly searching for bugs, voting,...

OK. Well, have you tried using a JOIN to put the data from the three tables together?

I could simply write the query for you, but this looks a bit like...

What have you tried so far?

I've never done this with perfmon, so I'll leave that to the experts.

Profiler is silly simple. You can create a stored proc that does everything you need. You can even...

Yeah, I've heard all those complaints. Then, we get a query that's running for 48 hours that somone finally brings over to us. We spend 3-4 hours on it and...