Viewing 15 posts - 151 through 165 (of 49,552 total)
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
July 6, 2018 at 12:49 pm
With that little information, it's very hard to give a useful answer.
The things that will determine the answer are whether you need referential integrity between the systems, whether...
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
July 6, 2018 at 12:15 pm
Can we rollback DDL statements as well (create, drop, alter,truncate etc...)????
As per my...
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
July 6, 2018 at 12:08 pm
Steve Jones - SSC Editor - Friday, July 6, 2018 9:33 AMCall Microsoft.
Don't bother. Customer support will recommend restore backup and...
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
July 6, 2018 at 11:58 am
Please note: 10 year old post, and your definition of recovery is incorrect. What you describe is a restore.
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
July 2, 2018 at 9:46 am
Could you post the queries and execution plans, the ones using the most CPU only.
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
June 9, 2018 at 9:15 am
From multiple previous experiences upgrading, it'll be a small number of queries that have degraded in performance. Identify them, and either rewrite or use a hint to get them 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
June 9, 2018 at 5:41 am
Yup, not repairable, and with no backups you're pretty limited in what you can do.
Try exporting the damaged tables in chunks, filter on the clustered index key. This...
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
June 6, 2018 at 1:34 pm
If there's millions of rows in a table variable, that's likely a problem. Try a temp table instead.
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
June 5, 2018 at 1:02 pm
There's two possible things that come to mind.
1) A backup log with norecovery
2) A backup log with no_truncate
1st if I need to leave 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
June 5, 2018 at 12:57 pm
That problem is one of pervasiveness. That is to say, it isn't.
And how many times does something have to happen before it is 'pervasive'? I'm done, I'm not...
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
April 27, 2018 at 5:25 pm
And forum ate my reply somehow, so you get the less diplomatic version.
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
April 27, 2018 at 2:25 pm
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
April 27, 2018 at 12:11 pm
I don't normally bite. It's not my job to do your research. (and besides, my doing so is unlikely to change your mind)
https://meta.stackoverflow.com/questions/309908/diminishing-numbers-of-women-in-programming-and-the-so-experience
https://meta.stackexchange.com/questions/30411/what-can-stack-overflow-do-to-persuade-female-programmers-to-participate-more
https://meta.stackoverflow.com/questions/281295/does-the-so-community-view-itself-as-gender-neutral/281304#281304
But...
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
April 27, 2018 at 11:44 am
Something like this would work better for multiple row updates. It's still not ideal, as you don't know when the change was made, and it will only work if 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
April 27, 2018 at 11:11 am
Viewing 15 posts - 151 through 165 (of 49,552 total)