Question is good, but why would someone use a join with different collations?

Jay Paolucci-371454 (7/22/2014)

---

Here is a simplified example of what I'm trying to do. It uses the where filter that I've been trying to get to work:

select [Measures].[Is Exited] on 0,

([Facility].[Close...

Post your query, so someone may help you easier.

cmoy (7/20/2014)

---

so I have a time series table consisting of 3 columns: a key, a timestamp and a value. The primary key is of course on the key and...

Jeff Moden (7/16/2014)

---

Igor Micev (7/14/2014)

---

--Extend this index to make it coverable for the query:

CREATE UNIQUE NONCLUSTERED INDEX [UIX_did_uid_sid] ON [Dim].[UserDevice]

(

[DeviceID] ASC,

[UserID] ASC,

[SubscriberID] ASC

)

INCLUDE(

Locale,[LastUsedDate]

)

--Create this index

CREATE UNIQUE NONCLUSTERED INDEX [UIX_NCSTransaction_IDs] ON...

Design has always been interesting.

My suggestion is to use integer primary keys with identity property.

Example:

create table dbo.HouseTypes(

Id int identity(1,1),

[Description] varchar(500)

--add more columns by require

)

alter table HouseTypes

add constraint [PK_HouseTypes] primary key(Id)

--create...

Igor Micev (7/15/2014)

---

New Born DBA (7/15/2014)

---

How often you think I should update...

New Born DBA (7/15/2014)

---

How often you think I should update statistics? Do...

New Born DBA (7/15/2014)

---

It seems that you have a clustered index on B270.C1. Do you? you didn't post the indexes and tables definitions.

You could probably reduce the logical reads by...

GilaMonster (7/9/2014)

---

Jack Corbett (7/9/2014)

---

1. Scaling - ORM tools still aren't very good at complex SQL (multiple joins, outer joins, etc...) so you need to evaluate every query that...

New Born DBA (7/14/2014)

---

Igor Micev (7/14/2014)

---

Include the Actual Execution Plan for the query and find the most costly node? Did you do that for the query?

We don't know what indexes...

Include the Actual Execution Plan for the query and find the most costly node? Did you do that for the query?

We don't know what indexes you have added, and what...

--Extend this index to make it coverable for the query:

CREATE UNIQUE NONCLUSTERED INDEX [UIX_did_uid_sid] ON [Dim].[UserDevice]

(

[DeviceID] ASC,

[UserID] ASC,

[SubscriberID] ASC

)

INCLUDE(

Locale,[LastUsedDate]

)

--Create this index

CREATE UNIQUE NONCLUSTERED INDEX [UIX_NCSTransaction_IDs] ON [Ext].[NCSTransaction]

(

[SubscriberID],[UserID],[DeviceID]

)

INCLUDE ([Locale],location,[TransactionStartDateTime])

If the "select"...

97% of the total query cost goes for Table scan and Sort, in the most right-upper part of the execution plan.

Can you additionally post the tables structure...

Check the account under which the job is running and check its permissions. I'd had cases when it had been an issue.