Articles tagged "sql"
PostgreSQL Full-Text Search Tutorial 2026: tsvector, GIN Indexes, Ranking, and Autocomplete
PostgreSQL full-text search tutorial 2026: tsvector, tsquery, GIN indexes for sub-50ms searches on 1M rows, ts_rank relevance ranking, multi-language stemming, autocomplete with pg_trgm, and when to use Elasticsearch instead.
PostgreSQL EXPLAIN ANALYZE: Fix Slow Queries with Proper Indexes (2026)
Master PostgreSQL EXPLAIN ANALYZE in 2026. Read query plans, create B-tree, partial, GIN, and expression indexes. Real case study: 30-second query reduced to 50ms step by step.
PostgreSQL: Create Database with UTF-8 Encoding [Complete Guide]
Create PostgreSQL database with UTF8 encoding. Fix template encoding errors. Guide covers locale, collation, and encoding conversion.
SQL Server: Add Column with ALTER TABLE
In this solution we are going to review how to add a column to an existing table on SQL Server with default values. In this small solution you will learn how to add a columns in table. You can use the ALTER TABLE statement in SQL Server. We will show an example using the NOT NULL constraint.
How to write IF...THEN in an SQL query? (sql server)
In this tutorial we are going to explain how to wirte an IF...THEN statement with SQL Server. We use the sql standard CASE and also explain the IIF statement.
How to UPDATE from SELECT using SQL Server
In this tutorial we explain how to update one table using another one with select clause.
Oracle SQL: How to write a que for filterting Date columns
Oracle SQL date format can be tricky to understand and could make you loose time to figure out why a query is not working. We use TRUNCATE and TO_DATE function to create a query to filter by a date on a timestamp column.