Viewing 15 posts - 2,776 through 2,790 (of 22,214 total)
January 17, 2019 at 2:27 pm
January 17, 2019 at 2:25 pm
January 17, 2019 at 12:50 pm
Please, please, please, do not dog pile. However, you need to go and look at this execution plan. It's a doozy.
January 17, 2019 at 12:48 pm
One more thing, because you seem to be reusing views, the data is getting duplicated and move multiple times. Those views are the first candidates for loading into a temporary...
January 17, 2019 at 12:42 pm
Wow.
Well, I can see how a server had a problem. So, in the query, you have 10 objects. In the execution plan you have... more than 10. So,...
January 17, 2019 at 12:38 pm
Nope.
The only current "alternative" is to go to a Managed Instance. These allow for traditional three part naming to do cross database queries.
January 17, 2019 at 7:03 am
Ooh, that's very rare. I'd love to see the query and the execution plan from UAT.
In all likelihood, there are differences in settings between your UAT and production....
January 17, 2019 at 7:01 am
January 17, 2019 at 6:57 am
I'm not aware of a tool that does this.
One thing you can do though is to capture the trace, then use Distributed Replay to play it...
January 17, 2019 at 6:55 am
And if there was a very short way through this to make most servers run really fast most of the time, I wouldn't have had to write a 900 page...
January 17, 2019 at 6:44 am
poratips - Tuesday, January 15, 2019 8:42 PMThanks for pointing out GDPR and HIPAA, need to check that too
And the CPPA and...
January 16, 2019 at 6:45 am
Not sure the hospital would approve and he hasn't had alcohol in a...
January 16, 2019 at 6:44 am
I'd need to experiment to be sure, but I suspect that the account that SQL Server is running under can't access the blob storage. Focus on security.
January 16, 2019 at 6:17 am
In addition to moving the databases (backup and restore, unless you want to talk third party tooling) and configuring security (which you've received a lot of good advice around), one...
January 14, 2019 at 7:54 am
Viewing 15 posts - 2,776 through 2,790 (of 22,214 total)