It will be tough. There just arn't that many starting positions as a DBA. Lots of us came out it through other means, tech support, systems, or development (my own...

PASS does put on a Summit in Europe. It's not as big or as well advertised as the Summit in the US (usually in Seattle these days), but it's pretty...

Even if these query passed the parallelism threshold with such a small number of tables and a few rows, the splitting and marshalling of the streams would make the query...

You can simply run both queries within a single stored procedure and then deal with the multiple result sets on the client side.

I don't see any other options since the...

Sorry, one of the noisy 50 still making noise.

The PASS Summit is one of the best networking events I've ever seen. The way that the leaders in the community reach...

This is a huge topic. I'd suggest picking up a copy of my book (linked below). You could also start with reading Gail Shaw's articles over here at Simple-Talk[/url].

Yep. Those values in actual execution plans are also estimates. The values for rows, cpu, stuff like that in an actual plan are real values, but the operator costs are...

I'm not sure. I've never run into that particular error and there's very little documentation around it.

That's a very odd error. I did a search on the web and this was the best that I saw.

So I went over to MSDN and found something more useful....

Without a baseline on the old system, you can't possibly see if performance improved.

All you can do now is baseline the new system (baseline means collect a set of performance...

That's a fright all right.

I didn't even read through it all, but at the end I saw this and started laughing

ORDER BY Right([Queue_des_echantillons].[Noechantillon],5)

So much for using an index.

I absolutely recommend going to a file and then importing to the database. It's just cleaner and easier.

However, depending on the counters you're interested in, you can get them from...

endeavour (10/19/2009)

---

Thank you for the helpful replies it seems like the concensus is 'it depends'.

Rather than my describing a single theoretical context,

has anyone actualy hired a consultant to advise on...

Yes.

Even if you have talent in-house for tuning performance, you might need to bring in outside help if you're busy or, worst of all, when management doesn't trust that you're...

The cost values displayed in execution plans are estimates. Becaues of this, they won't always add up to 100% or they may add up to WAY over 100%. It's nothing...