Depending who you ask it's anything from 0.25 files/core to 1 file/core. But that's just the optimum...

The Row_Number function is not the same as the RowID that Oracle...

Yes?...

Can you repost that deadlock graph so that it's readable please. Either attach the xml file that profiler produces or use traceflag 1222 and post the output of that.

The one...

amitsingh308 (1/19/2010)

---

But I know in Oracle n mysql provides an Id for each row so that I was just conforming is there any thing like that is sql...

I don't understand what you're asking. Adding another column to an index to make it wider/covering has absolutely nothing to do with where in the files the indexes are stored....

Bhuvnesh (1/19/2010)

---

The query optimizer for SQL Server 2005 is suggesting that we include a primary key as part of a nonclustered index. Is it OK to include that to increase...

Don't play with the CPU affinity unless you have a really good reason. In most cases it should be left at default.

The number of data files is not linked to...

SQL Server does not have a 'row ID' assigned to each row by the DB engine. Oracle may (I think), but SQL doesn't.

What problem are you trying to solve...

Is there a question here, or is this an observation?

You can always reference a column from an outer table within a subquery. It may look odd, but it is valid...

From what I recall from SQL 2000, you cannot assign the results of a FOR XML query to a variable.

select session_id, blocking_session_id from sys.dm_exec_requests

That's good to know. Can you change the isolation level in the linq? If you do, does it fix the deadlocks?

Your first index is covering. That means that all SQL has to do to completely satisfy the query is to do an index seek.

The second index is not covering. To...

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/