(Martin Bach) While researching interval partitioning in Oracle 19c I came across a phenomenon I had already solved a long time ago but then forgot about.
Other News
No more stale statistics in 19c
(Connor McDonald) There is an odd contradiction that we all encounter for most databases, especially if they are predominantly used during the business day.
Oracle patches – a patchfiles anatomy
(Martin Berger) In my previous post I explained some basics about IDs of platforms, products and similar and where these patches can be obtained.
SQL SERVER – ColumnStore Indexes Without Aggregation
(Pinal Dave) During the recent Comprehensive Database Performance Health Check, I noticed there were lots of aggregation going on with various data in the table. I suggested that the client can experiment with the columnstore indexes and it may help the performance.
Multiple Column Sorting: from Angular NgExTable to Source Data List Management
(Shenwei Liu) My previous article, Client and Server-Side Data Filtering, Sorting, and Pagination with Angular NgExTable, describes the base structures and uses of the custom data grid tool.
Prior to DBMS, Database Approach, Data Model — Part 1
Prior to Introduction of Database Management Systems (DBMS) The way computers manage data has changed dramatically in the last few decades. Today’s end users take the many advantages of a database system for granted. Not so long ago, computers used a less elegant as well as expensive approach to data management called a file-based system. File-Based System One way to...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Research based on the .NET Runtime
(Matt Warren) Over the last few years, I’ve come across more and more research papers based, in some way, on the ‘Common Language Runtime’ (CLR).
Hierarchical Navigation For Azure Data Lake Storage Gen2 In Power BI/Power Query
(Chris Webb) While the documentation on how to import data from Azure Data Lake Gen2 Storage into Power BI is pretty detailed, the connector (which at the time of writing is in beta) that supports this functionality in the Power Query engine has some useful functionality that isn’t so obvious.
Truncate Table Operations in SQL Server
(Dinesh Asanka) Truncating a table is removing all the records in an entire table or a table partition. TRUNCATE table is functionally similar to DELETE table with no WHERE clause.
ReactJS Infinite Scroll Example
(Siddharth Seth) In this article, we implement the Infinite scroll feature in a ReactJS application. This feature allows us to load and present additional content as the user scrolls the container.