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
Gouache painting of a drum recorder with a clean blank paper strip on its roller and its pen arm lifted away, the pen tip vermilion

Schema Changes History Has No Data: Check Default Trace Enabled

May 26, 2020
Pinal Dave
SQL Tips and Tricks
Schema, SQL Reports, SQL Scripts, SQL Server Configuration, SQL Server Management Studio

The Schema Changes History report can say it has no data to show. A client saw this message in SSMS. Check that default trace enabled is 1, make a schema change, and run the report again.

Read More
A nonempty uniform bead strand fits a tray while empty and mismatched candidates remain separate.

SQL SERVER – Validating Positive Integer Strings with Explicit Boundaries

May 25, 2020
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL String

To Validate Natural integer strings, I define a nonempty positive ASCII-digit contract. A customer wanted a simpler validator.

Read More
A woven panel and a complete replacement with an additional stripe

How to Alter Index to Add New Columns in SQL Server? – Interview Question of the Week #278

May 24, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Index, SQL Performance, SQL Scripts, SQL Server

Question: How to Alter Index to Add New Columns in SQL Server? 

Answer: It is not possible to Alter Index definition to add or remove columns.

Read More
Gouache painting of a wooden card catalog cabinet beside woven baskets of mixed items, linked by a vermilion string.

SQL to MongoDB: Mapping SELECT, WHERE, GROUP BY and JOIN

May 23, 2020
Pinal Dave
SQL Tips and Tricks
Database, MongoDB, NoSQL, SQL Scripts

Moving from SQL to MongoDB is mostly a change of vocabulary plus a new way to join. This post maps SELECT, WHERE, ORDER BY, GROUP BY and JOIN to find, sort, $group and $lookup, and tests each one on a small vegetarian shop.

Read More
Gouache painting of an empty pantry shelf with dust outlines of missing jars, a broom, and one vermilion jar left on the floor.

MongoDB deleteMany: The Empty Filter That Deletes Everything

May 22, 2020
Pinal Dave
SQL Tips and Tricks
Database, MongoDB, NoSQL, SQL Scripts

MongoDB deleteMany removes every document that matches a filter, and an empty filter matches all of them. This post tests deleteOne, deleteMany, findOneAndDelete and the two quiet traps: a misspelled field and a filter built from an unset variable.

Read More
Gouache painting of a wall of small wooden card drawers with one vermilion drawer pulled open and a fresh card among older ones.

MongoDB updateOne: $set, $inc and Upserts Without Surprises

May 21, 2020
Pinal Dave
SQL Tips and Tricks
Database, MongoDB, NoSQL, SQL Scripts

MongoDB updateOne changes one document, and its result object shows how many documents matched and how many changed. This post tests $set, $inc, updateMany, upserts and the replaceOne mistake that wipes every other field.

Read More
Gouache painting of a farm produce stand with crates of vegetables, a brass magnifying glass on one crate and a vermilion basket of chosen tomatoes.

MongoDB find: Filters, Projections and Sorting for SQL People

May 20, 2020
Pinal Dave
SQL Tips and Tricks
Database, MongoDB, NoSQL, SQL Scripts

MongoDB find returns the documents that match a filter. This post tests find, findOne, $gt, $in, $and, $or, projection, sort, limit and countDocuments on 18 grocery products, each next to its SQL equivalent.

Read More
Previous 1 … 40 41 42 43 44 45 46 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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