If the estimated number of rows is high enough, then the query optimizer will judge that it's more efficient to scan the whole clustered index than it is do lookups...

Hi @John-Mitchell-245523

What are you telling is just that in brentozar's script represent incorrect the result and I can asure you both querys return 20354 rows. Both querys...

In each plan, the estimated number of rows is wildly different from the actual number, which makes me think either that your statistics are out of date, or that you've...

Yes.

John

Atulyan

Check in Services to see which ones are running under system accounts.  And remove NT AUTHORITY\SYSTEM from sysadmin so that this can't happen again.

John

On the mobile version, there's a Search button (picture of a magnifying glass) right at the top of the screen.

John

There's nothing in the original question that suggests that any rules of normalisation or anything else are being broken.  The question isn't about how you store the data, it's about...

Are you sure that is SQL Server code and not Oracle or some other RDBMS?  This is a SQL Server site, so you're likely to get better help somewhere else.

John

Use STRING_AGG.

John

I think if the CU is a higher number than the security update, then it'll include the security update.

John

Is it not as simple as changing the OUTER APPLY into a LEFT(?) JOIN and moving the WHERE predicates from the ANSWERS subquery to the join predicate?

John

Yes, either one big transactions or lots of little ones.  If it's lots of little ones then you can just back up your log more frequently, as I already suggested. ...

It means you need to back up your transaction log.  Maybe three hours isn't frequent enough.  Something between five minutes and one hour is the most common frequency I see...

Have you tried the default trace?  That should capture changes to logins.

John

I'd be very surprised if that weren't the case.  The idea of having a database in an availability group is so that it looks the same wherever it's running.  If...