Viewing 15 posts - 4,456 through 4,470 (of 49,552 total)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 8:06 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 7:59 am
GilaMonster (10/20/2015)
Table definitions, index definitions, query and actual execution plan please.
Table and indexes as their CREATE statements please, it makes things easier to read
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 7:53 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 7:51 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 7:49 am
Could you perhaps post CREATE TABLE statements for each of the tables, and some sample data as INSERT statements?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 7:39 am
Is the Res_id unique in the resources table?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 7:32 am
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 6:30 am
sgt: have a read through this, see if it helps.
https://msdn.microsoft.com/en-us/library/ms175122.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 5:20 am
Jayanth_Kurup (10/20/2015)
Not sure your trying to achieve a piecemeal restore
He's not. He's trying to get rid of a filegroup which is damaged (files missing) and for which there's no backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 5:00 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 4:20 am
🙁
I haven't played much with filegroups in that state. Let me see if I can find someone who has.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 2:56 am
Table definitions, index definitions, query and actual execution plan please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2015 at 2:43 am
Eric M Russell (10/19/2015)
GilaMonster (10/19/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2015 at 7:43 am
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2015 at 6:58 am
Viewing 15 posts - 4,456 through 4,470 (of 49,552 total)