CDC requires a unique index. That makes sense given what it has to be able to do.

I think by default it uses the PK as the unique index, but...

If the log is on the same drive, don't purge any data until you've given the log more space!

If the log is out of space, and particularly if it getting...

Any chance that either or both "TransferToCostCenter" and "TransferFromCostCenter" are NULL?

Not equal won't work on NULL; you'll have to explicitly allow for NULL in the comparison.

For example:

WHERE ...

...

If the computation "size / 1024 / 1024" yielded 96 gbsize,

the correct computation of "size / 128 / 1024" would yield 8 times that, or:

~768gb

That is not the right computation to get gb. "size" is the number/count of 8K pages. So, to get gb from size, you...

The person's login id is often some combination of last name and first name, so you need to change the name there.

However, internally you should assign each person/user a unique...

You can definitely shrink the log file "live". SQL simply won't do it if it would cause a loss of data.

The tricky part is finding the right size to...

And you often need to compare for a full day against a legitimate datetime column.

For example, in a logging table, you would have logging datetime -- obviously you would want...

When the potential-trouble step starts, it could immediately start another job. A job start is async so it would not delay the first process. The extra job...

Excellent article overall.

These are extremely difficult concepts to introduce to people, and the article does a superb job of making the ideas accessible to anyone.

[I do think Alice should have...

Steven Willis (1/10/2013)

ScottPletcher (1/10/2013)

You might want to review the new functions in SQL...

You might want to review the new functions in SQL 2012 dealing with...

Books Online.

Jeff Moden (1/9/2013)

Considering that the IDENTITY column...

GilaMonster (1/7/2013)

Match all criteria, yes. What I was...