Remove articles comparison-of-all-ops
article thumbnail

Implementing service-level objectives to improve software quality

Dynatrace

First, it helps to understand that applications and all the services and infrastructure that support them generate telemetry data based on traffic from real users. For a given application, not all services are equally important. Instead, they can ensure that services comport with the pre-established benchmarks.

Software 272
article thumbnail

Number series generator challenge solutions – Part 4

SQL Performance

Often while reading his articles or posts, I shake my head and tell my wife, Lilach, that when I grow up, I want to be just like Paul. This article is dedicated to Paul’s solution. I keep being shocked by his discoveries, and wonder how the heck he figures out what he does. I also love his efficient and eloquent writing style.

C++ 112
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

Islands T-SQL Challenge

SQL Performance

However, these techniques require explicit sorting despite the presence of a supporting index. This affects the scalability and response time of the solutions. Fond of challenges, I set out to find a solution to minimize the number of explicit Sort operators in the plan, or better yet, eliminate the need for those altogether. The challenge.

C++ 136
article thumbnail

Number series generator challenge solutions – Part 5

SQL Performance

In this article we’ll put this intuitive assumption to the test. rn , op = @high + 1 - N. ( SELECT. -- Use @@TRANCOUNT instead of @@SPID if you like all your queries serial. In Part 1 , Part 2 , Part 3 and Part 4 I covered pure T-SQL solutions. sp_configure 'show advanced settings' , 1 ; RECONFIGURE ; EXEC sys.

C++ 111