Category: SQL Server

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.
Introductory and how-to guide explaining what transactions are, why they're necessary, and how they work in SQL Server.
January 19, 2022 | Paul S. Randal | SQL Server 0
When monitoring SQL Server performance, you should know which PerfMon counters matter and why. This guide identifies and explains the best 15 counters.
In this tutorial, I’ll show you how to use backups to perform point-in-time recovery and a more advanced way to determine an exact point to restore to.
Learn the key differences between NoSQL and SQL databases, such as relational databases trading performance to guarantee data and transactional consistency.
December 7, 2021 | Joey D’Antoni | SQL Server 0
This article gives a primer on restoring database backups, transaction log backups, and the correct restore sequence needed for a series of backups.
November 18, 2021 | Tim Radney | Best Practices, SQL Server, Backups 0
What’s the secret to making SQL Server go faster on Azure VMs? Why is doing this so important? Find answers in this article.
October 21, 2021 | Tim Radney | Performance, SQL Server, Azure 0
When interviewing for a SQL Server DBA position, there's almost always a technical and non-technical portion. Here's how to prepare.
October 13, 2021 | Kevin Kline | SQL Server 0
Use this daily SQL Server best practice checklist for DBAs to keep an eye on and stay ahead of common SQL Server performance issues.
October 8, 2021 | Monica Rathbun | SQL Server 0
Learn some general recommendations for how to approach SQL Server performance tuning to maximize effort and minimize distractions.
October 6, 2021 | Paul S. Randal | Best Practices, SQL Server 0
Understanding the native SQL Server backup types and ensuring you have the proper backups to meet your recovery objective can help your organization.
Learn about SQL Server best practices for choosing storage options.
September 29, 2021 | Jonathan Kehayias | Best Practices, SQL Server, Storage 0
The most beneficial performance monitoring delivers the means to measure and improve performance using a unified SQL Server monitoring solution.
September 9, 2021 | Jason Hall | SQL Server 0
Intelligent Query Processing optimizes query plans automatically, so as data changes, queries still run as fast as possible.
August 18, 2021 | Peter Vogel | SQL Server 0

Top Categories

See all
1 2 3 4 5

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More