Category: SQL 201


6 Ways to Search with System Tables

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


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.


Have you VACUUMed your tables lately?

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


Speed up your queries with Indexes

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


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.