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
Title card: Report Does Not Have Any Data to Show

SQL SERVER – Fix Error: Currently This Report Does Not Have Any Data to Show, Because Default Trace Does Not Contain Relevant Information

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

If there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show.

Read More
A market stall of identical brown paper bags, a hand opening them one by one to find what is inside.

Entity-Attribute-Value Tables: Why They Hurt Queries

May 8, 2020
Pinal Dave
SQL Tips and Tricks
JSON, Normalization, Schema, SPARSE Columns, SQL Server

Understand entity-attribute-value query costs, lost types, indexing limits, and alternatives using real columns, sparse columns, or JSON.

Read More
Film reels, globe and work aprons represent the Sakila, World and Employees sample databases

MySQL – Download Sample Database – Sakila, World, Employee

February 15, 2020
Pinal Dave
SQL Tips and Tricks
Schema, SQL Sample Database, SQL Server

Get MySQL sample databases Sakila, World, and Employees. Follow Windows install steps, verify each import, and choose the right dataset.

Read More
An allotment plot with its gate open, older lettuce rows and a new row of seedlings inside one fence

Granting Read Access to One Schema With GRANT SELECT ON SCHEMA

November 19, 2019
Pinal Dave
SQL Tips and Tricks
Schema, SQL Login, SQL Server, SQL Server Security

Use GRANT SELECT ON SCHEMA for focused read access, test a loginless user, and check ownership chains and table-level DENY behavior.

Read More
A fitted drawer belongs to one cabinet while a neighboring cabinet has an empty recess.

SQL Puzzle – Schema and Table Creation – Answer Without Running Code

October 15, 2019
Pinal Dave
SQL Puzzle
Schema, SQL Scripts, SQL Server, SQL Table Operation

This Table Creation puzzle asks for an explanation before you run its code. I suggest examining the batch separators carefully.

Read More
An old coal scuttle still holding fuel beside a newer container

Retired Features Still in Your Schema: Stretch, text and More

March 18, 2019
Pinal Dave
SQL Tips and Tricks
Best Practices, Schema, SQL Server

Before an upgrade, look for text and image columns, old rules and defaults, and Stretch metadata. These queries show what is there.

Read More
An open garden gate allows passage while sturdy braces keep its frame stable

Does NOLOCK Really Applies No Lock? – Interview Question of the Week #209

January 20, 2019
Pinal Dave
SQL Interview Questions and Answers
Query Hint, Schema, SQL Lock, SQL Scripts, SQL Server

Does NOLOCK really applies no lock? No. NOLOCK takes a Sch-S, or schema stability, lock. Here is a simple script to see it for yourself.

Read More
Previous 1 2 3 4 5 Next
  • Books
  • Testimonials
  • Privacy Policy

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