9,802 reputation
12146
bio website careers.stackoverflow.com/cv/…
location Iasi, Romania
age 34
visits member for 4 years, 2 months
seen 5 hours ago

Development DBA for a medium sized project team. Part of a 3 DBAs team and working in close touch with about 30 developers.

I'm here to learn from the best and share my knowledge. Proud and happy to be a part of such a great community.

You can find me here:


Mar
11
answered Dropping multiple foreign keys of unknown name
Mar
11
reviewed Close I am trying to loop through my counter to create a dynamic sql query which should finally look like
Mar
11
reviewed Reopen Converting hstore keys into columns in postrges
Feb
26
reviewed Close restore mysql 5.0.77 backup to mysql 5.5
Feb
23
awarded  Enlightened
Feb
23
awarded  Nice Answer
Feb
23
awarded  Nice Answer
Feb
19
reviewed Leave Open SQL Server Management Studio with Multi subnet HADR cluster
Feb
19
reviewed Close Mysql query giving incorrect values
Feb
19
reviewed Close What are the ways to handle temp table with more than 9000 rows?
Feb
16
reviewed Leave Closed ER diagram to tables
Feb
16
reviewed Reopen Who is depends on specific column?
Feb
16
reviewed Close Select a range of values
Feb
4
reviewed No Action Needed How to set up an SQL Server authentication login for a database instead of using Windows Authentication
Jan
24
reviewed Approve Report Builder cannot publish to report server
Jan
17
reviewed Approve Find clients who bought more than 1 million units in 3 consecutive months
Jan
13
reviewed Reject How to use a subquery that returns multiple rows?
Jan
13
awarded  Yearling
Dec
24
comment Run CDC Cleanup job at specified time
That's the info you can find in the table cdc_jobs in the msdb database - column retention. The default value is 4320 - expressed in minutes = 3 days. Change this value to a value like 129600 (90 days) or something that suits you more.
Dec
23
answered Run CDC Cleanup job at specified time