Viewing 15 posts - 4,171 through 4,185 (of 49,552 total)
Plug the external drive into the machine that has SQL on, restore to the external drive.
Hang on..
dat, messages, images??? Is this a SQL Server database you're restoring (because SQL databases...
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
November 29, 2015 at 8:58 am
When you restore a backup, it recreates the database exactly as it was at the time it was backed up. It's not the size of the backup that's going to...
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
November 29, 2015 at 8:35 am
Yeah, looks very much like the client tool aborted the query because it took too long (timeout). Nothing wrong with the query, it's just taking too long. See if you...
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
November 28, 2015 at 2:10 pm
The percentages in a plan are not times, they're estimated cost (emphasis *estimated*)
Can you post the plan and the table and index definitions?
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
November 27, 2015 at 1:50 am
Jonathan AC Roberts (11/26/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
November 27, 2015 at 1:43 am
Please post new questions in a new thread.
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
November 27, 2015 at 1:41 am
No, I said if there is no existing index on the Detail table on MasterID, create one on (MasterID, ID). If there is an existing one on MasterID, add 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
November 27, 2015 at 1:40 am
Considering that, unless the backup was taken WITH CHECKSUM, verify only checks the backup header, there's not that much point in doing so. Better to restore it elsewhere and checkDB...
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
November 27, 2015 at 1:39 am
Looking at those in isolation, you probably want an index on (MasterID, ID) on the detail table. Check the existing indexes, make sure there isn't an existing one on MasterID...
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
November 26, 2015 at 5:44 am
Ask the DBA for the code and the plans please. Without them there's minimal chance that we can help you.
Have you tried with recompile and is the overhead unacceptable? I've...
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
November 26, 2015 at 5:37 am
sam 55243 (11/26/2015)
If I do that in case will it prevent this issue from occurring.
Maybe. And maybe it'll make things worse.
Does the Recompile hint add an unacceptable CPU overhead to...
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
November 26, 2015 at 1:19 am
Yes, severely corrupted. Repair's not going to fix it. Only option here is restore from a clean backup or script, export and recreate the DB.
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
November 25, 2015 at 11:53 pm
Decent, consistent layout, meaningful aliases, useful variable names.
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
November 25, 2015 at 11:52 pm
Lynn Pettis (11/25/2015)
Help, I can't read and don't know how to attach a file... Sorry, some people are finding it easier to push my buttons today.
And if it's...
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
November 25, 2015 at 11:42 pm
Can you post the procedure along with the two execution plans (as .sqlplan files)?
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
November 25, 2015 at 11:40 pm
Viewing 15 posts - 4,171 through 4,185 (of 49,552 total)