Thanks Grant..will try that..

Hi Experts,

Below are the original design and modifications recommended by us. Do i need to add anything or did i miss anything?

--Original Table design

CREATE TABLE ASC

(

[ASCID] UNIQUEIDENTIFIER NOT NULL,

[MuthalID] ...

Thanks Gail.

Thanks Gail.

its SORT operator and the cost is 0%.

ChrisM@Work (7/4/2014)

---

What you've shown of your view definition equates to this:

SELECT

urpx.RoleID

FROM [DBA].dbo.URPX

INNER JOIN [DBA].dbo.URX

ON urpx.RoleID = urx.RoleID

LEFT OUTER JOIN (

SELECT

urx.RoleID,

urx.UserID

FROM [DBA].dbo.URX

INNER...

Thanks Gail & Koen

Thanks Everyone for the input.

Thanks a lot Bill for that crisp and clear steps to be taken care. Thanks Again

Thanks a lot Gail.

Thanks Gail,

I have read that and its mentioned like someone have to manually give that. I dont think someone will call that from application.

Is there any other possibility??

Thanks Stuart & Grant

Hyperthreading is OS option and you can enable\disable it from BIOS.

In sql server you can set processor affinity,IO affinity ,worker threads etc.

Thanks Again Hanshi.

Thanks Hanshi,

I didnt find any to script out the current mail profiles & Accounts

Thanks Koen.