I just look at the table, it has 12 FK and 1 PK and 11 non unique non cluster index.

Yes I put in Option recompile and still ran a long time.

The table has 2357880092 number of records.

We purchase the software for our company and we cannot just update the database and create index.

The table is not partition and there is no index on date.

Thanks Alan it worked.

I guess I should say each row is fixed length based on the first 4 character.

Each row - the first 4 character is segment type, then next 3 character...

This is not a contract to hire position. I asked the employer if they will open a position.

They never have a SQL database developer here before, I...

I came up with this, not as good as Sean.

SELECT a.userid, u.NAME

FROM ( SELECT a.userid

FROM (SELECT u.*,

ROW_NUMBER() OVER(PARTITION BY u.userid ORDER BY u.colorid ) AS Row

FROM UserColor u ) a

INNER...

Here is the question.

I need to get the user who can access all the color.

That means the result is userid 3.

CREATE TABLE Color (colorid INT, NAME VARCHAR(100))

INSERT INTO Color(Colorid, Name)

SELECT...

I kind of figured it out too. More complicated.

SELECT a.userid

FROM (SELECT u.*,

ROW_NUMBER() OVER(PARTITION BY u.userid ORDER BY u.colorid ) AS Row

FROM UserColor u ) a

INNER JOIN (SELECT COUNT(*) cnt...

Please see

http://www.mssqltips.com/sqlservertip/1236/avoid-sql-server-functions-in-the-where-clause-for-performance/

LEFT() is a function it would result in an index scan where like '% %' would result in index seek which is more efficient.

I don't understand why there is such a big difference in salary when your MIS director thought BI specialist is much harder to get than SQL developer. :unsure:

I thought it supposed to be 300.

What number is good and what number is bad?

I don't understand the number meant. Can you explain?

Thanks

I used

select *

from @table

INNER JOIN table1

INNER JOIN table2

WHERE...