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 illustration of numbered database records

SQL SERVER – 2005 – List All Column With Identity Key In Specific Database

March 29, 2008
Pinal Dave
SQL Tips and Tricks
SQL Identity, SQL Index, SQL Scripts, SQL Server, SQL System Table

Question I received in Email : How to list all the columns in the database which are used as identity key in my database?

Read More
SQL Server query execution plan.

SQL SERVER – Introduction to sys.dm_exec_query_optimizer_info

March 28, 2008
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, SQL System Table

While browsing Books Online I found sys.dm_exec_query_optimizer_info, which returns statistics about the query optimizer to help you tune a workload.

Read More
SQL SERVER - 2005 - Find Index Fragmentation Details - Slow Index Performance

SQL SERVER – 2005 – Find Index Fragmentation Details – Slow Index Performance

March 27, 2008
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL System Table

A slow index turned out to be heavily fragmented. My quick script uses sys.dm_db_index_physical_stats to show index fragmentation details for every index.

Read More
SQL SERVER - Simple Puzzle Using Union and Union All - Answer

SQL SERVER – Simple Puzzle Using Union and Union All – Answer

March 25, 2008
Pinal Dave
SQL Puzzle
Database, SQL Joins, SQL Scripts

The answer to yesterday’s Simple Puzzle Using Union and Union All, explained with an image. My UNION vs. UNION ALL article explains why it works.

Read More
SQL SERVER - Simple Puzzle Using Union and Union All

SQL SERVER – Simple Puzzle Using Union and Union All

March 24, 2008
Pinal Dave
SQL Puzzle
SQL Scripts, SQL Utility

A simple puzzle using UNION and UNION ALL: guess the output of two short scripts before you run them. The hint is my article on UNION vs. UNION ALL.

Read More
SQL SERVER - 2005 - Find Highest / Most Used Stored Procedure

SQL SERVER – 2005 – Find Highest / Most Used Stored Procedure

March 22, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure, SQL System Table

Which stored procedure runs most often? My small SQL Server 2005 script finds the most used stored procedure, with execution count, worker time and calls per second.

Read More
Socks sorted into matched pairs on a quilt, a small pile of odd socks set apart, a hand holding up one sock.

Solving SQL Puzzles With Set-Based Thinking

March 20, 2008
Pinal Dave
SQL Puzzle
Ranking Functions, SQL Joins, SQL Scripts, SQL Server

Set-based thinking solves three SQL puzzles with grouping, anti-joins, and windows, then turns each solution into a repeatable query habit.

Read More
Previous 1 … 315 316 317 318 319 320 321 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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