Joey on SQL Server Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization Reduce workload times with this handy feature that can benefit every database pro.

Joey on SQL Server A Deep Dive into SQL Server 2022's Query Performance Features, Part 1 An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the ...

Search within a result set The concept of a subselect is simple: One select query is nested inside another query, creating a resource otherwise unavailable for searching in a single statement.

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...

Want faster SQL queries? Here are nine best practices for writing SQL queries that work like a charm (or at least, like they should).

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and ...