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 shelf of unused trowels with one worn trowel with a vermilion handle

Table Usage in the Plan Cache: Count Queries That Touch a Table

January 4, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL Scripts, SQL Server

Table usage in the plan cache shows how many times the cached queries of a database touched each table. This post builds a demo database, shows why a text search of the cache misleads, reads the table names from the plan XML, and lists the queries behind one table.

Read More
Completed paper assemblies await secure consolidation beside a closed press.

SQL SERVER – Delayed Durability and Flushing Log Files

December 30, 2020
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure, Transaction Log

Flushing with sys.sp_flush_log hardens preceding committed delayed-durable transactions in the current database. I use delayed durability only with an accepted tradeoff.

Read More
Gouache painting of a row of grey-blue birds on a wire with two vermilion birds among them above a quiet village road

Parameters of sp_who2: Active, Session ID and the Login Trap

December 29, 2020
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Monitoring, SQL Scripts, SQL Server

The parameters of sp_who2 are one optional value that can be a session ID, the word active or a login name. This post counts the rows each form returns, shows that the login form does not filter, and explains the errors.

Read More
Gouache painting of a football goal far across a lawn with a vermilion ball sitting much nearer

Disable Row Goal in SQL Server: When the Hint Helps and When It Hurts

December 28, 2020
Pinal Dave
SQL Performance
Execution Plan, Query Hint, SQL Scripts, SQL Server

To disable row goal for one query, add the DISABLE_OPTIMIZER_ROWGOAL hint to it. This post builds a table where the row goal chooses a bad plan, shows the reads with and without the hint, and then shows a table where the row goal wins.

Read More
all sessions

List All Sessions – SQL in Sixty Seconds #148

December 22, 2020
Pinal Dave
SQL Video
SQL Activity Monitor, SQL in Sixty Seconds, SQL Scripts, SQL Server

One of the most frequent questions which I receive from my client is about activity going inside SQL Server and how to list all sessions.

Read More
Gouache painting of a light wooden cart attached to a small tractor by a vermilion coupling pin

Attach an In-Memory Database With T-SQL: Include the Container

December 21, 2020
Pinal Dave
SQL Tips and Tricks
In-Memory OLTP, SQL Backup and Restore, SQL Scripts, SQL Server

To attach an In-Memory database with T-SQL, use CREATE DATABASE with FOR ATTACH and list the data file, the log file and, when it moved, the container folder. This post builds a demo database, detaches it and attaches it twice. It also shows which rows survive.

Read More
Matched drawer components await fitting beside preserved original materials.

SQL SERVER – Attach a Database with T-SQL

December 18, 2020
Pinal Dave
SQL Tips and Tricks
In-Memory OLTP, SQL Backup and Restore, SQL Scripts, SQL Server

To attach a Database with T-SQL, I use CREATE DATABASE … FOR ATTACH. A customer asked about attaching existing data and log files.

Read More
Previous 1 … 23 24 25 26 27 28 29 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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