/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 vickiboykis.com
Why doesn't MySQL have window functions? | Vicki Boykis
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Additional info on View Merging
2.0 parsecs away

Travel
| | A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.
| | barneylawrence.com
T-SQL Tuesday #168 - FIRST_VALUE, LAST_VALUE and NULL Handling - Barney Lawrence - A Blog
3.2 parsecs away

Travel
| | FIRST_VALUE and LAST_VALUE had limited uses when they were first released to the world back in 2012, but with the introduced of the ability to ignore nulls in SQL Server 2022 they become a lot more useful. Let's take a look at some examples of why.
| | tsqltuesday.com
T-SQL Tuesday #86 - SQL Server Bugs and Enhancement - T-SQL Tuesday
3.0 parsecs away

Travel
| | [AI summary] The blog post discusses SQL Server bugs and enhancements, encouraging readers to report issues through Microsoft's Connect platform and participate in the improvement process.
| | surfingcomplexity.blog
Extending MVCC to be serializable, in TLA+ - Surfing Complexity
21.5 parsecs away

Travel
| In the previous blog post, we saw how a transaction isolation strategy built on multi-version concurrency control (MVCC) does not implement the serializable isolation level. Instead, it implements a weaker isolation level called snapshot isolation. In this post, I'll discuss how that MVCC model can be extended in order to achieve serializability, based on work...