2009 - Page 10 of 55 - SQL Authority with Pinal Dave

A half-full compost bin with a red-handled fork, compost spread on the bed

CDC Cleanup and Capture Jobs: Keeping the Log and Change Tables Small

October 29, 2009

Change Data Capture, DBA, SQL Server Agent, Transaction Log

Keep CDC cleanup and capture jobs healthy by checking log reuse, job settings, retention, polling, and a stopped-job alert.

SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008

October 28, 2009

Pinal Dave

SQL Performance

SQL White Papers

Change Data Capture records changes without triggers or schema changes. Here are my notes on tuning the performance of Change Data Capture in SQL Server 2008.

SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’

October 27, 2009

Pinal Dave

SQL Tips and Tricks

SQL Index, SQL Scripts

ALTER INDEX with ENABLE fails with Incorrect syntax near ‘ENABLE’. To enable index after you disable it for a bulk load, you rebuild it instead.

SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True

October 26, 2009

Pinal Dave

Personal

SQLAuthority Author Visit

I reached Seattle a week before PASS 2009 and spent it in the Advanced T-SQL course by Itzik Ben-Gan, whose T-SQL books I have all read. A dream come true.