Viewing 15 posts - 466 through 480 (of 1,838 total)
Was there a reason you couldn't upgrade the development server to 2017? Typically you'd want to upgrade the development server before upgrading the production server so the system could be...
June 25, 2018 at 9:58 am
The following query is complaining about having no join predicate on a nested loop
EDIT:...
June 25, 2018 at 9:53 am
Since the sample data in the assignment question doesn't have a Parent Supplier ID for Supplier IDs 546 and 879 it will be impossible to produce the desired output. You...
June 22, 2018 at 10:59 am
June 22, 2018 at 8:20 am
June 21, 2018 at 6:51 am
Are the indexes re-created before or after the load of the data? If before, how is the data loaded and how many rows are loaded? Are the statistics in question...
June 20, 2018 at 2:27 pm
Offhand I see there are 3 expensive sorts on the WebImage table, all with the same WHERE clause and ORDER BY, would be much more efficient to just hit the...
June 20, 2018 at 2:16 pm
The picture is unreadable, even zoomed. It will be easier to help you if you give us the execution plan as a .sqlplan file (right click on the diagram in...
June 20, 2018 at 11:50 am
June 20, 2018 at 10:56 am
June 20, 2018 at 10:42 am
If I understand what you're saying, there may be a new setting on the statistics that you could use called PERSIST_SAMPLE_PERCENT:
https://blogs.msdn.microsoft.com/sql_server_team/persisting-statistics-sampling-rate/
June 20, 2018 at 10:38 am
June 19, 2018 at 3:16 pm
June 18, 2018 at 1:31 pm
June 18, 2018 at 10:38 am
Perhaps I missed that part, but as a former Access developer, I...
June 13, 2018 at 8:13 am
Viewing 15 posts - 466 through 480 (of 1,838 total)