cdc

How to create a very big bitmap in C++/MFC / GDI

I'd like to be able to create a large (say 20,000 x 20,000) pixel bitmap in a C++ MFC application, using a CDC derived class to write to the bitmap. I've tried using memory DCs as described in the MSDN docs, but these appear to be restricted to sizes compatible with the current display driver. I'm currently using a bitmap print driver ...

What is the difference between Oracle Streams and Change Data Capture?

There are several similar Oracle tecnologies - Oracle Streams, Oracle Change Data Capture and Database Change Notification. Do you know what is difference between those? Are they related or Oracle Advanced Queueing? ...

How do I turn OFF DML, ON DDL tracking in SQL Server 2008 Change Data Capture

Is there a way to turn OFF the DML tracking for SQL Server 2008 Change Data Capture? I'd like to only track all DDL statements. Thanks! ...

CDC text drawing issue

I'm trying to draw text using CDC::ExtTextOut() to a device context (CDC), but I'm getting garbage outputs. The output text was drawn is weird fonts. The CDC pointer that got passed to me was originated from a unicode build ActiveX control (.ocx). The text drawing code resides in an ANSI build DLL. It seems like there're some kind of ...

SQL Server 2008 Change Data Capture, who made the change?

I asked a question on SOF a week or so ago about auditing SQL data changes. The usual stuff about using triggers came up, there was also the mention of CDC in SQL Server 2008. I've been trying it out today and so far so good, the one thing I can't see it supports is keeping a track of who actually made the change. Who executed the stat...

How to create a large Compatible Memory DC in GDI programming?

I want to create a large CompatibleDC, draw a large image on it, then bitblt part of the image to other DC, in order to achieve high performance. I am using the following code to create compatible Memory DC. But when the rect becomes very large, etc: 5000*5000, the CompatibleDC created become unstable. sometimes it is OK, sometimes it f...

How to set up USB CDC drivers on Mac OS X?

I have a custom-built USB CDC device. If I plug it into a Windows box (2k, XP, Vista), up pops the Found New Hardware Wizard and I can point it at my .inf file, which supplies a mapping from the USB VID and PID to the USB driver (in this case the inbuilt usbser.sys). Then it appears as a virtual COM port and I can set up dial-up networki...

In SQL Server CDC with SSIS, which data should be stored for windowing (LSN or Date)?

I have implemented delta detection while loading data warehouse from transaction systems using an identity column or date-time column in source transaction tables. When data needs to be extracted next time, the maximum date-time value extracted last time is used in the filter of extraction query to identify new or changed records. This w...

What does LSN mean in SQL Server?

What is the meaning of Log Sequence Number? I know that it is of type binary and 10bytes long and it corresponds to the time the transaction happen in DB. But is this a high precision date-time value that is stored in some efficient binary format or is this a function of date-time and something else (for example the serial number of tran...

Does MemoryDC occupied memory or the memory on video card?

I am using the following code to create a compatible DC: m_pDC=new CDC(); VERIFY(m_pDC->CreateCompatibleDC(sampleDC); CBitmap bitmap; if (bitmap.CreateCompatibleBitmap(sampleDC, rect.Width(), rect.Height())) { m_pOldBitmap = m_pDC->SelectObject(&bitmap); } My question is does CDC CBitmap occupied memory ? If it is using memory, wh...

How can I get an HDC object from a CDC object?

I have an object, dc, of type CDC and I'd like to get an HDC object. I read the MSDN documentation here, but don't really understand it. Can someone provide me with a brief example/explanation on how to do this? ...

file:/// to http:// communication via IFrame

Hi All! Maybe some of you could have ran into the same problem i did. Imagine you have a file on your machine: file:///c:\test.html And you have an IFrame inside of this file. You need to indicate whether the IFrame contents are loaded or no. Bacically, what we have here: 1. location, href, or any other property is inaccessible from ...

CDC finger-friendly

Hello, I've been working in a Java mobile project using j9 as a virtual machine. So far the project has been developed for an stylus interaction using AWT components. We want to create a new version of the application more finger-friendly the internal logic is working OK so we wanna keep it, it is just the interface that we want to upd...

Big performance difference (1hr to 1 minute ) found in SQL. Can you explain why?

The following queries are taking 70 minutes and 1 minute respectively on a standard machine for 1 million records. What could be the possible reasons? Query [01:10:00] SELECT * FROM cdc.fn_cdc_get_net_changes_dbo_PartitionTest( CASE WHEN sys.fn_cdc_increment_lsn(0x00)<sys.fn_cdc_get_min_lsn('dbo_PartitionTest') THEN sys.fn_...

How to disable CDC for a table manually?

I dropped a table before disabling CDC for that. Now when I recreated the table and tried enabling CDC it says that capture instance already exists. I can use a different Capture Instance name but need to know if there is anyway to drop the associated capture instance manually. When I delete a table through SSMS GUI it drops CDC tables...

CDC-1.0/Foundation-1.0,J2SE-1.3

Dear all, How to setup/configure the environment "CDC-1.0/Foundation-1.0,J2SE-1.3" of an OS (for example windows XP, linux)? Because I want to run the embedded AWT application which requires this environment. ...

How to speed up rotated text output in MFC

I have a MFC application that displays annotated maps, which can include a large amount of text. While the size and font of the text does not tend to change much, the rotation of the text varies considerably, in order to be aligned with the surrounding line work. This basically means that I have to do create and select a new font into ...

Cannot rename a column that is "replicated", probably due to CDC

I want to run the following rename EXECUTE sp_rename N'dbo.Semesters.IsPublic', N'Tmp_ShowNCs', 'COLUMN' I get the error Msg 4928, Level 16, State 1, Procedure sp_rename, Line 547 Cannot alter column 'IsPublic' because it is 'REPLICATED'. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, ...

SQL2008: Is there a way to throttle Change Data Capture (CDC) throughput?

I'm trying to find a way to 'throttle' CDC on SQL2008. The reason being that under normal circumstances, CDC performs brilliantly, but as soon as it needs to deal with a 'large' number of rows, it starts tanking. Typical throughput is between 1000 and 3000 rows a second. It starts to die at about 5000 rows per second. Usually, this is...

CDC and ETL help/recommendations

Here's the background. We have a few different customers, each with a different backend source database. We want to be back to pick up real time changes to the backend database, then transform the data to a target schema in our target database. After that broadcast a message to other apps alerting the change. To do this we need CDC s...