This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Three pale ceramic bowls, two filled with blue and terracotta stones and one empty, beside two loose stones.

XQuery Comparisons: General Equality Is Not Singleton Equality

November 22, 2013
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL XML

XQuery Comparisons use different rules for general sequence operators and singleton value operators. I make equality and inequality visible side by side. A general unequal-pair result is not always the inverse of an equal-pair result.

Read More
MySQL - How to Write Loop in MySQL

MySQL – How to Write Loop in MySQL

November 12, 2013
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts

MySQL does not let you loop in ad-hoc SQL. Here is how to write a loop in MySQL with a simple stored procedure that uses LOOP, ITERATE and LEAVE.

Read More
MYSQL - Identifying Current Version of MySQL Server Installation - Part 2

MYSQL – Identifying Current Version of MySQL Server Installation – Part 2

November 9, 2013
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts

Readers shared more ways to find the current version of MySQL: SELECT VERSION(), SELECT @@Version, the STATUS command and SHOW VARIABLES.

Read More
Birds on three telegraph wires at dusk, each wire mostly one kind of bird with a few others mixed in.

Finding the Most Frequent Value per Group in T-SQL

October 28, 2013
Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL Group By, SQL Scripts, SQL Server

Find the most frequent value in each group, choose a tie policy, and compare categorical modes with averages and numeric percentiles.

Read More
A wooden seed cabinet in a shed with one drawer open, plain seed packets sorted in neat rows inside.

Keeping Your Own Script Library

October 27, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Documentation, SQL Scripts

A script library stays useful when folders, names, review history, and safe headers make each SQL file understandable before it runs.

Read More
A row of garden chairs with red cushions, the chairs without cushions stacked by the shed.

A WHERE Filter That Turns Your LEFT JOIN Into an INNER JOIN

October 26, 2013
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts, SQL Server

Fix a LEFT JOIN whose right-table WHERE filter removes unmatched rows, inspect the inner-join plan, and search modules for candidates.

Read More
Gouache painting of a kitchen counter split in two: on the left, chopped vegetables going neatly into small jars; on the right, whole vegetables in a large wooden crate with a knife beside it, and one vermilion bell pepper in the crate.

ETL vs ELT: How Big Data Changed the Way We Load Data

September 30, 2013
Pinal Dave
SQL Tips and Tricks
Data Warehousing, ETL, JSON, SQL Scripts

ETL vs ELT comes down to when you transform: before the load on a separate engine, or after it inside the platform. This post compares the two and runs a small ELT pipeline in T-SQL on JSON orders.

Read More
Previous 1 … 180 181 182 183 184 185 186 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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