A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way?

While some are RDBMS-specific, most of these tips apply to any relational database. My previous collection of SQL do’s and don’ts concentrated on individual query performance.

Testing and tuning SQL is an often-overlooked aspect of incorporating the database into your DevOps pipeline. It is important to be able to analyze and optimize SQL performance within your application ...

SQL Server comes with a feature called Query Store, which provides some performance details, including wait information. For more deeper diagnostic information there are a handful of third-party ...

Joey on SQL Server Why Activity Monitor May Be Hurting Your SQL Server's Performance As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data.