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 query execution plan.

SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup

October 7, 2009
Pinal Dave
SQL Performance
SQL Index, SQL Scripts

A quick tip to remove bookmark lookup, RID lookup or key lookup: why it happens when a query needs columns missing from the non-clustered index.

Read More
A small basket of ripe red tomatoes carried along a long row of vines where most tomatoes are still green.

Filtered Indexes and Where They Help

October 2, 2009
Pinal Dave
SQL Performance
Parameter Sniffing, SQL Index, SQL Server, SQL Statistics

Filtered indexes help SQL Server target active rows in a larger table; learn useful predicates, parameter limitations, and how to verify plan choices.

Read More
Detailed painting of a wooden drawer assembly with a fitted stop across its front opening and a loose red-ended peg on the workbench.

ALLOW_PAGE_LOCKS OFF Stops REORGANIZE

September 30, 2009
Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Scripts, SQL Server

ALLOW_PAGE_LOCKS OFF prevents a rowstore index from being reorganized. A controlled example shows the maintenance error, checks the index setting and verifies that enabling page locks allows REORGANIZE without changing the stored rows.

Read More
SQL SERVER - Outer Join in Indexed View - Question to Readers

SQL SERVER – Outer Join in Indexed View – Question to Readers

September 25, 2009
Pinal Dave
SQL Performance
SQL Index, SQL Joins, SQL View, SQL White Papers

Why can’t you use an outer join in indexed view definitions? The SQL Server 2008 white paper answer, plus my question to you: can you show an example?

Read More
SQL SERVER - Converting Stored Procedure into Table Valued Function

SQL SERVER – Converting Stored Procedure into Table Valued Function

September 17, 2009
Pinal Dave
SQL Performance
SQL Function, SQL Stored Procedure

Not every stored procedure should become a Table Valued Function. Here is which kind of SP qualifies, mainly one whose output you insert into another table.

Read More
Bees crowding one narrow entrance of a wooden beehive while a second opening on the side stays almost empty.

High-Frequency Inserts Without Blocking

September 16, 2009
Pinal Dave
SQL Performance
SQL Index, SQL Lock, SQL Server, SQL Wait Stats, Transaction Log

High-frequency inserts can stall on the log, indexes, or last-page contention; learn to diagnose the wait and choose targeted SQL Server fixes.

Read More
An overcrowded umbrella stand of cheap folding umbrellas squeezing out one worn red umbrella

Finding Single-Use Plans Wasting Memory in the Cache

August 29, 2009
Pinal Dave
SQL Performance
Ad Hoc Query, Execution Plan, SQL Cache, SQL Memory, SQL Server

Find single-use plans, compare their cache memory with the total, and inspect parameterization before discussing server-wide cache settings.

Read More
Previous 1 … 99 100 101 102 103 104 105 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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