-
MY PROJECTS
-
Recent Posts
- SQL.How can you compare two nullable values safely, and how does IS DISTINCT FROM differ from <>?
- SQL.How are NULL values ordered by ORDER BY, how do defaults differ between databases, and how can you control their placement?
- SQL.How does NULL propagate through arithmetic expressions, and how can COALESCE and NULLIF help handle missing values and division by zero?
- SQL.How does NULL affect join conditions, and why can filtering the right-hand table in WHERE remove unmatched rows from a LEFT JOIN?
- SQL.How do GROUP BY and DISTINCT treat NULL values, even though NULL = NULL evaluates to UNKNOWN?
- SQL.How do aggregate functions handle NULL, and what is the difference between COUNT(*), COUNT(column), and COUNT(DISTINCT column)?
- SQL.How does NULL affect IN and NOT IN, and why can NOT EXISTS be a safer choice when a subquery returns nullable values?
- SQL.How do WHERE, HAVING, and CHECK constraints treat conditions that evaluate to UNKNOWN?
- SQL.Why do column = NULL and column <> NULL not work as expected, and when should you use IS NULL and IS NOT NULL?
- SQL.What is SQL’s three-valued logic (TRUE, FALSE, UNKNOWN), and how do AND, OR, and NOT behave with UNKNOWN?
- ChromeDevTools.Watch all failed requests
- SQL.What are domain types (or constraints on data types), and how do they help enforce data correctness?
- SQL.How does SQL handle comparisons between different data types (for example, string vs number), and why is this dangerous?
- SQL.What is the difference between DATE, TIME, TIMESTAMP, and TIMESTAMPTZ, and which one should be used for business events?
- SQL.How do numeric types like INTEGER, BIGINT, DECIMAL, and FLOAT differ in terms of precision and use cases?
- SQL.What problems can arise from implicit type casting in SQL, and how can it affect indexes?
- SQL.How does NULL differ from 0, an empty string, or FALSE in SQL?
- SQL.What is the difference between CHAR, VARCHAR, and TEXT, and when would you choose each?
- SQL.What is MVCC ?
- SQL.What is AutoVacuum Postgres ?
Categories
- Aptana
- Azure
- C#
- DataSnap
- DBExpress
- Delphi
- Delphi и сети
- Delphi. Язык программирования
- ExtJS
- FastReport
- FireDAC
- FireMonkey
- GIT
- ICS
- IDE
- IIS
- Indy
- InnoSetup
- javascript
- jQuery
- JSON
- LiveBindings
- MSHTML
- MySQL
- PHP
- REST
- Ribbons
- SMS
- SQL инструкции
- SVN
- TRichView
- UniGui
- WebBroker
- WinAPI
- Windows
- Алгоритмы
- Без рубрики
- Деревья
- Ищу ответ
- Компонентостроение
- Мои компоненты
- Начальный уровень
- Обработка исключений
- Парсинг
- Потоки(Threads)
- Регулярные выражения
- Тестирование приложений
Author Archives: Stanislav_Panteleev
Java.Collections.What is JVM Padding ?
Let’s talk about why Java uses padding in memory layout — even when you only store something tiny like a byte.
Posted in Без рубрики
Comments Off on Java.Collections.What is JVM Padding ?
Java.Colletions.Estimate the amount of memory required to store one byte primitive in LinkedList?
Let’s estimate how much memory is needed to store a single byte primitive in a Java LinkedList<Byte>. Even though it’s “just a byte” (which is 1 byte!), the actual memory cost in a LinkedList<Byte> is much higher because of: Boxing … Continue reading
Posted in Без рубрики
Comments Off on Java.Colletions.Estimate the amount of memory required to store one byte primitive in LinkedList?
Java.Collections.What is Object header ?
Every object in Java has an object header — a block of metadata that the JVM attaches to every object on the heap.
Posted in Без рубрики
Comments Off on Java.Collections.What is Object header ?
Java.Collections.How much additional memory is allocated when calling LinkedList.add()?
In Java, a LinkedList is a doubly-linked list, meaning each element is stored in a node object like this: So every time you call add(), the list creates a new Node object to hold the element.
Posted in Без рубрики
Comments Off on Java.Collections.How much additional memory is allocated when calling LinkedList.add()?
Java.Collections.How much additional memory is needed when calling ArrayList.add()?
✅ Normal case (no resize) And the internal array still has room, the memory cost is: 💾 Only the reference to the new element is added (e.g., 4 or 8 bytes depending on JVM architecture). So: No new array allocation … Continue reading
Posted in Без рубрики
Comments Off on Java.Collections.How much additional memory is needed when calling ArrayList.add()?
Java.Collections.Suggest an efficient algorithm for removing several adjacent elements from the middle of a list implemented by ArrayList.
If you want to efficiently remove several adjacent elements from the middle of an ArrayList, there’s a much better way than calling remove(index) in a loop.
Posted in Без рубрики
Comments Off on Java.Collections.Suggest an efficient algorithm for removing several adjacent elements from the middle of a list implemented by ArrayList.
Java.Collections.How are elements removed from an ArrayList? How does the size of the ArrayList change in this case?
Let’s break down exactly how elements are removed from an ArrayList, and how that affects its size and internal structure.
Posted in Без рубрики
Comments Off on Java.Collections.How are elements removed from an ArrayList? How does the size of the ArrayList change in this case?
Java.Collections.You need to add 1 million elements, what structure do you use?
When you need to add 1 million elements, the best choice depends on where and how you’re adding them.
Posted in Без рубрики
Comments Off on Java.Collections.You need to add 1 million elements, what structure do you use?
Java.Collections.What is the worst case execution time of the add() method for ArrayList?
Let’s dive into the worst-case time complexity of the add() method for ArrayList.
Posted in Без рубрики
Comments Off on Java.Collections.What is the worst case execution time of the add() method for ArrayList?
Java.Collections.What is the worst case running time of the add() method for a LinkedList?
Let’s explore the worst-case running time of the add() method in a LinkedList—and clarify which version of add() we mean:
Posted in Без рубрики
Comments Off on Java.Collections.What is the worst case running time of the add() method for a LinkedList?