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

It can't possibly be caused simply by the number of rows. Inserting one row or one million, neither one changes the schema of the table. That procedure you're calling has...

You're trying to generate an estimated execution plan. You can't with the temp tables. Generate an actual execution plan instead, which means running the query, so make sure you're not...

The one thing I would absolutely demand is a backup. Make darn sure that you have a secondary oncall person. Otherwise, in theory, you can't go out & get groceries,...