Gila,

If that is the case and I am getting a filter on column 6, then why does the exection plan say

Index Seek -> Select

with no filter or any...

You are correct. I wouldn't do it. I was using it more as a simplified example that if I have queries that use all 6 column, but each...

So if I searched by column, 1, 2, 3, & 4, I could essentially create 4 indexes as follows and I should get seeks on all of them?

Column1, column2, column3,...

Man, for a bunch of guys who are getting something free, you guys are lazy and a little whiney.

My only question is how long are the session scheduled to...

Not that I am aware of or that is being recorded. Note that this happens almost immediately.

As soon as a ticket is updated, the queue goes off line and...

Smith,

Just a quick question. Is there a performance difference between using the

WHERE NOT that you are using and

where <> 'I' and <> 0

Thanks,

Fraggle

Please don't double post.

With that said, you can also use the

SET ROWCOUNT XXX

This affects the very next query in the process and will return the number of rows specified...

I would question why you are wanting to get count something without wanting to use the count(*) function. This is a standard function in the SQL language and is...

Well the good news is that the ORDER BY isn't the issue. The bad news is that the query is the issue.

Is should look like something similar to this,...

To me, CTE (Common Table Expressions) are best for recursion and running totals.

Fraggle

So really we are looking at

Product 1 Shop b ...

Alright, I do not have a complete understanding, but I am getting there.

you want to return a result set of

product 1 ...

From what I understand, you are actually wanting to sort, not by shop, but by Partneraantal. Is this correct? If so, then the issues is the ORDER BY...

The only thing worse than running Profiler on a production server for an extended period of time is running profiler on a different computer connecting to a instance of sql...

When you say that the ORDER BY statement doesn't work, are you stating that it is throwing up an error and that you are not able to execute the query,...