article thumbnail

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

SQL Performance

This article is the fourth installment in a series about T-SQL bugs, pitfalls and best practices. The focus of this month's article is bugs, pitfalls and best practices related to window functions. The performance penalty is relevant only when the window function is optimized with row-mode processing operators.

article thumbnail

T-SQL bugs, pitfalls, and best practices – pivoting and unpivoting

SQL Performance

This article is the fifth part in a series about T-SQL bugs, pitfalls and best practices. Here I'll describe the trap, the potential bug, and a best practice that prevents the bug. Previously I covered determinism , subqueries , joins and windowing. This month I cover pivoting and unpivoting. 830 rows affected).

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

A Tutorial on MongoDB Sharding With Best Practices & When To Enable It

Percona

This blog was originally published in October 2017 and was updated in September 2023. Scalability is a significant concern, as databases must handle growing data volumes and user demands while maintaining peak performance. A poorly chosen shard key can lead to performance issues.

article thumbnail

The future of AI: Kelsey Hightower on how AI can raise the bar for humanity

Dynatrace

At Perform 2023, Dynatrace’s annual conference, Hightower once again joined DevOps activist Andreas Grabner onstage to discuss the role of AI in today’s cloud environments. Hightower shared his beliefs on operational best practices. Going forward, we need better frameworks, and once we have those, we encode these best practices.”

article thumbnail

T-SQL bugs, pitfalls, and best practices – Joins

SQL Performance

This article is the third installment in a series about T-SQL bugs, pitfalls and best practices. Some of the bugs and best practices that I cover here are a result of a survey I did among fellow MVPs. All of these bugs are related to T-SQL querying fundamentals, and are easy to avoid if you follow simple best-practices.

article thumbnail

AWS re:Invent 2017: How Netflix Tunes EC2

Brendan Gregg

My last talk for 2017 was at AWS re:Invent, on "How Netflix Tunes EC2 Instances for Performance," an updated version of my [2014] talk. Our team looks after the BaseAMI, kernel tuning, OS performance tools and profilers, and self-service tools like Vector. We help where we can. We help where we can. schedtool –B PID.

Tuning 61
article thumbnail

AWS re:Invent 2017: How Netflix Tunes EC2

Brendan Gregg

My last talk for 2017 was at AWS re:Invent, on "How Netflix Tunes EC2 Instances for Performance," an updated version of my [2014] talk. Our team looks after the BaseAMI, kernel tuning, OS performance tools and profilers, and self-service tools like Vector. We help where we can. We help where we can. schedtool –B PID.

Tuning 52