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: two small trays sit side by side holding the same pair of shortbread rounds, one scalloped and one plain

VALUES Type Inference: Cast Before Combining Rows

October 14, 2009
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Scripts, SQL Server

VALUES type inference chooses a common column type. Preserve formatting-sensitive text by making source conversions explicit before combination.

Read More
SQL SERVER - Query Optimization - Remove Bookmark Lookup - Remove RID Lookup - Remove Key Lookup - Part 3

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

October 12, 2009
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server

Part 3 of how to Remove Bookmark Lookup, RID Lookup and Key Lookup. A covering index holds every column the query uses in SELECT, JOIN and WHERE.

Read More
Two differently sized plain metal connectors resting beside a matching adapter on a wooden table.

The Implicit Conversion That Quietly Kills Your Index

October 10, 2009
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Find an implicit conversion in your SQL Server plan, understand which value changes type, and match application parameters to indexed columns.

Read More
SQL SERVER - Queries Waiting for Memory Allocation to Execute

SQL SERVER – Queries Waiting for Memory Allocation to Execute

October 9, 2009
Pinal Dave
SQL Performance
SQL Memory, SQL Scripts

Find queries waiting for memory allocation with sys.dm_exec_query_memory_grants, plus wait_order and the query plan, when you suspect memory is short.

Read More
Execution plan for SQL Server query.

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

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

Part 2 compares two ways to remove key lookup and remove RID lookup: a covering non-clustered index versus an index with included columns.

Read More
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
SQL SERVER - Interesting Observation - Query Hint - FORCE ORDER

SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER

October 6, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Index, SQL Joins, SQL Scripts, SQL Server

A junior developer used the FORCE ORDER query hint without knowing what it does. Here is how it works and how much this one hint can change performance.

Read More
Previous 1 … 273 274 275 276 277 278 279 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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