If you’ve never attended a SQL Server performance tuning session with Brent Ozar or Pinal Dave, you’re in for a treat when the two of them team up during Quest EMPOWER, a virtual conference occurring November 10-11, 2021.
Brent Ozar is a Microsoft…
If you’ve never attended a SQL Server performance tuning session with Brent Ozar or Pinal Dave, you’re in for a treat when the two of them team up during Quest EMPOWER, a virtual conference occurring November 10-11, 2021.
Brent Ozar is a Microsoft…
In this article, we will explore when and how to use the SQL PARTITION BY clause and compare it to using the GROUP BY clause.
Database users use aggregate functions such as MAX(), MIN(), AVERAGE() and COUNT() for performing…
Constraints in SQL Server are predefined rules that you can enforce on single or multiple columns. These constraints help maintain the integrity, reliability and accuracy of values stored in these columns. You can create constraints using CREATE TABLE…
In this article, we’ll explore the different types of SQL tables and best practices for creating user-defined tables in SQL Server.
Tables are primary objects for storing data in relational databases. To visualize a table, consider an Excel spreadsheet…
This article will explain what database schemas are, their advantages and how to create and use schemas in SQL Server.
In a relational database management system such as SQL Server, the database contains various objects. These can be tables, stored procedures…
Data is a critical asset of every organization, and poorly-secured databases are too often to blame for security breaches. This article details SQL server security best practices, as well as essential security considerations for protecting your databases…
In this article, we will cover the different methods for using the UPDATE from SELECT statement in SQL Server.
In the database world, static data is not typically stored. Instead, it keeps changing when we update existing data, archive or delete irrelevant…
In this article, we will explore using the different SQL CONVERT date formats within SQL Server.
Date interpretation varies between different countries. Suppose you have a global SQL Server database with a table that holds a specific date format. For…
SQL JOIN is a clause that is used to combine multiple tables and retrieve data based on a common field in relational databases. Database professionals use normalizations for ensuring and improving data integrity. In the various normalization forms, data…
Brent Ozar, Microsoft Certified Master recently discussed parallelism in SQL Server, specifically the wait types CXPACKET and CXCONSUMER in his final installment of Quest’s Database Training Days Fall Series. In his usual humorous and accessible…
SQL Server execution plans are a gateway for query optimizer and query executions for database professionals. They reveal query processing and involved phases such as affected tables, indexes, statistics, types of joins, the number of affected rows, query…
Database monitoring is the process of collecting and using performance metrics so your database can fully support your applications by avoiding slowdowns and responding immediately to queries. Database professionals who know the right metrics and track…
As part of Quest’s Database Training Days Fall Series, Brent Ozar, Microsoft Certified Master recently presented a tutorial on “Avoiding Deadlocks with Query Tuning.” The program focused on the three concurrency issues that occur in SQL Server,…
The availability, accessibility and performance of data are vital to business success. Performance tuning and SQL query optimization are tricky, but necessary practices for database professionals. They require looking at various collections of data using…
As anyone who manages databases knows all too well, SQL Server performance tuning is a critical function to ensuring optimal performance. With performance dependent upon various factors such as memory, configuration, query design and resource usage, isolating…
In SQL Server, the buffer cache is the memory that allows you to query frequently accessed data quickly. When data is written to or read from a SQL Server database, the buffer manager copies it into the buffer cache (aka the buffer pool). When it’s full…
A SQL CASE statement evaluates and returns results based on particular values, predicates and conditions as per defined logic. For example, suppose you have a voters table with the following details:
If you were looking for logic about…
A SQL Server execution plan is useful for investigating performance issues with your queries. Database professionals often receive trouble tickets or user complaints that queries are running slowly. Query results that used to take two or three minutes…
Database professionals are routinely confronted with database performance issues like improper indexing and poorly written code in production SQL instances. Suppose you updated a transaction and SQL Server reported the following deadlock message. For…
In relational databases, we create tables to store data in various formats. SQL Server stores data in a row and column format which holds a value associated with each data type. When we design SQL tables, we define data types such as integer, float, decimal…
In a previous article, we explored SQL Server index requirements and performance considerations. When it comes to database performance, performance tuning is without question, one of the most important and complex functions. It consists of many different…
SQL Server indexes are used to help retrieve data quicker and reduce bottlenecks impacting critical resources. Indexes on a database table serve as a performance optimization technique. You may wonder – how do indexes increase query performance? Are there…
If anyone had any doubts that a panel discussion where Brent Ozar and Pinal Dave would be answering attendees’ SQL Server performance questions would be a success, those were quickly dispelled during the blockbuster Ask the Experts session Quest hosted…
With the landscape of the tech industry rapidly changing, the adoption of and adjustment to application and infrastructure management presents a major challenge. As a result, companies are increasingly expanding and relying on a mix of relational and…
Why is SQL performance tuning so important to database management?
Because it can save you money big time. Bear with me and you’ll see how.
Most database professionals spend…