without seeing the table structure or the data it is returning we will struggle to help

have you thought about using Row_number() over (partition by … order by …) as rn

add...

next you'll be telling us Santa Clause and unicorns don't exist

I hate "where 1=0" - I ..use  "where @debugmode=1" and pass that in as a parameter. the number of times one of my devs has hardcoded "where...

you could keep your existing clustered index on the publisher.

then set the article properties to not copy indexes. then create a post snapshot script that creates the clustered index to...

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

what type of maintenance plan?

are you just looking for backups ? RDS handles most of this in the background, as it does with patching

you can't really backup a database to...

Grant is 100% right

also front end developers in some cases build their child objects first, meaning they put "employee address" records into the database before they put the employee record...

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, 4 months ago by MVDBA (Mike Vessey).
• This reply was modified 6 years, 4 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...