As a follow-up to my introduction to SQL Server joins, in this T-SQL tutorial, I’m going to take a closer look at the most used type of joins in SQL Server – the INNER JOIN.
Category: Best Practices
Using APPLY, you can significantly expand database code functionality from what a simple join statement allows you.
Learn about PostgreSQL PaaS deployment options for Azure Cloud-Single Server, Flexible Server, and Hyperscale-including pricing, benefits, pros and cons.
Generally speaking, there are two types of scaling for SQL Server workloads; horizontally partitioning the workload across multiple servers or vertically scaling the workload with a bigger, single server.
In some cases, sharding can be a total re-architecture of how data is being accessed and stored.
Using data warehouse automation tools, wizards, and templates, developers can fast-track delivery by using auto-generated data warehouse designs to meet the strategic needs of business users.
As PostgreSQL databases continue to grow in size and complexity, so does the need to keep track of all that’s going on in these environments.
The upcoming release of Microsoft SQL Server 2022 brings new features to increase the capabilities of data professionals while increasing scalability.
Learn how SQL JOIN is used to specify how to return data from different tables and the different SQL JOIN types in this comprehensive guide with examples.
Learn about the ORDER BY clause used to order query results set by one or more columns, including common use cases and performance considerations.
SQL Server expert explains the T-SQL DISTINCT clause, including use cases, common performance considerations, tips, and tricks.
Learn about T-SQL UNION operator best practices from a respected SQL Server expert with examples and answers to questions like UNION vs. UNION ALL.
This article gives a primer on restoring database backups, transaction log backups, and the correct restore sequence needed for a series of backups.
Learn some general recommendations for how to approach SQL Server performance tuning to maximize effort and minimize distractions.
Learn about SQL Server best practices for choosing storage options.
