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
Four small wooden trays holding different numbers of smooth pebbles on a warm oak tabletop.

The Four Window Functions You Will Actually Use

August 5, 2013
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Learn four practical window functions with SQL examples for numbering rows, ranking ties, comparing previous values, and calculating running totals.

Read More
Restrict access SQL server tool.

SQL SERVER – Understanding Restrict Access to Restricted_User Database Property

August 4, 2013
Pinal Dave
SQL Tips and Tricks

What does Restrict Access set to Restricted_User mean in database properties? I answered a reader with a simple image comparing it with Multi_User and Single_User.

Read More
Two rows of lettuces, a red marker stick standing in the one empty gap.

IS DISTINCT FROM in SQL Server 2022: NULL-Safe Comparisons

August 3, 2013
Pinal Dave
SQL Tips and Tricks
SQL NULL, SQL Operator, SQL Server, SQL Server 2022

Use IS DISTINCT FROM for NULL-safe comparisons in SQL Server 2022, understand older workarounds, and inspect index seeks before changing code.

Read More
SQL SERVER - Disk Space Monitoring - Detecting Low Disk Space on Server

SQL SERVER – Disk Space Monitoring – Detecting Low Disk Space on Server

August 2, 2013
Pinal Dave
SQL Tips and Tricks
Disk, SQL Scripts, SQL Server, SQL Stored Procedure

A common question I get: how do you go about detecting low disk space on SQL Server? Here are two ways, including xp_fixeddrives, and the one I prefer.

Read More
A stained glass panel being made, five panes in a row with two filled and a hand testing a piece in a gap.

A Crossword Helper in T-SQL: Matching Word Patterns With LIKE

August 1, 2013
Pinal Dave
SQL Tips and Tricks
SQL Operator, SQL Scripts, SQL Server, SQL String

Match word patterns with LIKE and SUBSTRING, build sorted-letter anagram signatures, and use a leading-letter index for crossword searches.

Read More
An offset icing spatula beginning a new icing section beside a finished section

Adding System Versioning to a Table That Already Has Rows

July 31, 2013
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Table Operation, Temporal Table

Turning on temporal history for a table that already has data does not rebuild the past. Here is the clean way to do it, and the traps to avoid.

Read More
A wooden crate with fitted compartments holding bottles upright beside a loose canvas sack of potatoes on a pantry floor.

SQL or NoSQL for a New Project

July 30, 2013
Pinal Dave
SQL Tips and Tricks
Database, MongoDB, NoSQL, Software Development

Choose SQL or NoSQL for a new project by testing data shape, consistency needs, query patterns, and the skills the team can operate.

Read More
Gouache painting of a roadside farm stand with jam jars and vegetables under a vermilion awning, green fields behind.

Profitable Blog: How a Technical Blog Pays for Itself

July 30, 2013
Pinal Dave
Personal
Best Practices, Blogging, Professional Development

A profitable blog starts with readers who trust the writer. This post shows how a technical blog pays for itself through ads, consulting and books. It ends with a short checklist for your own blog.

Read More
Two hands taking blocks from two sorted bins, one of cubes and one of cylinders, beside a messy heap of blocks.

Rewriting OR Conditions So the Index Gets Used

July 29, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Server, SQL Union clause

Rewrite OR conditions with separate seeks, preserve duplicate and NULL behavior, and compare plans before choosing UNION or recompilation.

Read More
A tall floodlight lighting an entire empty car park at night, one small bicycle standing in a far corner.

SSRS Parameters That Do Not Slow Reports

July 28, 2013
Pinal Dave
SQL Performance
Parameter Sniffing, Reporting Services, SQL Performance, SQL Reports, SQL Server

SSRS parameters work best with selective defaults, compact value lists, and SQL queries that preserve useful indexes under real filters.

Read More
Previous 1 … 332 333 334 335 336 337 338 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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