Check Index Fragmentation in a SQL Server If we run INSERT, UPDATE or DELETE queries frequently than we can see indexes on the particular table are fragmented. And the SQL query may run slower as they may choose the non-optimal execution plan. Below script can be used for checking how much percentages of an indexes gets fragmented on a database. so that we can rebuild or reorganise the indexes. SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName, ind.name AS IndexName, indexstats.index_type_desc AS IndexType, indexstats.avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats INNER JOIN sys.indexes ind ON ind.object_id = indexstats.object_id AND ind.index_id = indexstats.index_id WHERE indexstats.avg_fragmentation_in_percent > 10--You can specify the percent as you want AND ind.name is not null ORDER BY indexstats.avg_fragmentation_in_percent DESC

Mikro-ORM - Is there a way to populate deeply nested collections while always returning the parent collection with populateWhere?

Rajan

I have the below query. What I am trying to do is always populate sets but only populate stats if they exist for that user.

Currently only the sets that have a stats collection are being returned. What I want is all sets and then populate stats for that user.

My schema is basically the same for deck, set, and card in that they all have a collection of stats where one of those stats belong to a specific user. The catch is that a user may not have a stats for that entity.

My results:

{
  deck: {
    user: 1,
    stats: [{ id: 1 }, { id: 2 }],
    sets: [{id:1, stats: [{id:1, user: 1}]}],
    ...
  }
}

What I expect:

{
  deck: {
    user: 1,
    stats: [{ id: 1 }, { id: 2 }],
    sets: [{id:1, stats: [{id:1, user: 1}]}, {id:2, stats: []}],
    ...
  }
}

Query:

const deck = await req.entityManager.findOne(
  Deck,
  {
    user,
    id: deckId,
  },
  {
    populate: ['stats', 'sets.stats', 'sets.cards.stats'],
    populateWhere: {
      stats: { user },
      sets: {
        $or: [{ stats: { user } }, { stats: [] }],
        cards: { stats: { user } },
      },
    },
  },
);