External Article

Manual cleanup Change Data Capture for a SQL Server database

  • Article

Kun Lee had a database where the log file kept growing and used 99.99% of the available space. He noticed miscellaneous change data capture objects still in the database as well as open transactions. This was causing his transaction log to continue to grow, but he couldn't disable CDC, because SQL Server thought it was not enabled. Read the full article to see his solution.


3,682 reads

Technical Article

RE: Update Using A Subqury

  • Reply

In the select statement I changed the table name where your retrieving the date.Thanks Again  UPDATE AE SET AE.count_fact = dtCounts.count_fact FROM #tmp_ar_exception AE INNER JOIN ( SELECT DISTINCT #tmp_ar_exception.dt_id, COUNT(F_AR_Detail.date_id) AS count_fact FROM #tmp_ar_exception LEFT OUTER JOIN F_AR_Detail ON #tmp_ar_exception.dt_id = F_AR_Detail.date_id GROUP BY #tmp_ar_exception.dt_id ) dtCounts on AE.dt_id = dtCounts.dt_id    


Technical Article

RE: Aye Yi Yi

  • Reply

Fair enough, Farrell.  I too am quite skeptical everytime I hear that 'the xyz worm caused a bazillion dollars worth of damage to the industry' or whenever I hear whatever the media 'caution du jor' happens to be.  I mean, I'm supposed to use plastic and duct tape to protect my house in the event […]



Daily Coping 2 Feb 2023


Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023


Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Why Managed Identities are Awesome


For the first workdays of this new year, I had the pleasurable task of...

Read the latest Blogs


The NULL Connection Setting

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The NULL Connection Setting

Nullable vs Non-Nullable Columns and Adding Not Null Without Downtime in PostgreSQL

By rohind

Comments posted to this topic are about the item Nullable vs Non-Nullable Columns and...

The Senior Advantage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Senior Advantage

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers