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 long vermilion fruit bowl in a market aisle with small private baskets under the counter

Dynamic SQL Temp Table: Why It Disappears and How to Keep It

July 20, 2019
Pinal Dave
SQL Tips and Tricks
Dynamic SQL, SQL Scripts, SQL TempDB, Temp Table

A dynamic SQL temp table is dropped when its dynamic batch ends, so the main code cannot read it. A global temp table keeps the data, and a per session name keeps it safe. Every step is tested, including the second session clash.

Read More
Gouache painting of a picket fence in a meadow with one vermilion picket leaning the opposite way

SQL Agent Job Backslash Puzzle: Why Both Rows Were Deleted

July 18, 2019
Pinal Dave
SQL Puzzle
SQL Delete, SQL Scripts, SQL Server Agent

A SQL Agent job backslash at the end of a comment line can turn a one row delete into a delete of the whole table. This puzzle sets up the job, explains the cause and tests the effect in T-SQL. It ends with a safe way to write the step.

Read More
Gouache painting of a garden tap with a vermilion wheel feeding a pinched hose into a wooden trough

Disable Resource Governor: Why RECONFIGURE Turns It On

July 17, 2019
Pinal Dave
SQL Tips and Tricks
Resource Governor, SQL Memory, SQL Scripts, SQL Server

To disable Resource Governor, run ALTER RESOURCE GOVERNOR DISABLE. The post shows why RECONFIGURE enables the feature, with a tested script that restores the state it finds. It also explains how saved pool limits come back to life.

Read More
Illustrated cover: Swap Without a Temp

SQL SERVER – Swap Column Values In Table

July 16, 2019
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Scripts, SQL Server

Here is a question asked to me during Comprehensive Database Performance Health Check. The question was about how to swap column values in a table.

Read More
Gouache painting of three wooden shape sorter boxes with a single vermilion peg in front of them

Delete Qualified Rows From Multiple Tables: A SQL Puzzle

July 13, 2019
Pinal Dave
SQL Puzzle
SQL Delete, SQL Performance, SQL Scripts

Delete qualified rows from multiple tables with as few logical reads as you can. This puzzle gives a setup script for three small tables, the two rules for the delete and a starting script that costs 19 logical reads. Your task is to beat that number and stay correct.

Read More
Gouache painting of a bare kitchen counter with one vermilion jar brought back from the pantry

DBCC DROPCLEANBUFFERS Impact on Memory: See a Cold Cache in Action

July 11, 2019
Pinal Dave
SQL Performance
SQL Memory, SQL Scripts, SQL Server DBCC

DBCC DROPCLEANBUFFERS removes every clean page from memory, so the next query reads from disk. This post counts the pages of one database before and after, shows why a CHECKPOINT comes first, and compares a cold read with a warm read.

Read More
A small potted plant is connected to a larger source plant

What is Source_Database_ID in Sys.Databases?- Interview Question of the Week #232

July 7, 2019
Pinal Dave
SQL Interview Questions and Answers
Snapshot, SQL High Availability, SQL Scripts, SQL Server, SQL System Table

Question: What is Source_Database_ID in Sys.Databases and why it is mostly NULL? Very interesting question, I received indeed.

Read More
Previous 1 … 69 70 71 72 73 74 75 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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