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
Gouache painting: under a market awning two wicker baskets of apricots stand apart

HAVING Without GROUP BY: Filter One Implicit Aggregate Group

June 10, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Reports, SQL Scripts, SQL Server

HAVING without GROUP BY filters the single implicit aggregate group produced by the query. I use that distinction when a summary should appear only if its aggregate condition passes. A false condition can remove the summary row entirely.

Read More
The same two sieve frames appear in reversed positions in adjacent workshop channels.

SQL SERVER – Order of Conditions in WHERE Clause

June 8, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

Conditions in a WHERE clause don’t define a short-circuit evaluation sequence. I inspect actual behavior instead of relying on text order.

Read More
SQL SERVER - PIVOT and UNPIVOT Table Examples

SQL SERVER – PIVOT and UNPIVOT Table Examples

June 7, 2008
Pinal Dave
SQL Tips and Tricks
PIVOT and UNPIVOT, SQL Joins, SQL Scripts

If you PIVOT a table and then UNPIVOT it, do you get the original back? Not always. My PIVOT and UNPIVOT table examples show why aggregation loses data.

Read More
Gouache painting of one jar of buttons being topped up by a small red scoop while spare empty jars stand unused

Compound Assignment Operators in T-SQL with Simple Examples

June 5, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Operator, SQL Scripts

Compound Assignment Operators let T-SQL do a calculation and an assignment in one step, so SET @Stock -= 2 replaces SET @Stock = @Stock – 2. This post tests all eight operators on SQL Server 2025 with a small garden center inventory. It also shows integer division, NULL, string and flag examples, and where the shorthand does not help.

Read More
SQL SERVER - Create a Comma Delimited List Using SELECT Clause From Table Column

SQL SERVER – Create a Comma Delimited List Using SELECT Clause From Table Column

June 4, 2008
Pinal Dave
SQL Tips and Tricks
CSV, Database, SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure

I received following question in email : How to create a comma delimited list using SELECT clause from table column?

Read More
SELECT DISTINCT ResultDistinct.

SQL SERVER – Example of DISTINCT in Aggregate Functions

June 3, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

Does DISTINCT in Aggregate Functions make a difference? Yes. A quick AdventureWorks example compares SUM(DISTINCT ReorderPoint) with a plain SUM.

Read More
SQL SERVER - Order Of Column In Index

SQL SERVER – Order Of Column In Index

June 2, 2008
Pinal Dave
SQL Performance
SQL Index, SQL Joins, SQL Scripts

Adding more columns does not make an index better. The order of column in index matters most, since an index is used only when its first column is in the query.

Read More
Previous 1 … 310 311 312 313 314 315 316 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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