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
Aug30

SQL SERVER – Types of Triggers

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Trigger
4 Comments

The types of triggers in SQL Server include DML, DDL and logon triggers. A customer requested this three-part summary.

Continue Reading
Aug27

SQL SERVER – How to Break Mirroring?

Pinal Dave
SQL Tips and Tricks
SQL Mirroring, SQL Scripts, SQL Server
1 Comment

SET PARTNER OFF can break mirroring by permanently removing its relationship. I confirm the intended outcome before either command.

Continue Reading
Aug26

Trigger Blocks Index Maintenance: How to Let Rebuilds Pass

Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL Trigger
No Comments

A trigger blocks index maintenance when it guards every index event, because a rebuild is an index event too. This post shows the failure, then a trigger that reads EVENTDATA and lets rebuilds through while it still blocks create, drop and disable.

Continue Reading
Aug25

Prevent Unauthorized Index Modifications – SQL in Sixty Seconds #183

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Trigger
2 Comments

Many people asked me to create a video on the same topic, so we have Prevent Unauthorized Index Modifications. Here is the video.

Continue Reading
Aug24

Prevent Index Changes in SQL Server With a DDL Trigger

Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Server Security, SQL Trigger
No Comments

To prevent index changes in one database, create a DDL trigger on the index events that rolls back the statement and says why. This post tests the trigger, shows what it blocks, and lists the index changes that slip past it.

Continue Reading
Aug23

SQL SERVER – Trigger on Database to Prevent Table Creation

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Trigger
1 Comment

A Trigger on Database scope can reject CREATE_TABLE events. A customer required this rule, though I preferred ordinary permissions.

Continue Reading
Aug20

Index a Computed Column in SQL Server

Pinal Dave
SQL Performance
Computed Column, SQL Index, SQL Performance, SQL Scripts
No Comments

To index a computed column, define the formula once on the table and create a normal index on it. This post loads 200,000 rows, shows the scan, then the seek after the index, and tests the rules that decide whether SQL Server accepts the column.

Continue Reading
Previous 1 … 58 59 60 61 62 63 64 … 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