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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy