Grant Fritchey (4/26/2013)

---

TheGreenShepherd (4/26/2013)

---

Don't mean to pile on here, but yeah. I fail to understand why someone would query this data in this fashion. Yeah, it improves performance for that...

That can't. My apologies. I rushed myself and didn't really think it through. Thanks for taking the time to show me in a...

Jimbofoxman (4/26/2013)

---

Created a new view and pasted this in, everything seems fine, the table view and links show up, columns and aliases fill in. When I save I get these...

Short answer is yes, it will fix the immediate concerns. However, I'd recommend using Snapshot Isolation instead as your repair to this concern. It's a powerful tool and...

When you say update (old values), I assume you mean setting a field to the exact same value via UPDATE still ending up in CDC2?

And just confirming, you're using the...

Nice article, Stefan. Thanks for getting it organized. 🙂

Heya Ty,

First, let me add another voice to lament the situation you find yourself in. I'm also a major proponent of a separate ETL server, although the size of...

I believe this gets you where you need to be. It's untested obviously as I don't have equivalent schema/test data in my system.

the use of the DRv is just...

Chris, as far as I know that's not bombproof. While under most circumstances the predicate will be filtered prior to the activation of the cross apply, but I don't...

Jimbofoxman (4/25/2013)

---

I get an error when I try to import the Cross Tab Query using the SQL Server Migration Assistant. I get A2SS0042: Crosstabe query cannot be converted because it...

dm exec cursors, if I remember right, only displays explicitly called cursors.

What you're calling a cursor...

LOL, actually it was the closest I could get to a dust bunny...

There's no cursor...

Easiest way is to use the REVERSE function to trim the ends off each side, in case there are .'s in the middle. Otherwise you use a nested set...

I have no idea, honestly. At that point, I'd seriously look into calling Microsoft and having them examine the design. If anyone can find root cause, it's them.

There's...