SQL Performance

APRIL 14, 2021

I also love his efficient and eloquent writing style. Besides row mode being less efficient than batch mode for CPU intensive operations, also, keep in mind that switching from row to batch mode and back takes extra toll. b FROM L1 AS A CROSS JOIN L1 AS B CROSS JOIN L1 AS C ) INSERT INTO dbo. I love Paul White ’s work.

C++ 112

C++ Servers Testing Code 112

Sutter's Mill

JANUARY 25, 2021

On a humorous note, O(N) remains O(N) no matter how hard we try to make it efficient: MyAssert( std::is_sorted( std::execution::par, begin(s), end(s) ) ); // still O(N) arbitrarily expensive, but good try! P0542: Support for contract based programming in C++” (WG21 paper, June 2018). Dos Reis, J. Meredith, N. Myers, and B. Stroustrup.

C++ 62

C++ Programming Cache Testing 62

SQL Performance

JUNE 10, 2020

Customers AS C WHERE EXISTS ( SELECT * FROM Sales. custid = C. For example, when the inner query joins tables with common column names, like in the following example: SELECT custid , companyname , orderdate , orderid , rownum FROM ( SELECT *, ROW_NUMBER ( ) OVER ( PARTITION BY C. Orders AS O ON C.

C++ 109

C++ Database Servers Code 109

SQL Performance

JUNE 10, 2020

Customers AS C WHERE EXISTS ( SELECT * FROM Sales. custid = C. For example, when the inner query joins tables with common column names, like in the following example: SELECT custid , companyname , orderdate , orderid , rownum FROM ( SELECT *, ROW_NUMBER ( ) OVER ( PARTITION BY C. Orders AS O ON C.

C++ 93

C++ Database Servers Code 93

The Agile Manager

MAY 31, 2021

A value-generative investment is a roll of the dice that, say, a new market opportunity can be developed or a cost efficiency can be made where none was possible before. A value-generative investment is an exercise in deploying risk capital through IT in the pursuit of extraordinary benefit that yields competitive advantage.

C++ 52

C++ Efficiency Systems Technology 52

Tasktop

OCTOBER 29, 2020

It’s the gym membership that forces you to exercise. There is just the hard transformation work that needs to be delegated to the product value streams themselves: Start by baselining: VSM tools measure the value streams’ current performance in terms of time-to-market, velocity and efficiency. . Next, examine your bottlenecks.

Storage 52

Storage Speed C++ DevOps 52

The Agile Manager

APRIL 26, 2010

It's pretty well established that Agile and Lean IT are more operationally efficient than traditional IT. This operational efficiency generally translates into significant bottom line benefits. Capitalizing development of IT assets is an exercise in funding salaries and contractor costs out of CapEx budgets.

Government 49

Government Efficiency C++ Software 49

John McCalpin

JANUARY 22, 2018

There was no deep goal — just a desire to see the maximum GFLOPS in action. The exercise seemed simple enough — just fix one item in the Colfax code and we should be finished. Instead, we found puzzle after puzzle. An illustrative example: .

Latency 40

Latency Hardware Code Testing 40