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 sleeping bag beside another squeezed into a stuff sack with a vermilion strap

Page and Row Compression in SQL Server: Estimate, Enable, Remove

May 22, 2019
Pinal Dave
SQL Tips and Tricks
Compression, SQL CPU, SQL Scripts

Page and row compression shrink a table or index, and each one is a single ALTER statement. This post estimates the savings first, turns each level on and off in a demo, and measures what the page rebuild costs in CPU.

Read More
Login vs User

SQL SERVER – Difference Between Login Vs User – Security Concepts

May 21, 2019
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

In this blog post, we discuss the difference between Login Vs User – Security Concepts. They look the same but actually, they are totally different.

Read More
A newly lit pendant lamp illuminates an extinguished candle

When Was SQL Server Last Restarted? – Interview Question of the Week #225

May 19, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Scripts, SQL Server, SQL TempDB, Starting SQL

When was SQL Server last restarted? It is my first question in every Health Check, because a restart empties the DMVs and their performance history.

Read More
Table with SQL Server Data Types.

SQL SERVER – Stored Procedure sp_datatype_info to Get Supported Data Types

May 16, 2019
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Scripts, SQL Server

Forget which data types your SQL Server version supports? I run sp_datatype_info, which lists every supported type with precision, nullability and searchability.

Read More
Gouache painting of two garden beds, one seeded and one bare, with a vermilion push seeder

Automatic Seeding in Always On: List and Monitor It

May 14, 2019
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL DMV, SQL High Availability, SQL Scripts

Automatic seeding in Always On lets the primary send a database to a secondary without a manual backup and restore. Three read-only queries show which replicas use it, what happened before and how far a seeding run has come. It also covers why it fails and when to switch it off.

Read More
Illustrated cover: Instant Rollback

SQL SERVER – Getting Started with Accelerated Database Recovery – Instant Rollback

May 13, 2019
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server 2019, SQL Transactions, Transaction Log

Killing a long transaction used to mean a rollback that took forever. SQL Server 2019 fixes that with Accelerated Database Recovery and its instant rollback.

Read More
Gouache painting of a vermilion vintage camera on a tripod beside a print of the hill it points at

Last Known Actual Plan in SQL Server: Query Plan Stats

May 11, 2019
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL DMV, SQL Scripts, SQL Server 2019

The last known actual plan is the plan of the most recent run of a cached query, with its real row counts. This post turns the feature on for one database, reads the plan with sys.dm_exec_query_plan_stats and compares estimated rows with actual rows.

Read More
Previous 1 … 73 74 75 76 77 78 79 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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