That's either one of two things, your statistics are out of date or, the estimated plan is far off from the actual. It does happen. Try updating your statistics (or...

Make sure you're using exactly the same parameters against exactly the same data set (always compare apples to apples).

Get the statistics IO for the set of queries and the...

That query lists the rows & columns & stuff for the tables in a db, but I think what the OP is asking for is a way to determine the...

to answer that, look at the execution plan.

It really depends on which tables you add, but adding anything can make the optimizer choose different options in its attempts at...

Just a point of detail... You can overflow the buffer even when capturing to file. It just takes a heck of lot more to do that since writing out to...

I agree with Jack. It's been my experience that you're better off loading external data into a temp table and then processing it with everything else. I also agree that...

Getting an estimated execution plan is no big deal. There's a button right there in the query window in Management Studio.

No, what you need is something more. The estimated plan...

There is a way to do this, but you need to be very careful about how you use it. I'd suggest, if possible, only running it against a test system...

It's not really possible to suggest solutions without understanding the problem. You have a query that is running too long. OK. You've got the basic information of duration, CPU and...

There's no way to pass a where clause and get an estimated row count that I'm aware of.

That said, if you get an estimated execution plan, you'll get an...

Can you show the column names too? We need to understand where Tidspunkt is coming from.

Just a guess, you're running against a SQL Server 2000 instance. This is the 2005 forum and the solution offered was one that works there.

If I understand the question, you mean that you have a proc, Y. Within that proc it makes a call to another proc X. Within the proc X you're attempting...

Nice article, Tom. Thanks for sharing that solution. I'm passing it on to our OpsMgr admin to see if he can use it.

Just the System Monitor counters is all I've ever had available. I use Operations Manager to collect those now, but you could just use Performance Monitor.