Question : As part of my data warehouse project, I’ll be transferring data from our OLTPs to the Data Warehouse. […]
Tag: change-tracking
Automatically detect table name in MSSQL Server database using stored function
Question : I’m working on implementing Change Data Tracking in a SQL Server database and I set up a single […]
Challenge to SELECT only new records that were added since the last SELECT [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Finding timestamp when index was created or reindexed
Question : Is there any way to find when an index was last created or reindexed in PostgreSQL 12-13? The […]
Is it possible to use Change Tracking on a Replication target?
Question : We have a setup where the production SQL Server databases are replicated to an offsite location using SQL […]
How to make sure change_tracking statistics stays updated
Question : I am using Microsoft SQL Server 2016 (SP2-GDR) (KB4505220) – 13.0.5101.9 (X64) Jun 15 2019 23:15:58 Copyright (c) […]
Is it possible to use Change Tracking on a Replication target?
Question : We have a setup where the production SQL Server databases are replicated to an offsite location using SQL […]
Detecting changes in a SQL Server table
Question : In my application, with a DB running on SQL Server 2012, I’ve got a job (scheduled task) that […]
Tracking changes to a table via the update/insert cmds executed against it daily
Question : We have an oracle database back end for our SAP ECC system. In it we have a table […]
Recommendation for synchronizing SQL Server DBs
Question : I have two databases, prod and dev. Each DB is about 500GB. At the end of each work […]