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 - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - Part 3

SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 3

March 11, 2008
Pinal Dave
SQL Performance
SQL Function, SQL Joins, SQL Scripts

Part 3 on how to retrieve TOP and BOTTOM rows together: Dave Arthur’s solution uses UNION ALL instead of an OR clause, and it is quite good.

Read More
A small garden gate with a latch polished bright from use beside a grand iron gate rusted shut.

Finding the Most Frequently Run Queries

March 9, 2008
Pinal Dave
SQL Performance
Query Store, SQL Cache, SQL CPU, SQL DMV, SQL Server

Most frequently run queries can consume large SQL Server resources even when each call is fast; use plan cache and Query Store to find them.

Read More
SQL SERVER - 2005 - A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold

SQL SERVER – 2005 – A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold

March 4, 2008
Pinal Dave
SQL Performance
SQL Error Messages, SQL Index, SQL Scripts, SQL Server DBCC

The BOL script to defragment all indexes in a database above a declared threshold failed with Msg 2501. I fixed the missing schema prefix so it runs on SQL Server 2005.

Read More
SQL SERVER - Dynamic Case Statement - FIX : ERROR 156 : Incorrect syntax near the keyword

SQL SERVER – Dynamic Case Statement – FIX : ERROR 156 : Incorrect syntax near the keyword

February 28, 2008
Pinal Dave
SQL Performance
SQL Error Messages, SQL Scripts

Using CASE in ORDER BY to switch between ASC and DESC gives Error 156: Incorrect syntax near the keyword. I show two ways to write a dynamic case that works.

Read More
SQL SERVER - SELECT 1 vs SELECT * - An Interesting Observation

SQL SERVER – SELECT 1 vs SELECT * – An Interesting Observation

February 26, 2008
Pinal Dave
SQL Performance
SQL Scripts, SQL Server

SELECT 1 vs SELECT * inside IF EXISTS: I ran 4 tests and both gave the same result and the same execution plan cost. Can you find a case where they differ?

Read More
Performance counter dialog.

SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon

February 14, 2008
Pinal Dave
SQL Performance
SQL Utility

How to use Perfmon: three ways to start Performance Monitor, how to add counters, and how to log them over time so you can compare later.

Read More
SQL SERVER - Introduction to Three Important Performance Counters

SQL SERVER – Introduction to Three Important Performance Counters

February 13, 2008
Pinal Dave
SQL Performance
SQL Utility

Three basic but very important Performance Counters: % Processor Time, Avg. Disk Queue Length and Disk Read and Write Bytes/sec, and what their values mean.

Read More
Previous 1 … 113 114 115 116 117 118 119 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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