(Oren Nakdimon) In the previous post we saw that the Oracle Optimizer has a special operation – SORT GROUP BY ROLLUP – for performing several aggregations of the same population in a single scan, as long as the grouping keys are in a “rollup form”; for example:
Other News
SQL SERVER – DELETE Qualified Rows From Multiple Tables – Part 2
(Pinal Dave) Earlier this week, I had announced a contest to get Recorded PASS of my extremely popular training SQL Server Performance Tuning Practical Workshop – Recorded Classes. As the price of this class high, I wanted to keep my contest difficult as well.
T-SQL Regular expression: LIKE Operator and its use-cases.
(Nisarg Upadhyay) A regular expression is a rule which defines how characters can appear in an expression. It’s a sequence of character or text which determines the search pattern.
Monitoring SQL Server deadlocks using the system_health extended event
(Rajendra Gupta) Performance monitoring is a must to do the task for a DBA. You should ensure that the database performance is optimal all the time without any impact on the databases.
Guru: Read a Data Area As a One-Row Table with SQL, Take Two
(Ted Holt) Fifteen years ago, reader W.G. asked me about the possibility of treating a data area as a one-row table (a physical file with one record) in an SQL query.
16 Ways to Speed Test Automation Using a CI/CD Pipeline
(Stella Murugesan) Test automation plays a significant role in software development. It improves speed, better detects errors and bugs, is repeatable, scalable, has broader coverage, and more. Let’s take a look at test automation using a CI/CD pipeline.
An Introduction to System.Threading.Channels
(Steve Gordon) I’ve recently begun making use of a relatively new (well, it’s a little over a year old at the time of writing) feature called “Channels”.
How to Integrate Blazor Components
(Peter Vogel) You can create Blazor components by combining other Blazor components but you’ll almost certainly need to share data between those components. Here are all the options currently open to you.
Percona Server for MySQL Highlights – binlog_space_limit
(Przemys³aw Malkowski) I think it is often confusing to compare upstream MySQL and Percona Server for MySQL, and some helpful information can be found in the introductory notes.
HIGH_VALUE (and other LONG columns) revisited
(Connor McDonald) Just a quick post to ensure people don’t get caught out by a recent “trick” I saw on an AskTOM question for extracting the HIGH_VALUE out of it’s LONG storage in the dictionary to a more appropriate datatype.