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 cream jar and shallow bowl sit beside a slate-blue triangular panel, a looping sage cord and a small red bead.

geometry STDimension: Count Dimensions, Not Points

September 13, 2009
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

geometry STDimension describes dimensionality rather than the number of coordinates. A mixed collection reports its highest-dimensional element.

Read More
Stepping stones crossing a misty pond, a sequence with gaps

SQL SERVER – Find Gaps in The Sequence

September 6, 2009
Pinal Dave
SQL Tips and Tricks
SQL Identity, SQL Scripts, SQL Server

How do you find gaps in a Sequence of numbers? A reader asked, and two experts, Brian and Tejas, replied with good scripts. Here are both solutions.

Read More
Restore Database Options.

SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)

September 5, 2009
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Replication, SQL Scripts

Error 3724 stops you from dropping a database once used for replication. My simple fix: back up an empty database with the same name and force a restore.

Read More
SQL SERVER - Mirrored Backup and Restore and Split File Backup - Introduction

SQL SERVER – Mirrored Backup and Restore and Split File Backup – Introduction

September 2, 2009
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Scripts, SQL Server

Backup and Restore lessons from my consulting work: conventional backups, split file backups, mirrored backups and the FORMAT clause, each with an example.

Read More
Walnuts and cream beads rest in a slate-blue dish beside a magnifying glass, red thread spool and pale dish draped with sage-green cloth.

REGEXP_MATCHES: Read Matches and Capture Groups

August 28, 2009
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

REGEXP_MATCHES returns full matches and captured groups. Read group values and positions, preserve duplicate letters, and check a no-match input.

Read More
Gouache painting: a floating log boom stretches across a calm river

LIKE ESCAPE: Search for a Literal Percent Sign

August 27, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Scripts, SQL Server

LIKE ESCAPE expresses a literal punctuation search. Preserve the distinction between wildcard pattern instructions and stored text.

Read More
SQL SERVER - Get Query Plan Along with Query Text and Execution Count

SQL SERVER – Get Query Plan Along with Query Text and Execution Count

August 21, 2009
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL System Table

A handy script that shows each query’s text, its execution count and its query plan, so you can see what runs most often on your server.

Read More
Previous 1 … 275 276 277 278 279 280 281 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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