Blog Home Page - Page 430 of 831 - SQL Authority with Pinal Dave

Mar10

As you know MySQL supports ANSI JOINs like INNER JOIN, OUTER JOIN, CROSS JOIN etc. Do you know that it supports NATURAL JOIN?. A NATURAL JOIN is a type of JOIN which automatically maps the similar columns from both the tables. Let us create the following tables CREATE TABLE items(item_id…

Mar9

MySQL – Reset Row Number for Each Group – Partition By Row Number

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, Ranking Functions

In earlier post, we have learnt how to generate row number for each row using a variable as MySQL does not have any system function like SQLServer’s row_number() to generate the row number. In this post we will see how to reset row number for each group (Alternate method for…

Mar8

MySQL – Generating Row Number for Each Row Using Variable

Pinal Dave

SQL

MySQL, Ranking Functions, SQL Scripts

MySQL does not have any system function like SQL Server’s row_number () to generate the row number for each row. However, it can be generated using the variable in the SELECT statement. Let us see how MySQL Generating Row Number.

Mar7

SQL SERVER – Retrieve Maximum Length of Object Name with sp_server_info

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

No Comments

A very common question which I often receive is – “How big my table name can be?” The answer is simple 128. You can figure this out by executing stored procedure sp_server_info on SQL Server. Execute following stored procedure in SQL Server. EXEC sp_server_info It will return following resultset. attribute_id…

Mar6

SQL SERVER – Performance Statistic Collection – Notes from the Field #018

Pinal Dave

SQL Performance

Notes from the Field, SQL Server

No Comments

[Note from Pinal]: This is a 18th episode of Notes from the Field series. Performance is very crucial subject and to come up with the right strategy along with a performance one needs to have more knowledge related to the overall performance of the server. However, most of the organization does not come up with the best strategies related to performance. It is very crucial that DBA collects performance statistics of the entire collection methodologically and scientifically. Let us learn more Performance Statistic Collection in this episode.

Mar5

SQL SERVER – SQL Report Builder in dbForge Studio for SQL Server

Pinal Dave

SQL

Devart, SQL Reports, SQL Utility

Modern opportunities of electronic document management systems can significantly simplify the process of decision-making at an enterprise. In this blog post we will learn about SQL Report Builder in dbForge Studio for SQL Server.

Mar4

SQL SERVER – How to Synchronize Data Across Databases and Servers

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

If you are developer you must have faced situations which I am going to mention next. A Developer’s Wish Have you ever built a database application where you are driving your navigation with the help of Data? Have you ever realized that you are running query much faster on your…

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 109 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

MySQL – How to do Natural Join in MySQL? – A Key Difference Between Inner Join and Natural Join

MySQL – Reset Row Number for Each Group – Partition By Row Number

MySQL – Generating Row Number for Each Row Using Variable

SQL SERVER – Retrieve Maximum Length of Object Name with sp_server_info

SQL SERVER – Performance Statistic Collection – Notes from the Field #018

SQL SERVER – SQL Report Builder in dbForge Studio for SQL Server

SQL SERVER – How to Synchronize Data Across Databases and Servers

MySQL – How to do Natural Join in MySQL? – A Key Difference Between Inner Join and Natural Join

MySQL – Reset Row Number for Each Group – Partition By Row Number

MySQL – Generating Row Number for Each Row Using Variable

SQL SERVER – Retrieve Maximum Length of Object Name with sp_server_info

SQL SERVER – Performance Statistic Collection – Notes from the Field #018

SQL SERVER – SQL Report Builder in dbForge Studio for SQL Server

SQL SERVER – How to Synchronize Data Across Databases and Servers