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
Mar5

SQL SERVER – Simple Example of Cursor – Sample Cursor Part 2

Pinal Dave
SQL Tips and Tricks
SQL Cursor, SQL Scripts
69 Comments

A reader asked me to update my Simple Example of Cursor with AdventureWorks. Here is a sample cursor that loops through ProductID and prints each one.

Continue Reading
Mar4

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

Pinal Dave
SQL Performance
SQL Error Messages, SQL Index, SQL Scripts, SQL Server DBCC
22 Comments

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.

Continue Reading
Mar3

CUBE: Include Every Two-Dimensional Subtotal Combination

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Reports, SQL Scripts, SQL Server
No Comments

CUBE requests every grouping combination of its dimensions, including independent subtotals and the grand total. I compare its output population with ROLLUP before choosing it. More subtotal families are useful only when the report needs them.

Continue Reading
Mar2

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

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Function, SQL Joins, SQL Scripts, SQL Server
94 Comments

Need TOP 1 and BOTTOM 1 in one result? UNION fails with two ORDER BY clauses. Here is a simple T-SQL way to retrieve TOP and BOTTOM Rows together.

Continue Reading
Mar1

SQL SERVER – Transfer The Logins and The Passwords Between Instances of SQL Server 2005

Pinal Dave
SQL Tips and Tricks
SQL Download, SQL Scripts, SQL Server Security, SQL Utility
41 Comments

How do you transfer the logins and passwords between instances of SQL Server 2005 after a hardware upgrade? I summarize Microsoft KB 918992 and its script.

Continue Reading
Feb29

SIN and COS: Use Radians for Trigonometric Inputs

Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server
No Comments

SIN and COS read angles in radians and return float. These explicit degree conversions show signs, axis angles and fractional results at a chosen decimal display scale.

Continue Reading
Feb28

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

Pinal Dave
SQL Performance
SQL Error Messages, SQL Scripts
14 Comments

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.

Continue Reading
Previous 1 … 773 774 775 776 777 778 779 … 846 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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