Remove 11 what-if
article thumbnail

Stuff The Internet Says On Scalability For August 31st, 2018

High Scalability

No, I really have no idea what that means either, but it did make me consider that our universe could be created by an algorithm. What are the wiggly cycles on the periphery? Read about it and some of the consequences (search for “Misguided performers”) in the 2018 Accelerate State of DevOps Report.

Internet 105
article thumbnail

Fundamentals of table expressions, Part 7 – CTEs, optimization considerations

SQL Performance

I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries. You won’t miss anything important that you haven’t read before. ( SELECT S.

C++ 140
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Stuff The Internet Says On Scalability For December 14th, 2018

High Scalability

Bill English : What we did was lease two video circuits from the phone company. It's HighScalability time: We've come a long way in 50 years. Or have we? Alan Kay : I believe ARPA spent $ 175,000 of 1968 money for that one demo. That’s probably like a million bucks today. book: Explain the Cloud Like I'm 10.

Internet 141
article thumbnail

T-SQL bugs, pitfalls, and best practices – window functions

SQL Performance

Unfortunately, there's no way to tell from the plan what kind of spool you're getting. To demonstrate this pitfall, I'll use a table called Transactions holding two million bank account transactions with credits (positive values) and debits (negative values). DROP TABLE IF EXISTS dbo. Transactions ; CREATE TABLE dbo. Transactions. (

article thumbnail

Bucketizing date and time data

SQL Performance

Unless you’re using Azure SQL Edge, if you want to bucketize date and time data, for the time being you would need to create your own custom solution to emulate what the DATE_BUCKET function does. The function’s syntax is as follows: DATE_BUCKET ( <date part>, <bucket width>, <timestamp>[, <origin>] ).

Azure 139
article thumbnail

Database Server Lifecycle for MySQL and MariaDB

Percona

For MySQL, both releases are made by the same company (Oracle), follow the same version numbering, and the Enterprise version is a superset of what is available in Community. Additionally, MariaDB recently changed the leading version from 10 to 11. MySQL 8 became what seemed like a “forever release.” MySQL 5.6,

article thumbnail

Nested window functions in SQL

SQL Performance

What nested window functions are not about. What makes it harder is that I don't know of any platform that implemented this feature yet. GROUP BY custid , orderdate ; This query generates the following output, shown here in abbreviated form: custid orderdate daytotal runningsum - - -- - 1 2018-08-25 814.50 1 2018-10-03 878.00

Servers 83