SQL Performance

JUNE 8, 2022

When the parser allows simple parameterization to continue, SQL Server® increments the Auto-Param Attempts/sec counter of the SQL Statistics object. As in previous parts, code examples use the Stack Overflow 2010 database on SQL Server 2019 CU 16 with the following additional nonclustered index: CREATE INDEX [ IX dbo.

Cache 54

Cache Servers Database Processing 54

SQL Performance

APRIL 8, 2020

This article is the first in a series about the fundamentals of table expressions in T-SQL. I will mainly focus on four types of named table expressions, which are known in T-SQL as derived tables, common table expressions (CTEs), views, and inline table-valued functions (inline TVFs). They are all named table expressions.

C++ 143

C++ Azure Database Servers 143

SQL Performance

JANUARY 20, 2022

All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. In this post, I’ll explain what logging is and why it’s required. A transaction encompasses a change or a set of changes to a database.

Servers 54

Servers Database Architecture Performance 54

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ).

C++ 109

C++ Database Servers Code 109

Percona

DECEMBER 15, 2022

JSON data and relational databases have traditionally been diametric opposites. So many folks were surprised when relational databases started adding a JSON data type to their products. In this multi-part blog series, we will start with an overview of using JSON in a relational database. JSON breaks normalization rules.

Database 91

Database Servers Processing Efficiency 91

SQL Performance

OCTOBER 9, 2019

The relevance to T-SQL is that sometimes we assume that we know everything there is to know about certain T-SQL features, and don't always bother checking the documentation to see if there's more to them. In my examples I'll use a sample database called TSQLV5. In my examples I'll use a sample database called TSQLV5.

C++ 111

C++ Database Servers Code 111

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ).

C++ 93

C++ Database Servers Code 93

SQL Performance

MAY 11, 2022

A supporting index can potentially help avoid the need for explicit sorting in the query plan when optimizing T-SQL queries involving window functions. But what about queries involving multiple window functions with different ordering needs? In my examples, I’ll use the sample database PerformanceV5. Environment for Demos.

C++ 133

C++ Database Servers Code 133

SQL Performance

NOVEMBER 4, 2021

First introduced in SQL Server 2017 Enterprise Edition, an adaptive join enables a runtime transition from a batch mode hash join to a row mode correlated nested loops indexed join (apply) at runtime. For brevity, I’ll refer to a “correlated nested loops indexed join” as an apply throughout the rest of this article. Introduction.

Servers 98

Servers Design Database Code 98

Particular Software

MARCH 15, 2021

Business runs on SQL. As popular as NoSQL databases have become, you’d be hard-pressed to find a successful business that isn’t running some flavor of SQL somewhere. SQL Persistence 6.1 SQL Persistence 6.1 The same can be said for any system that uses SQL to store data. In SQL Persistence 6.1,

Transportation 52

Transportation Azure Database Servers 52

SQL Performance

NOVEMBER 10, 2021

Last month I explained when SQL Server inlines iTVFs, it applies parameter embedding optimization by default. Parameter embedding means SQL Server replaces parameter references in the query with the literal constant values from the current execution, and then the code with the constants gets optimized. So, what happened?

Cache 121

Cache Servers Code Database 121

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. And did I mention they are open source?! virtual = 2.2G

Cache 97

Cache Database Virtualization Servers 97

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. This is it.

Traffic 121

Traffic Scalability Database Servers 121

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 67

Tuning Servers Database Best Practices 67

Percona

JANUARY 4, 2023

Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. While working, the customer raised two interesting questions: how can he make complete use of the performance schema, and how can he find what he requires? T he MySQL version I am using here is 8.0.30.

Performance 98

Performance C++ Monitoring Servers 98

SQL Performance

MAY 12, 2021

In Part 1 , Part 2 , Part 3 and Part 4 I covered pure T-SQL solutions. I’ll do my testing in a database called testdb. Use the following code to create the database if it doesn’t exist, and to enable I/O and time statistics: -- DB and stats. IF DB_ID ( 'testdb' ) IS NULL CREATE DATABASE testdb ; GO. BatchMe ; GO.

C++ 111

C++ Servers Database Code 111

Smashing Magazine

SEPTEMBER 28, 2022

The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. What do you see there? But using these bulky frameworks filled with a ton of magical functions you don’t even use isn’t what you should be going for. But what if you can’t do less?

Cache 125

Cache Performance Servers Social Media 125

SQL Performance

DECEMBER 11, 2019

NULL handling is one of the trickier aspects of data modeling and data manipulation with SQL. Let's start with the fact that an attempt to explain exactly what a NULL is is not trivial in and of itself. I start with coverage of what NULLs are and how they behave in comparisons. Let's start with understanding what NULLs are.

Best Practices 117

Best Practices C++ Database Code 117

SQL Performance

MAY 20, 2022

The most important things to understand about server-side parameterization are it doesn’t happen all at once and a final decision to parameterize isn’t made until the end of the process. Names of tables and columns haven’t been resolved to database objects yet, and no type information is available. EXECUTE sys. sp_configure.

Cache 55

Cache Database Servers Testing 55

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries.

C++ 140

C++ Servers Code Efficiency 140

SQL Performance

SEPTEMBER 8, 2021

To understand the circumstances where you would want to use the CHECK OPTION as part of a view’s definition, we’ll first examine what can happen when you don’t use it. This article is the eleventh part in a series about table expressions. So far, I’ve covered derived tables and CTEs, and recently started the coverage of views. Sample Data.

Servers 130

Servers Code Engineering Database 130

SQL Performance

AUGUST 11, 2021

One is using a function called DATE_BUCKET , which at the time of writing is only available in Azure SQL Edge. Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. DATE_BUCKET.

Azure 139

Azure Code Database Servers 139

SQL Performance

MARCH 11, 2020

In the previous articles ( Part 1 , Part 2 , and Part 3 ), I covered the meaning of the NULL as a marker for a missing value, how NULLs behave in comparisons and in other query elements, and standard NULL handling features that are not yet available in T-SQL. This article is Part 4 in a series about NULL complexities.

C++ 135

C++ Code Servers Database 135

Particular Software

AUGUST 16, 2021

Now that our Cosmos DB persistence has reached general availability, let’s answer some common questions about Cosmos DB and what it means to use Cosmos DB with NServiceBus. What is Cosmos DB? What is Cosmos DB used for? What is Cosmos DB? Cosmos DB is the primary database service provided by Azure.

Azure 52

Azure Serverless Storage Database 52

IO River

NOVEMBER 15, 2023

What is WAF?‍WAF This means it specifically looks at the content of the data (like the writing inside our letters from the analogy) rather than just the envelope.So, what is the difference between a Firewall at the application level and network level?Network-level ‍WAF stands for Web Application Firewall.

Traffic 52

Traffic Network Logistics Architecture 52

SQL Performance

APRIL 13, 2022

It’s based on a question from a public database forum. My test machine has four logical CPUs, running SQL Server ® 2019 Enterprise. Before I cover solutions, a bit of optimization background so what you’ll see in the query plans later will make more sense. This affects the scalability and response time of the solutions.

C++ 136

C++ Strategy Testing Servers 136

SQL Performance

NOVEMBER 13, 2019

With the former, you just don't care in what order they are assigned, and whether repeated executions of the query keep assigning the same row numbers to the same rows or not. What I mean by this is that you do have an assurance that within the same partition, a row with a greater datacol value will get a greater row number value.

Servers 104

Servers C++ Storage Performance 104

SQL Performance

MAY 13, 2020

Last month I provided a background to table expressions in T-SQL. I explained the context from relational theory and the SQL standard. I explained how a table in SQL is an attempt to represent a relation from relational theory. The expression can be a query, but doesn't have to be. This is far from being an exhaustive list.

C++ 143

C++ Code Design Servers 143

Percona

DECEMBER 5, 2022

There can be an instance of ProxySQL using a lot of memory on the server. This post is related to one of the causes that can use memory on the ProxySQL server and how we handle it. This post is related to one of the causes that can use memory on the ProxySQL server and how we handle it. Explanation. Commands end with ; or g.

Servers 59

Servers Cache C++ Metrics 59

SQL Performance

AUGUST 12, 2020

In my examples I’ll use a sample database called TSQLV5. Neither this term, nor its acronym CTE, appear in the ISO/IEC SQL standard specs. Neither this term, nor its acronym CTE, appear in the ISO/IEC SQL standard specs. You can find it in the documentation of Microsoft SQL Server and Azure SQL Database.

C++ 140

C++ Code Design Database 140

Highly Scalable

MARCH 1, 2012

NoSQL databases are often compared by various non-functional criteria, such as scalability, performance, and consistency. At the same time, NoSQL data modeling is not so well studied and lacks the systematic theory found in relational databases.

Database 279

Database Ecommerce Efficiency Engineering 279

IO River

NOVEMBER 2, 2023

What is WAF?‍WAF This means it specifically looks at the content of the data (like the writing inside our letters from the analogy) rather than just the envelope.So, what is the difference between a Firewall at the application level and network level?Network-level WAF stands for Web Application Firewall. This is where WAF comes in!

Traffic 40

Traffic Network Logistics Architecture 40

SQL Server According to Bob

FEBRUARY 9, 2020

SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, ​​ logs, ​​ … This blog ​​ post ​​ focuses on connecting to the SQL Server BDC, ​​ some ​​ helpful ​​ log files ​​ and utility outputs.

Servers 40

Servers Database Availability Azure 40

SQL Performance

SEPTEMBER 12, 2019

This article is the fifth part in a series about T-SQL bugs, pitfalls and best practices. In my examples, I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Previously I covered determinism , subqueries , joins and windowing.

Best Practices 103

Best Practices C++ Code Design 103

SQL Performance

MAY 7, 2019

Back in 2014, I started a series of blog posts here to talk about specific wait types and what they do and don’t mean. If you’re reading this and thinking “what is he talking about?” I’m going to introduce you to wait statistics and explain how critical they are for troubleshooting workload performance in SQL Server.

Servers 40

Servers Azure Metrics Tuning 40

SQL Server According to Bob

NOVEMBER 8, 2016

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. What does it mean to go faster? Create / Alter Database … LOG ON.

Cache 40

Cache Servers Media Storage 40

SQL Performance

SEPTEMBER 2, 2021

A lot of things change over the course of a few major versions of our favorite database platform. SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1.

C++ 59

C++ Servers Testing Database 59