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
IIF() Function Result.

SQL SERVER – Denali – Logical Function – IIF() – A Quick Introduction

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

A quick introduction to the IIF function in SQL Server Denali, a shorthand for the CASE statement that returns one of two values. It can be nested too.

Read More
SQL SERVER - Denali - Conversion Function - Difference between PARSE(), TRY_PARSE(), TRY_CONVERT()

SQL SERVER – Denali – Conversion Function – Difference between PARSE(), TRY_PARSE(), TRY_CONVERT()

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

SQL Server Denali adds a new conversion function trio: PARSE(), TRY_PARSE() and TRY_CONVERT(). Here are the differences, answered as questions.

Read More
TRY_CONVERT() execution plan result.

SQL SERVER – Denali – Conversion Function – TRY_CONVERT() – A Quick Introduction

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

Meet the TRY_CONVERT function in SQL Server Denali. It behaves like CONVERT, except a failed conversion gives you NULL rather than an error.

Read More
TRY_PARSE() function result.

SQL SERVER – Denali – Conversion Function – TRY_PARSE() – A Quick Introduction

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

A quick introduction to the TRY_PARSE function in SQL Server Denali: it converts a string to a number or date, and returns NULL when it cannot.

Read More
A coconut scraper extracts white shreds from a shell into a ceramic bowl

Converting XML Documents to JSON With FOR JSON PATH

September 7, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

A partner asks for JSON from your XML export. Build the nested shape, decide what an empty order looks like, and avoid the escaped-array surprise.

Read More
PostgreSQL SQL Query Result Window.

SQL SERVER – Denali – Conversion Function – PARSE() – A Quick Introduction

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

A quick introduction to the PARSE function in SQL Server Denali: convert a string to a number or a date and time, and see what happens when it fails.

Read More
An unfinished clay cup sits beside a smooth finished cup on a potter's workbench.

What a Preview Build Is For, and What It Is Not

September 6, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Use a SQL Server preview to test specific features and report reproducible issues while keeping production data and recovery paths separate.

Read More
A wide reading table with one large ledger open at the centre and reference volumes arranged around it

What Is a Data Warehouse?

September 5, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Business Intelligence, Data Warehousing, Database

A data warehouse is built for questions, not transactions. Facts and dimensions in plain words, why the star schema reads the way people talk, what a date dimension is for, and when you do not need one.

Read More
A citrus reamer and two orange halves beside a basket of untouched whole oranges

AT TIME ZONE Cost: Converting Many Rows Without Burning CPU

September 5, 2011
Pinal Dave
SQL Tips and Tricks
SQL Performance, SQL Scripts, SQL Server

Converting a whole column with AT TIME ZONE looks harmless on three rows and hurts on a hundred thousand. Here is the cheaper way to filter a local day.

Read More
A team tree with Maya at level 1, Arjun and Lena at level 2 and Noor at level 3, beside four rowpatterns and their rows: the one-level path returns Maya, the two-level path returns Arjun and Lena, the three-level path returns Noor, and a double slash path returns all four

OPENXML Rowpattern in SQL Server: Search Every Level and Read the Parent

September 4, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure, SQL XML

An OPENXML rowpattern decides which XML elements become rows. This post tests absolute paths, a double slash that searches every level, and the ../ column pattern that reads the parent and grandparent. It repeats the result with nodes() and explains the flags value. Every result comes from SQL Server 2025.

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

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