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 rowing boats jammed at a narrow stone arch with one vermilion boat past it

Max Degree of Parallelism for Microsoft Dynamics CRM

September 14, 2018
Pinal Dave
SQL Performance
MAXDOP, Parallel, SQL Scripts, SQL Server Configuration

Max degree of parallelism controls how many cores one query can use, and the vendor guidance for Microsoft Dynamics CRM has been 1. This post measures what parallel plans cost on a heavy and a small query. It shows a database scoped limit and the instance wide statements.

Read More
Heavy and light tool aprons supported by suspenders with visibly different loads

Wide Covering Indexes: The Cost of INCLUDE Everything

September 7, 2018
Pinal Dave
SQL Performance
Best Practices, SQL Performance, SQL Server

Adding every column with INCLUDE feels like a free speed-up. Here is a small demo of the space, reads and writes you pay for.

Read More
A wide stone culvert with a trickle of water and a high line of dried debris from spring floods

Right-Sizing SQL Server: Reading CPU and Memory Use Before Consolidation

September 6, 2018
Pinal Dave
SQL Performance
DBA, SQL CPU, SQL DMV, SQL Memory, SQL Monitoring

Base right-sizing SQL Server on sampled CPU, memory pressure, buffer use and interval I/O, then compare peaks across a full business cycle.

Read More
An unsettled mosaic in its assembly jig is inspected beside a stable finished sample.

SQL SERVER – Applying NOLOCK to Every Single Table in Select Statement – SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

September 3, 2018
Pinal Dave
SQL Performance
Query Hint, SQL Scripts, SQL Server, Transaction Isolation

READ UNCOMMITTED changes session read isolation without adding NOLOCK to every table. A workshop procedure made the distinction useful.

Read More
Wood shavings are inspected beside the joinery work that produced them.

SQL SERVER- High CPU and Transaction Type WorkFileGroup_fake_worktable and Workfile

August 28, 2018
Pinal Dave
SQL Performance
SQL Error Messages, SQL Operator, SQL Performance, SQL Scripts, SQL Server, SQL TempDB

Workfile and WorkFileGroup_fake_worktable were clues in a customer high-CPU investigation. I correlated them with queries and plan evidence.

Read More
Small red ribbons tied to pine trunks marking a path through a wood to a single picnic table in a clearing.

Decoding wait_resource: From a KEY or PAGE Lock to the Table

August 14, 2018
Pinal Dave
SQL Performance
SQL DMV, SQL Lock, SQL Server, SQL Wait Stats

Decode wait_resource for blocked requests, map KEY and PAGE locks to objects, and keep undocumented row-hash checks on test copies.

Read More
An empty storage bin is ready for tiles without changing its physical capacity.

SQL SERVER – How to Turn On / Enable Instant File Initialization?

July 31, 2018
Pinal Dave
SQL Performance
Computer Network, SQL Server, Starting SQL

To Enable Instant File Initialization for data files, I check the Windows service identity and volume-maintenance privilege. Eligibility still matters.

Read More
Previous 1 … 47 48 49 50 51 52 53 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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