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

Steve nailed it. I said backup, but what I meant was escalation. That's how we handle it.

I also agree on getting a realistic time frame. It takes five minutes for...

Why is that we're always going to decide, on the flip of a coin, to swap out the database server so we need to not use any of the functionality...

I suspect he's suggesting that the "we don't need no stinking procedures" school is going to drive your database to extinction, not the other way around.

We use generated code in...