Taking the UPPER out only impoves it by a sec or two.

Thanks guys. We have already raised the concern about more duplicate values with the developers and the app team and also about not using where clause and selecting all columns.

If there's...

DROP is not a grantable permission.

Following roles allow you to drop a table:

dbo, schema owners, db_ddladmins, db_owner, sysadmin, people with CONTROL permission on the table, People...

Run this:

select * from MSdistribution_history
where xact_seqno = 0x00000000000000000000000000000000

This will give you the agent which is causing an issue. Drop the subscription for...

Thanks Joe. Already tried the inner joins. There was not much difference.
Thanks Gail- Running the update stats with full scan now. I'll try the query again after the scans...

Thanks Chris. This is awesome. It's pretty instant.

Thanks for the link as well. Added to my favourites.  🙂

You can use "sys.dm_db_index_usage_stats" to find out when the tables were last accessed.

Sarvesh

Hi, You can use "sys.dm_db_index_usage_stats" to get when the tables were last accessed.

great articles Perry. Have added to my favourites :-). Keep up the good work.

Thank you all for your feedback. It means a lot.

The purpose of this artcle was to show simple usage of DISTINCT to a beginner.

When will the course delivered in UK?

Thanks for the feedback Grant. Much appreciated. Will keep that in mind for my next article.