-
MY PROJECTS
-
Recent Posts
- Database.Middle.What are surroget keys ?
- Database.Middle.Explain the difference between OLTP and OLAP.
- Database.Middle.Partitions and sharding, differenes
- Database.Middle.do i see different tables in some sql explorer like dataGrip, for example ?
- Database.Middle.How does database partitioning work?
- Database.Middle.What is a trigger? How and when would you use it?
- Database.Middle.What is the difference between ROW_NUMBER(), RANK(), and DENSE_RANK()?
- Database.Middle.What are CTEs (Common Table Expressions)?
- Database.Middle.If i don’t use ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW, so i take all rows ?
- Database.Middle.WindowFunctions.Explain ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
- Database.Total.Give examples with Sum(), Avg(), Max()
- Database.Middle.What is window function?
- Database.Middle.Pagination.SeekMethod.What if some rows were deleted ?
- Database.Middle.Why, when we seek for pages no shifting from inserts/deletes on other rows ?
- Database.Middle.What is the Seek Method?
- Database.Middle.How would you implement pagination in SQL?
- Database.Middle.What is eventual consistency?
- Database.Middle.Explain the concept of sharding in databases.
- Database.Middle.MaterializedView
- Database.Middle.How can you detect and resolve deadlocks?
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
Database.Middle.What are surroget keys ?
Surrogate keys are artificial, system-generated keys used to uniquely identify rows in a database table. They are not derived from application data and have no business meaning — typically auto-increment integers or UUIDs. 🧠 Definition A surrogate key is a … Continue reading
Posted in Без рубрики
Leave a comment
Database.Middle.Explain the difference between OLTP and OLAP.
OLTP and OLAP are two fundamental types of database systems, each optimized for different workloads and purposes. 🧾 Definitions Term Stands For Purpose OLTP Online Transaction Processing Fast, real-time operations (e.g. purchases, signups) OLAP Online Analytical Processing Complex analysis, reports, … Continue reading
Posted in Без рубрики
Leave a comment
Database.Middle.Partitions and sharding, differenes
Partitioning and sharding are both techniques for splitting large datasets into smaller parts — but they solve different problems and work at different levels. Here’s a clear breakdown: ⚖️ Partitioning vs Sharding: Core Differences Feature Partitioning Sharding 📍 Level Within … Continue reading
Posted in Без рубрики
Leave a comment
Database.Middle.do i see different tables in some sql explorer like dataGrip, for example ?
🔍 In DataGrip (or pgAdmin, MySQL Workbench, etc.) When you’re using partitioning, you typically see: The main table (logical parent) Its child tables (actual partitions) Example (PostgreSQL): In your table list, you’ll see: You query the parent table (sales) The … Continue reading
Posted in Без рубрики
Leave a comment
Database.Middle.How does database partitioning work?
Database partitioning is a technique used to split a large table into smaller, more manageable pieces, called partitions, while keeping them logically part of the same table. This improves performance, scalability, and sometimes maintenance. 🧠 Why Partition? ✅ Query performance: … Continue reading
Posted in Без рубрики
Leave a comment
Database.Middle.What is a trigger? How and when would you use it?
A trigger in SQL is a database object that automatically executes (or “fires”) a specified block of code in response to certain events (like INSERT, UPDATE, or DELETE) on a table or view. 🔧 What Is a Trigger? A trigger … Continue reading
Posted in Без рубрики
Leave a comment
Database.Middle.What is the difference between ROW_NUMBER(), RANK(), and DENSE_RANK()?
Great question! ROW_NUMBER(), RANK(), and DENSE_RANK() are ranking window functions in SQL that assign a number to each row based on some ordering criteria. They look similar but behave differently when there are ties in the data (i.e., rows with … Continue reading
Posted in Без рубрики
Leave a comment
Database.Middle.What are CTEs (Common Table Expressions)?
CTEs (Common Table Expressions) are a way to write temporary, reusable result sets (like named subqueries) in SQL, using the WITH keyword. They’re especially useful for making complex queries more readable, modular, and recursive. 📌 Basic Syntax Think of a … Continue reading
Posted in Без рубрики
Leave a comment
Database.Middle.If i don’t use ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW, so i take all rows ?
Excellent question — and the answer depends on which window function you’re using, and whether you’re using ORDER BY in the OVER() clause. Let’s clarify it fully: ✅ If You Use ORDER BY Without ROWS BETWEEN When you write something … Continue reading
Posted in Без рубрики
Leave a comment
Database.Middle.WindowFunctions.Explain ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
Great question! The clause: is used within a window function to define the range of rows (called the window frame) that the function operates on relative to the current row. 🔍 What It Means UNBOUNDED PRECEDING: Start from the first … Continue reading
Posted in Без рубрики
Leave a comment