I hate "where 1=0" - I ..use  "where...

Table value functions have quite a few restrictions and can certainly affect performance if used incorrectly.

you could try using a table value parameter instead of @table, but you would have...

Each solution has it's advantages.

I personally use transactional replication as it's usually only 3 or 4 seconds latency and both copies of the data are queryable. Plus you can filter...

easy

exec sp_msforeachdb ' SELECT TOP 1 * FROM ?.dbo.sysindexes ORDER BY rowcount desc'

if you really want , you could stick an inner join on ?.dbo.sysobjects into it, so that you...

• This reply was modified 6 years, 12 months ago by MVDBA (Mike Vessey).
• This reply was modified 6 years, 12 months ago by MVDBA (Mike Vessey).

try this

https://blog.sqlauthority.com/2018/08/06/sql-server-unable-to-load-user-specified-certificate-cert-hashsha1-thumbprint-here-the-server-will-not-accept-a-connection/

looks like a simple registry change

If there are no Foreign keys then all of the bullet points you listed will be true.

was the database created by some form of "code first" method where the application...

I came across a stored procedure recently where there were 2 developers clearly arguing

we didn't have source control for sql at the time of the argument (way before I started)...

There is another slightly ugly way of doing it (I just hate triggers so I find stupid ways of getting round them)

aside from baking the logic of  the count into...

This reminds me of my studies of normalisation.. one of the rules of normalisation is that you should not design your database to accomodate any specific query pattern..

But...

I work in a company with over 800 employees. we have well over 50 developers.  
Our company takes a slightly novel approach to apprentices.

In the UK we...

For me, it was the day after weeks of trying to make service broker, NoSQL and a petabyte sql server system deliver a system that exceeded everything our internal customers...

This reminds me of a conversation in a nightclub about 20 years ago
… a group of girls approached us and asked what we did for a living... unfortunately...

is it possible that the login used in your linked server is the owner of the database that you are seeing ?