-
MY PROJECTS
-
Recent Posts
- Database.What problems can arise with concurrent access using transactions?
- Database.What are the levels of transaction isolation?
- Database.What are the main properties of a transaction?
- Database.What is a “transaction”?
- Database.What is Low Selectivity problem, when we speaking about indexes ?
- Datasource.When is a full scan of a data set more advantageous than index access?
- Database.Does it make sense to index data that has a small number of possible values?
- Database.How do i define my clustered index ?
- Database.What is clustered index ?
- Datasource.What is the difference between clustered and non-clustered indexes?
- Database.How EXPLAIN shows B-tree vs. hash usage in query plans ?
- Database.I was sure that Composite Index (Multi-column) is b-tree
- Database.What types of indexes exist?
- Database.What are “indexes”? What are they used for? What are their advantages and disadvantages?
- Database.If i define primary key as student_id, course_id, why i use only WHERE student_id = 1, for example, and how index of primary key works here ?
- Database.Give example of use of composite primary key
- Database.Is primary key always indexed ?
- Database.What are the types of relationships in a database? Give examples.
- Database.What is “denormalization”? What is it used for?
- Database.3NF, give example
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)
- Регулярные выражения
- Тестирование приложений