Viewing 15 posts - 1 through 15 (of 223 total)
July 28, 2017 at 7:09 am
I have subscribed to https://blogs.msdn.microsoft.com/sqlreleaseservices/feed/ and have this on my favourite https://portal.msrc.microsoft.com/en-US/security-guidance which i check manually. I do not trust WSUS for delivering patches for SQL server. You will have...
July 28, 2017 at 4:46 am
July 26, 2017 at 10:16 am
This looks like the same issue as this:
https://support.microsoft.com/en-gb/help/2688946/fix-error-message-when-you-install-sql-server-2012-the-identities-of-t
There is workaround mentioned in the link.
July 26, 2017 at 3:21 am
July 26, 2017 at 1:44 am
July 25, 2017 at 3:38 pm
ZZartin - Tuesday, July 25, 2017 11:07 AMYou could try adding technical_details_id to this index.CREATE NONCLUSTERED INDEX [IX_tbTechnical_Details_sp_ref_no_incl] ON [dbo].[tbTechnical_Details]
(
technical_details_id,
[spt_ref_no] ASC)
INCLUDE ( [mozart_ref_no]
)
technical_details_id is clustered index column, so it's part of...
July 25, 2017 at 11:30 am
the execution plan attached. The sort is still there. It is on the clustering key - technical_details_id.
July 25, 2017 at 10:52 am
July 25, 2017 at 8:32 am
July 20, 2017 at 12:57 pm
July 20, 2017 at 12:55 pm
July 20, 2017 at 11:51 am
One more thing that I don't understand is - if I remove the column UPPER
July 20, 2017 at 2:42 am
Thanks Guys for the advise and suggestion. I have raised it with the dev and app team.
bmg - without the DISTINCT, it takes 1 min and 32 secs.
July 19, 2017 at 12:14 pm
Viewing 15 posts - 1 through 15 (of 223 total)