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
A dog with a plain brass tag on its collar sitting beside a pile of older collars in different colors and sizes.

Surrogate Keys and Natural Keys

September 18, 2011
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing, Primary Key, SQL Constraint and Keys, SQL Server

Surrogate keys keep warehouse history stable while natural keys preserve source identity; learn lookup, uniqueness, and change handling.

Read More
A smooth band of mist following the shape of a jagged mountain ridge

Moving Averages in T-SQL

September 18, 2011
Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL Function, SQL Scripts, SQL Server

Moving averages in T-SQL use ROWS BETWEEN for rolling windows, but date gaps and duplicate dates decide what the result actually means.

Read More
SQL SERVER - Denali - String Function - FORMAT() - A Quick Introduction

SQL SERVER – Denali – String Function – FORMAT() – A Quick Introduction

September 17, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

A quick introduction to the FORMAT function in SQL Server Denali: locale-aware formatting of dates and numbers, built on the .NET Framework and CLR.

Read More
SQL SERVER 2012 - String Function CONCAT() - A Quick Introduction

SQL SERVER 2012 – String Function CONCAT() – A Quick Introduction

September 16, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL String

SQL Server 2012 adds the String Function CONCAT(), which joins two or more values into one string. Examples show how it handles numbers, dates and NULLs.

Read More
Curved wooden reading nook with books.

SQLAuthority News – Uncut and Unedited – Interview of Pinal Dave on Book Authoring

September 15, 2011
Pinal Dave
SQL Video
Joes 2 Pros, SQL Wait Stats

I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.

Read More
Small wooden pegs beside matching holes in a compact wooden board with one peg set apart.

Lookups in a Data Load: Cached, Uncached and Wrong

September 14, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, ETL

Review lookup data load behavior for cache freshness, comparison rules, duplicate reference keys, and unmatched rows before trusting the output.

Read More
SQL SERVER - Denali - New Functions and Shorthand for CASE Statement

SQL SERVER – Denali – New Functions and Shorthand for CASE Statement

September 13, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

Do the new Denali functions replace the CASE statement? No. They are shorthand for CASE statement logic, and TRY_PARSE works well with CASE.

Read More
Two groups of blue ceramic beads on terracotta and sage cloths beneath an unmarked wooden tool.

XML Namespaces: Match the Namespace URI, Not Just the Tag

September 12, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL XML

XML Namespaces are part of element identity, so a matching tag name alone can still miss a node. I compare three paths against one document. The namespace URI stays the same while the query binding changes.

Read More
disaster

SQL SERVER – DBA Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions

September 12, 2011
Pinal Dave
SQL Puzzle

My question in DBA Quiz 2011 comes from a real incident: a query that always worked fine suddenly did not. Share your reasons and resolutions.

Read More
SQL SERVER 2012 - Logical Function CHOOSE() - A Quick Introduction

SQL SERVER 2012 – Logical Function CHOOSE() – A Quick Introduction

September 11, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

A quick introduction to the logical function CHOOSE() in SQL Server 2012: it returns the value at a given index from a list, or NULL when out of range.

Read More
Previous 1 … 403 404 405 406 407 408 409 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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