This is all correct behavior given the types involved. As Mark Cowne pointed out, what you are seeing in SSMS as 0.29 if you run the ROUND, or 29 if...

• This reply was modified 5 years ago by  Jacob Wilkins.
• This reply was modified 5 years ago by  Jacob Wilkins.
• This reply was modified 5 years ago by  Jacob Wilkins.

Yeah, this has been known for a while.

See here, here, and here (this last is the wayback machine's copy of the connect item referenced by the second article).

From the first...

• This reply was modified 5 years ago by  Jacob Wilkins.

Just a bit of clarification:

"Always On" is a label MS applies to some of its availability solutions, including Availability Groups and Failover Cluster Instances.

While it is often used interchangeably with...

I'm glad you seem to have gotten this working with Eddie's solution.

For the record, my hint about the original session's capturing zero events was not related to the case of...

A bit of a hint:

What strings would the TSQL comparison LIKE 'ALTER' match? 🙂

Cheers!

In that case, something like this should do the trick:

SELECT *,
       percentage_of_selection=Base*100.0/SUM(Base) OVER (PARTITION BY Selection)
FROM TestData;

Cheers!

It's not entirely clear from your description, but from your expected results it looks like maybe what you're wanting is this:

For each row, report the percentage its Base...

This is a documented change in behavior. 

From https://docs.microsoft.com/en-us/sql/database-engine/breaking-changes-to-database-engine-features-in-sql-server-2016?view=sql-server-2017 :

Under database compatibility level 130, implicit conversions from datetime to datetime2 data types show improved accuracy by accounting for the fractional...

Glad to help!

http://rusanu.com/2012/01/17/what-is-an-lsn-log-sequence-number/ is a good place to start for the LSN.

Cheers!

Check out https://technet.microsoft.com/en-us/library/2009.07.sqlbackup.aspx for an explanation of the amount of log needed by data backups.

It could be a number of things, from the database's generating more...

Wow. I've been away from here for a while. Reading that thread certainly makes for a bizarre re-entry to SSC.

I remembered his posts always being difficult, but I...

The most likely explanation is the log that has to be included in database backups to allow a restore using that backup file to recover the database to a consistent...

Just convert the varbinary to varchar using the appropriate style, in this case likely style 1.

Cheers!

If performance has otherwise increased noticeably, this is maybe not so surprising.

That counter is reporting the number of active transactions at the time the the value is sampled,...