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).

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. 2017-07-04 10248 440.00 2017-07-05 10249 1863.40 2017-07-08 10250 1552.60 2017-07-08 10251 654.06

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

Multi-Cloud Management Tools, Challenges and Best Practices

Simform

“By 2022, about 75% of enterprise customers using cloud infrastructure as a service (IaaS) will adopt a deliberate multi-cloud strategy, up from 49% in 2017.”. The post Multi-Cloud Management Tools, Challenges and Best Practices appeared first on Insights on Latest Technologies - Simform Blog. Gartner Research.

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. In this blog post, we will talk about MongoDB sharding and walk through the main reasons why you should start a cluster (independent of the approach you have chosen).

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. WARNING: These tunables were developed in late 2017, for Ubuntu Xenial instances on EC2.** Will Bengtson (security) co-presented Best Practices for Managing Security Operations on AWS.

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. WARNING: These tunables were developed in late 2017, for Ubuntu Xenial instances on EC2.** Will Bengtson (security) co-presented Best Practices for Managing Security Operations on AWS.

Tuning 52