Not exactly the same thing, but Jonathan Kehayias showed how to query the Plan Cache for queries that use a specific index:

https://www.sqlskills.com/blogs/jonathan/finding-what-queries-in-the-plan-cache-use-a-specific-index/

It can be a good start..

You will get a better understanding of what this process waits on using sys.dm_os_waiting_tasks.

Is it showing another wait type there?

Hi,

I had success working with READPAST in a queue table. The important things are to REALLY be careful with the types of locks held and, make sure there is no...

Hi,

Please check on a test system, but I think it will be removed on the next SQL Server service restart.

Right click the job name and click Script Job As -> Create To -> New Query Window

In the created script, change the name of the job.

Then you'll be able to...

Hi,

Transactional Replication will not help you in this case.

Transactional Replication will move the data from the primary to the secondary, but not the other way around if the primary fails.

You'll...

If you mean that you want the captured data to be retained for 6 months, you can use the sp_cdc_change_job procedure to configure it:

https://msdn.microsoft.com/en-us/library/bb510748.aspx

Keep in mind that it...

CDC isn't supported in SQL Server Standard unfortunately:

https://msdn.microsoft.com/en-us/library/cc645993%28v=sql.110%29.aspx

You'll have to install SQL Server Enterprise edition in order to use it..

Glad to help 🙂

Perhaps this will help:

https://www.simple-talk.com/sql/t-sql-programming/time-slots---an-essential-extension-to-calendar-tables/

The generated snapshot will include only the replicated table.

However, the best way is to test it on a test system in order to be sure.

When does this happen?

Is it in the initialization phase or after replication has already started transferring data?

It depends on which cache you flush - the Plan Cahce, using DBCC FREEPROCCACHE, or the data cache using DBCC DROPCLEANBUFFERS.

You can check if most of the time goes on...

Hi,

That's correct..

You can use windows scheduler and run the backup using SQLCMD.