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 - Understanding Table Hints with Examples

SQL Server – Understanding Table Hints with Examples – 2

June 20, 2009
Pinal Dave
SQL Performance
Query Hint, SQL Joins, SQL Scripts

A plain guide to understanding table hints in SQL Server: the three kinds of hints, what NOLOCK really means, and a checklist before you use one.

Read More
A grey seal asleep across the only path to a cove while a person with a red paddle waits behind it

Finding Sleeping Sessions That Still Hold Locks

June 19, 2009
Pinal Dave
SQL Performance
SQL DMV, SQL Lock, SQL Server, SQL Transactions

Find sleeping sessions with open transactions, inspect their locks and last batch, and identify the application owner before ending work.

Read More
Two separate library shelving units with a narrow aisle between them, one holding bound books and the other holding only card index drawers.

SQL SERVER – Clustered Index on Separate Drive From Table Location

June 18, 2009
Pinal Dave
SQL Performance
Best Practices, SQL Constraint and Keys, SQL Index, SQL Server

A Jr. developer asked if a clustered index can live on a separate Drive from its table. The answer is no, and the clustered vs non clustered difference shows why.

Read More
SQL SERVER - Query Optimizer Hint ROBUST PLAN - Question to You

SQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You

June 15, 2009
Pinal Dave
SQL Performance
Query Hint, SQL Scripts

What does the query optimizer hint ROBUST PLAN do? I explain query hints in simple words and ask you for a practical example of ROBUST PLAN in action.

Read More
Three bowls and three tall ceramic cups arranged by cream, blue and sage glaze.

No Join Predicate: Verify the Relationship Before Tuning

June 11, 2009
Pinal Dave
SQL Performance
SQL Joins, SQL Performance, SQL Server Management Studio

No join predicate prompts a relationship check. Compare all combinations with exact customer-order pairs before changing indexes or hiding duplicates.

Read More
SQL Server performance counters.

SQL SERVER – Performance Counters from System Views – By Kevin Mckenna

June 10, 2009
Pinal Dave
SQL Performance
SQL Scripts, SQL System Table

SQL and .NET expert Kevin Mckenna, whom I met on Twitter, shows how to read SQL Server performance counters from system views.

Read More
Gouache painting of a glass jar full of cream, slate blue and sage marbles on a wooden table, with a small wooden scoop and one loose marble in front

APPROX_COUNT_DISTINCT in SQL Server: Saves Memory, Not Time

May 29, 2009
Pinal Dave
SQL Performance
SQL Function, SQL Memory, SQL Performance, SQL Scripts

APPROX_COUNT_DISTINCT counts distinct values with almost no memory. Tested on 5 million rows, it was within 2.2 percent of the exact count and needed no memory grant, while COUNT(DISTINCT) asked for 436 MB. It was not faster.

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

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