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 slipcover that stops short on a lengthened sofa, the new red seat left bare

Stale Views: Why SELECT * Breaks After ALTER TABLE

September 5, 2014
Pinal Dave
SQL Tips and Tricks
Schema, SQL Coding Standards, SQL Server, SQL View

Reproduce stale views after SELECT star and ALTER TABLE, find candidate definitions, refresh with sp_refreshview, and prevent the pattern.

Read More
Execute SQL Task Editor.

SQL SERVER – The Basics of the SSIS Execute SQL Task – Notes from the Field #044

September 4, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SSIS

Many developers do not know SSIS can run SQL queries. Andy explains the basics of the SSIS Execute SQL Task in very simple words.

Read More
Gouache painting: a wooden sluice gate on a small stream with thin lines of water running through its slots toward a waterwheel, one vermilion float drifting in the channel

Live Execution Plan of a Running Query: SQL in Sixty Seconds #073

September 3, 2014
Pinal Dave
SQL Video
Execution Plan, SQL DMV, SQL in Sixty Seconds, SQL Performance, SQL Server Management Studio

A live execution plan shows how far a query has gotten while it is still running. This post builds a slow query on SQL Server 2025, watches it through sys.dm_exec_query_profiles from a second window, and explains why rows divided by the estimate is a progress meter only when the estimate is right.

Read More
Execution plan results window.

SQL SERVER – Live Plans for Long Running Queries

September 2, 2014
Pinal Dave
SQL Tips and Tricks

How do you see live plans for long running queries while they still run? SQL Server 2014 adds the DMV sys.dm_exec_query_profiles, and I show a simple test.

Read More
Cardinality Estimation Model Version.

SQL SERVER – How to Know Cardinality of Executed Query?

September 1, 2014
Pinal Dave
SQL Performance

Which estimator did SQL Server 2014 use? There are two ways to know the cardinality of executed query, starting with the execution plan properties.

Read More
Gouache painting of nested wooden boxes, opened one inside another, the smallest holding a single vermilion bead.

JSON_CONTAINS in SQL Server 2025: Searching Inside JSON Arrays

August 31, 2014
Pinal Dave
SQL Tips and Tricks
JSON, SQL Function, SQL Scripts

JSON_CONTAINS checks whether a JSON document holds a value at a path, including inside an array. This post tests it on SQL Server 2025: the json data type it needs, numbers versus text, case, NULL results and the older OPENJSON way.

Read More
Options window.

SQL SERVER – CTRL + R Shortcut Does Not Work in SSMS

August 30, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio, SQL Shortcut

After a fresh SQL Server 2014 install, CTRL + R no longer hid the results pane in SSMS. These keyboard option steps got my shortcut working again.

Read More
Table showing various records and their data type.

SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype – Part 2

August 29, 2014
Pinal Dave
SQL Tips and Tricks
SQL Identity

Harsh improved the identity query from Part 1 so it also works when seed values or increment values are not 1. Here is his script.

Read More
SQL SERVER - Detecting Corruption with Suspect Pages Table - Notes from the Field #043

SQL SERVER – Detecting Corruption with Suspect Pages Table – Notes from the Field #043

August 28, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field

John Sterrett shows how the suspect pages table helps with detecting corruption, a tip worth learning even if your database has never been corrupted.

Read More
Table showing various records and their data type.

SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype

August 27, 2014
Pinal Dave
SQL Tips and Tricks
SQL Identity

Mark Hickin improved my old query, so it now shows seed, increment and current identity column value along with the max value of the datatype.

Read More
Previous 1 … 290 291 292 293 294 295 296 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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