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
SQL Server database scoped configuration window.

SQL SERVER – Database Scoped Configurations – Query Optimizer Fixes

August 10, 2017
Pinal Dave
SQL Performance
SQL Server Configuration, SQL Server Management Studio, TraceFlags

During recent SQL Server Performance Tuning Practical Workshop I receive following question about Query Optimizer Fixes.

Read More
Reports Menu in SSMS.

SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard

August 9, 2017
Pinal Dave
SQL Performance
SQL Download, SQL Reports, SQL Server Management Studio

The latest SQL Server Management Studio now includes the Performance Dashboard by default. Here is the free SSMS download link and a quick look at it.

Read More
A wooden staircase whose cream carpet runner is worn thin in a clear track, a red slipper below.

Auto-Created Statistics: What the _WA_Sys Names Tell You

August 3, 2017
Pinal Dave
SQL Performance
SQL Performance, SQL Server, SQL Statistics

Read auto-created statistics through sys.stats and sys.stats_columns, then use their columns as clues for better query tuning.

Read More
An unfinished woven panel remains on its loom beside a removable stop.

SQL SERVER – How to Abort Index Rebuilding After Specific Time?

August 2, 2017
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server

An index rebuilding limit can control lock waiting or a resumable execution interval. I decide which behavior the maintenance window needs.

Read More
Leather stitching pony holding a prepared seam beside completed stitches

Parse and Compile Time: Reading the First Line of STATISTICS TIME

July 13, 2017
Pinal Dave
SQL Performance
Command Line, SQL Server, SQL Statistics

Someone pastes a compile time of 24 ms and asks if the server is slow. Run it twice and watch the plan cache do its job.

Read More
SQL SERVER - How to Enable Lock Pages in Memory?

SQL SERVER – How to Enable Lock Pages in Memory?

June 15, 2017
Pinal Dave
SQL Performance
SQL Memory, SQL Server, SQL Server Security, Starting SQL

Recently I received an email from user that he tried to search for solution on SQLAuthority.com for how to enable lock pages in memory but could not find a solution for it.

Read More
A line of ants on a stone doorstep carrying crumbs, most of a dropped biscuit already gone

Grouping by query_hash to Find Cheap Queries That Cost the Most

March 30, 2017
Pinal Dave
SQL Performance
Query Store, SQL Cache, SQL CPU, SQL DMV, SQL Server

Group cached statements by query_hash to find high total CPU and reads, compare plan hashes, and account for missing cache history.

Read More
Previous 1 … 52 53 54 55 56 57 58 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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