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
Two conveyor belts of parcels, one running straight through and one stopping at a machine that discards duplicates.

SQL SERVER – Union vs. Union All – Which is better for performance?

March 10, 2007
Pinal Dave
SQL Performance
SQL Download, SQL Scripts

UNION removes duplicate rows like SELECT DISTINCT, while UNION ALL keeps them all. My early notes on Union vs. Union All, with a link to the rewritten post.

Read More
A fingertip tracing one dark growth ring on a freshly cut tree stump in a forest clearing

Checking the Update History of an Instance

March 7, 2007
Pinal Dave
SQL Tips and Tricks
DBA, SQL Log, SQL Patch, SQL Server

Reconstruct SQL Server update history from Setup Bootstrap logs, startup error logs, and the current build when no patch ledger exists.

Read More
SQL SERVER - Script to Determine Which Version of SQL Server 2000-2005 is Running

SQL SERVER – Script to Determine Which Version of SQL Server 2000-2005 is Running

March 7, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

A quick way to see which version of SQL Server 2000 or 2005 is running: SERVERPROPERTY returns the product version, the product level and the edition.

Read More
SQL SERVER - QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF Explanation

SQL SERVER – QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF Explanation

March 5, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts

What do SET QUOTED_IDENTIFIER and SET ANSI_NULLS do around every stored procedure you create? A plain explanation of both settings, ON and OFF.

Read More
Five prints pegged on a washing line, four fading away and one kept.

SQL SERVER – Delete Duplicate Records – Rows

March 1, 2007
Pinal Dave
SQL Tips and Tricks
Duplicate Records, SQL Scripts

A short query to delete duplicate records from a table with an identity column: keep the MAX(ID) in each group of duplicate columns and remove the rest.

Read More
Two rows of blue and pale ceramic beads on wooden guides, with one terracotta bead.

WINDOW: Reuse an Explicit Running-Total Frame

February 28, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Reports, SQL Scripts, SQL Server

WINDOW lets me name a window definition and reuse it across compatible calculations. I still specify the partition, ordering and frame. A short name should make the intended calculation easier to review.

Read More
SQL SERVER - What is New in SQL Server Agent for Microsoft SQL Server 2005

SQL SERVER – What is New in SQL Server Agent for Microsoft SQL Server 2005

February 26, 2007
Pinal Dave
SQL Tips and Tricks
SQL Download, SQL Error Messages, SQL Server Agent, SQL Utility

A TechNet article I liked on what’s new in SQL Server Agent for SQL Server 2005: security, proxy accounts, shared schedules, WMI alerts and Database Mail.

Read More
Previous 1 … 840 841 842 843 844 845 846 847 Next
  • Books
  • Testimonials
  • Privacy Policy

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