May 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check
Mar13

SQL SERVER – SSIS Data Flow Troubleshooting – Part1 – Notes from the Field #019

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore, SSIS
1 Comment
[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. The tool may also be used…
Read More
Mar12

MySQL – How to do Straight Join in MySQL?

Pinal Dave
SQL, SQL Tips and Tricks
MySQL
2 Comments
In an earlier post, we have learnt a new type of join called NATURAL JOIN supported in MySQL. In this post will see another type of join called STRAIGHT_JOIN. STRAIGHT_JOIN is actually an INNER JOIN but it forces the order in which data should be processed. As per MySQL’s documentation…
Read More
Mar11

SQL Contest – Win Amazon Gift Cards – Learn How to Get Started with ClustrixDB

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
No Comments
It has been a long time since we contest where we can learn something new and win something cool. I reached out to the good folks of Clustrix with the request to help me to build a contest where readers can learn and explore new technology, while stand a good…
Read More
Mar10

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

Pinal Dave
SQL, SQL Tips and Tricks
MySQL, SQL Joins
No Comments
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…
Read More
Mar9

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

Pinal Dave
SQL, SQL Tips and Tricks
MySQL, Ranking Functions
29 Comments
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…
Read More
Mar8

MySQL – Generating Row Number for Each Row Using Variable

Pinal Dave
SQL
MySQL, Ranking Functions, SQL Scripts
6 Comments

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.

Read More
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…
Read More
Previous 1 … 426 427 428 429 430 431 432 … 830 Next

SQL SERVER – CTRL + R Shortcut Does Not Work in SSMS

SQL Authority News – 3000th Blog Posts and Thank You

SQL SERVER – How to Know Cardinality of Executed Query?

SQL SERVER – Live Plans for Long Running Queries

SQL SERVER – Live Plan for Executing Query – SQL in Sixty Seconds #073

SQL SERVER – The Basics of the SSIS Execute SQL Task – Notes from the Field #044

SQL Authority News – 2 Days to Go – FalafelCON 2014: 2 days with the Best Developers in the World

Previous 1 … 426 427 428 429 430 431 432 … 830 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 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 104 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.


Comprehensive Database Performance Health Check

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.


SQL Server Performance Tuning Practical Workshop

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.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com