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
SELECT COUNT (*) dialog from humanresources.

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate

February 5, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts

Stream Aggregate is a common showplan operator, even in a simple COUNT(*) plan. I explain why a Compute Scalar often shows up right before it.

Read More
SQL SERVER - Get the List of Object Dependencies - sp_depends and information_schema.routines

SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines

February 4, 2010
Pinal Dave
SQL Tips and Tricks
SQL Dependency, SQL Scripts, SQL Server, SQL Server Security, SQL System Table

sp_depends can return wrong dependency results where information_schema.routines gets it right. See where it fails and the DMVs recommended in its place.

Read More
A protected master-mold cabinet stands beside separate everyday working trays.

SQL SERVER – Location of Resource Database in SQL Server Editions

January 31, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL System Table

The Resource database contains SQL Server system objects. I use version-specific guidance to locate its files and plan recovery.

Read More
SQL SERVER - Several Readers Questions and Readers Answers

SQL SERVER – Several Readers Questions and Readers Answers

January 30, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts

A collection of readers questions from this blog, with answers from other readers, like how to script table rows as INSERT statements and track changes.

Read More
A small closed toolbox sits beside a plain flashlight on a quiet workshop bench.

The First Hour on a Server Nobody Can Explain

January 26, 2010
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Investigate a slow SQL Server in a fixed order, checking connectivity, blocking, waits, plans, and storage before changing the environment.

Read More
SQL SERVER - Find Statistics Update Date - Update Statistics

SQL SERVER – Find Statistics Update Date – Update Statistics

January 25, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Statistics

Stale statistics can hurt a query plan. Use STATS_DATE to find the statistics update date for each index, then update them if they look outdated.

Read More
Hands arranging fabric squares into a patchwork quilt pattern

Building Your Own Sample Data Set

January 24, 2010
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Sample Database, SQL Scripts, Testing

Build a sample data set with realistic keys, skew, NULLs, and repeatable generation when a downloaded sample misses the lesson.

Read More
Previous 1 … 265 266 267 268 269 270 271 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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