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
Mar23

SQL SERVER – 2008 – Location of Activity Monitor – Where is SQL Serve Activity Monitor Located

Pinal Dave
SQL Performance
SQL Activity Monitor, SQL Utility
5 Comments

Can’t find the location of Activity Monitor in SQL Server 2008? It’s not under Tools. Open it from the Standard toolbar or by right clicking the server node.

Continue Reading
Mar22

SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users

Pinal Dave
SQL Tips and Tricks
SQL Activity Monitor, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security
6 Comments

In SQL Server 2008, Activity Monitor is empty for a user without the right permissions. Here is how to fix Activity Monitor for all users.

Continue Reading
Mar21

Optimize for Ad Hoc Workloads: Shrinking a Bloated Plan Cache

Pinal Dave
SQL Performance
Ad Hoc Query, Execution Plan, SQL Cache, SQL Server Configuration
20 Comments

One-off queries can fill your plan cache with plans nobody will reuse. Here is the setting that stores a stub instead, and how to check if you need it.

Continue Reading
Mar20

geometry STEquals: Equal Shapes Can Have Different Text

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

geometry STEquals compares the represented point set, which can stay the same when its text representation changes. I separate that question from byte-for-byte text identity. Reversing a line does not necessarily change the places it occupies.

Continue Reading
Mar19

SQLAuthority News – 900th Article – 9 Best Practices – Important Milestones

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, DBA, SQL Milestone, SQL Server
3 Comments

Today is my 900th article on this blog. You can see list of all the 900 articles here. I suggest you go over the list and read any article you like.

Continue Reading
Mar18

SQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Utility, sqlcmd
87 Comments

Find every SQL Server on network with one command: sqlcmd -L or osql -L lists the instances on your local network. An update to my old isql script.

Continue Reading
Mar17

SQL SERVER – Practical SQL Server XML: Part One – Query Plan Cache and Cost of Operations in the Cache

Pinal Dave
SQL Performance
Database, SQL Scripts, SQL Utility, SQL XML
4 Comments

A guest post from Michael Coles, author of Pro SQL Server 2008 XML: a practical XML demo that looks at the query plan cache and the cost of cached operations.

Continue Reading
Previous 1 … 715 716 717 718 719 720 721 … 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