Nice

There's also something called change tracking, which isn't as detailed as CDC, you can read about it here

Interesting, I knew there was an overhead to data compression but went for TinyInt over Bit.

Good question, thanks for taking the time to help educate the SQL community.

Ray K (11/15/2010)

---

I'm a musician in my spare time. Among other things, I play in a large community symphonic band. This group is therapy for me. There...

Grimethorpe Colliery Brass Band

Good question, thanks for taking the time to help educate the SQL community.

From BOL:

DMV's are generally populated since the last...

Is this the same request as here

Paul White NZ (11/14/2010)

---

Delete the row and then re-insert it with the correct identity value specified explicitly.

You will need SET IDENTITY_INSERT...

I wrote this some time back to return the fragmentation levels across the entire database where fragmentation exists for tables that contain more than 100 pages.

You can amend it...

Good question, thanks for taking the time to help educate the SQL community.

I look at these DMV's a lot so thankfully answered this one correctly.

True story this, I was on a business objects in-house training course and the instructor had to go through the needless task of explaining relationships and joins using the family...

Juneau, Alaska

Juneau

Check out "Creating Compressed Tables and Indexes" in BOL with lists lots of considerations.