Change Data Capture - SQL Server 2008
Change Data Capture (CDC) records DML operations performed on SQL tables and makes records available with information regarding what changed and when the change happened in a simple way.
2013-06-24
6,963 reads
cdc.fn_cdc_get_all_changes
RE: How to speed up DELETE queries on MSSQL v7.0?
Hello,1) retailmemberid is INT data type, 4 in length2) the complexity involves other table relationships, which perhaps explains the delay; the delete perhaps has to ensure that records in the relationship tables are deleted (I am not sure, definitively)3) retailmember is a table, not a view; it has 78 columns (!), and it has at […]
2004-01-16
RE: Removing Time from Date
But anyhow! Yukon, once available, will have (Endlich!) a separate date and time datatype. Bye Gabor
2003-12-30
2 reads
RE: QOD 12/17/03
You' right! And also feel sorry for the people that missed out on those two points... okay, mostly because it would be my first two points!
2003-12-16
RE: SQL tool-- Patrol for MS SQL
We also use Patrol, and just like Steve mentioned, it is great for getting to the performance counter data and automating actions for exceeded thresholds. I have not seen where you can report on memory usage per database, but you might want to check out the BMC DB-XRay product. It is has been greatly improved, […]
2003-12-16
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers