Useful tips for everyday
How is large text stored in PostgreSQL 12? This post is part of the series PostgreSQL: From Idea to Database. In this post I test…
How do I shrink a log file in AlwaysOn database? In order to maintain proper (shrink) log file size you can use the following technique.…
What is full-text indexing? A full-text index is a special type of index that provides index access for full-text queries against character or binary column…
Can MySQL client connect to MariaDB? In order to connect to the MariaDB server, the client software must provide the correct connection parameters. The rest…
How to update large tables in PostgreSQL 9.2? If possible, you should drop all the indexes, triggers and foreign keys while the update runs and…
How to calculate Rolling sum over 7 consecutive days? I need this in one query that returns the rows with 7-day rolling sum and the…
Can transaction rollback fail? If a rollback fails, then you would have a serious problem. The reliability of the database cannot be guaranteed. In other…
Is pgAdmin a GUI? PGAdmin is a web-based GUI tool used to interact with the Postgres database sessions, both locally and remote servers as well.…
When to use insert on Conflict Statement in PostgreSQL? The idea is that when you insert a new row into the table, PostgreSQL will update…
How does top clause work in SQL Server? Limits the rows returned in a query result set to a specified number of rows or percentage…