I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.

This should work

WITH ResourcesMissingALanguage AS

(SELECT res_id

FROM RESOURCES GROUP BY res_id HAVING COUNT(*) < (SELECT COUNT(*) FROM LANGUAGES)

)

SELECT Res_id, Lang_id FROM ResourcesMissingALanguage rml CROSS JOIN Languages l

WHERE NOT EXISTS (SELECT...

Table and indexes as their CREATE statements please, it makes things easier to read

In that case, I'd suggest you drop the table and go through the import/export wizard again and make sure that you get the import definition correct (select 'column names in...

To be honest, DTA's not that useful full stop. It's fine as a place to start, but it has a bad habit of over-recommending indexes and statistics, and you can't...

Could you perhaps post CREATE TABLE statements for each of the tables, and some sample data as INSERT statements?

Is the Res_id unique in the resources table?

Probably best if you keep this within the same thread, that way people can see everything that's already been discussed.

http://www.sqlservercentral.com/Forums/Topic1523529-391-1.aspx

sgt: have a read through this, see if it helps.

https://msdn.microsoft.com/en-us/library/ms175122.aspx

He's not. He's trying to get rid of a filegroup which is damaged (files missing) and for which there's no backup.

Cost is not in milliseconds. It's a unit-less number that is only useful for comparing with other costs. It's an amalgam of the CPU, IO, duration, memory, etc estimated by...

🙁

I haven't played much with filegroups in that state. Let me see if I can find someone who has.

Table definitions, index definitions, query and actual execution plan please.

Eric M Russell (10/19/2015)

---

GilaMonster (10/19/2015)

---

I've seen bad management result in a complete turnover of the entire development staff within 3 months. That is, no dev who was working there at...

I've seen bad management result in a complete turnover of the entire development staff within 3 months. That is, no dev who was working there at the start of the...