Category: SQL 201

search-sys-tables

6 Ways to Search with System Tables

Your database doesn’t just contain your data. It also contains data about your data.

sql-query-tweaks

10 Ways to Tweak Slow Running Queries

Before you rage quit or call in your DBA, check these things aren’t slowing down your SQL query. A few tweaks could be all you need to get things working.

vacuum-database

Have you VACUUMed your tables lately?

A high-level overview of why your DBA needs to VACUUM your tables

sql-indexes

Speed up your queries with Indexes

Your query is running slow, have you checked your indexes?

sql-ctes

Why you should use SQL CTEs

CTEs are persisted temporary data sets, that allow you to store a single query to go back to later in your script.

 
Bitnami