Presto: SQL over big data, NoSQL and relational DBMS
What about using SQL to retrieve data from NoSQL databases? Or to make joins between tables stored in relational databases[…]
Read moreDatabaseTips.Net – From SQL to database tuning; here you can find it all!
What about using SQL to retrieve data from NoSQL databases? Or to make joins between tables stored in relational databases[…]
Read moreA Sequence is a database object capable to generate numbers (i.e. it is a number generator). One of the main[…]
Read moreIn SQL, The Count function counts the number of values in a set. Such function accepts a parameter, that specifies[…]
Read moreTo delete a great number of rows from a table may become a pain in the neck. A never ending[…]
Read moreIt is really common to have columns that stores sequences of numbers in database systems (specially in relational databases). Users[…]
Read moreFor many people, using noncorrelated subqueries (using In/Not In) seems to be more natural than using Exists/Not Exists and correlated[…]
Read moreJoins are one of the most common operators in SQL queries. In this post, we present inner and outer joins[…]
Read moreTransaction management is a key functionality of database management systems (DBMS). Its main properties include Atomicity, Consistency, Isolation and Durability[…]
Read moreIn this post, we continue our series on performance tuning. We present the concepts of logical reads and physical reads,[…]
Read more