2 votes

SQL Server 2017 transaction log does not shrink logfile after rebuild index

Not sure if you have an issue otherwise like Tibor mentions, but if your Log file grew as a result of your index maintenance process, and you have regularly scheduled index maintenance, then there's ...
user avatar
  • 24.2k
1 vote

Row_number to not increment if values on three columns are the same from the row before

Based on your description, what you want should be dense_rank() over (partition by orderid order by DocumentNo_, CurrentPackageTrackingNo)
user avatar
  • 475
1 vote

I need help with fixing this query please!

We can't help you without knowing your tables structures. What might be wrong, is either: You're joining on fields of two different types, eg. maybe patient_encounter.enc_id is a GUID and ...
user avatar
  • 308

Only top scored, non community-wiki answers of a minimum length are eligible