Yeah but when you run two queries each shows a relative cost to the execution as a whole. Usually the speedier, lower cost, process shows as a smaller percentage of...

Can you show the execution plan for this query? Output it as XML and attach it to a post.

You may want to look at SSIS as a mechanism for moving...

That error could be a lot of things:

http://support.microsoft.com/kb/180843

http://support.microsoft.com/kb/304070

There are more. You'll need to investigate more on your end and send more information around the error to narrow it down.

The whole idea of using SQL Server as relational storage engine is to not store things in a comma seperated field. You're going to have problems with that. Instead it...

But to be utterly honest here, simply reeling off a few buzz words about what's new in SQL 2005 won't get you very far in an interview around most of...

You have to declare the data type when you create the procedure, so you should know what data type you're returning.

Or are you asking how to know what data types...

That is a bit odd. Usually there's a pretty direct correlation between cost & time. Also, looking at the two queries, I would expect the second query to have a...

While you fixed your problem, you still have another one lurking. You have an index on a column that has 30,000 identical values out of a 100,000 row table. That...

For some reason I thought it was Client Technology Preview, but Community makes more sense.

It was just one of the solutions he offered. It was only the second solution and it ran faster than his initial solution. He did spend a lot of time...

I hate to say it, at this point, I'm confused. I'd have to see structure & some data to better understand what you're trying to do and what's going wrong....

It sounds like a paging problem.

One, of many, solutions that Itzik Ben-Gan offers in TSQL Querying:

--sets up data this way:

SELECT ROW_NUMBER() OVER(ORDER BY qty,empid) AS rownum,

empid,mgrid,qty

INTO #SALESRN

FROM dbo.Table;

CREATE UNIQUE CLUSTERED...

The MAX statement isn't working now?

Thanks. I'll check it out.

This thing jumped the topic track about 5 or six pages ago.

Just to put it back near the topic for a moment...

When being interviewed, how many...

No, I mean get rid of the sub-select entirely. Why would you need it? If the name is in the consultant table then you should be able to pull it...