Please start a new thread and post your ERRORLOG

It has to scan the whole table to evaluate the LIKE predicate, so no, it can't be very fast.

Sorry, looking closer at BOL https://msdn.microsoft.com/en-us/library/ms152529(v=sql.105).aspx it looks like when a constraint is NOT FOR REPLICATION it is always not trusted. You can leave it as it is.

Then you simply cannot do that.

You sample data doesn't include it, you're missing an UNION ALL before it.

Is the constraint marked "NOT FOR REPLICATION"?

In this case I'm afraid you will have to recreate it to make it trusted.

Please post table scripts, sample data and expected output. Screenshot are not good enough: we cannot copy and paste code from your screenshots.

See http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ for guidance.

If deleting takes too long, simply create an empty database and migrate there just the data you need. Why do you think this is not a valid option?

SELECT [Text],

IsContains = CASE WHEN EXISTS (

SELECT *

FROM #Table2

WHERE Deliv LIKE '%' + [Text] + '%'

) THEN 'Yes' ELSE 'No' END

FROM #TableSol

Sending transaction logs via email is not going to work. Forget about that.

What I can suggest is setting up a merge publication on the server (I assume the data you...

You can encapsulate the call to DBCC LOGINFO into a stored procedure with EXECUTE AS.

Here's a guide on how to do that: http://sommarskog.se/grantperm.html

Sysadmins have access to all securable at server and database level and there is no DENY that can stop this. Simply put, no: sysadmins will always have access to everything.

It's not all about performance.

Heaps suffer from forwarded records[/url] and don't deal well with deletes.

If you see no significant difference between clustered index and heap, stick with a clustered index.

Granting sysadmin permissions to monitoring services is an established practice, exactly for this reason: they have to query data which is available only to sysadmins.

I don't know offhand any other way to do that, but it would need for sure sysadmin permissions. Checking VLFs is definitely a sysadmin task: why are you trying to...