Premium Retail Services

Use this query to see what all is running on the DB and see where you might have lock conflicts SELECT SESSION_ID, START_TIME, BLOCKING_SESSION_ID,...

--Setup DB for ChangeTracking ALTER DATABASE [DatabaseName] SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 7 DAYS, AUTO_CLEANUP = ON); --Set Table ChangeTr...

SELECT ProdI.[MdmId] AS ProductItemMdmId ,ProdI.[Name] ,ProdI.[Upc] ,ProdI.[BrandId] ,ProdI.[Active] ,C.[MdmId] AS CountryMdmI...

SELECT SA.[MdmStoreId] , H.[Name] AS Holding , D.[Name] AS Division , B.[Name] AS Banner , SB.[Name] AS SubBanner FROM [StoreAssociation] SA ...