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
Aug26

SQL Server Express Limits: A Complete Reference Guide

Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Server, SQL Server Configuration, SQL Server Express
11 Comments

SQL Server Express limits depend on the version you install. This guide lists the database size limits for 2008, 2022 and 2025, and gives tested queries to check the edition, the allocated data space, the free headroom and a verified backup.

Continue Reading
Aug25

ISO Week Numbers vs DATEPART(week): Grouping Sales by Week

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Group By, SQL Server
1 Comment

Group sales by ISO week and ISO year, compare DATEPART week behavior, and avoid New Year errors caused by session settings.

Continue Reading
Aug24

SQL SERVER – Index Seek vs. Index Scan – Difference and Usage – A Simple Note

Pinal Dave
SQL Performance
SQL Index, SQL Server
31 Comments

Index seek vs. index scan: the two ways SQL Server reads data through an index, how they differ, and when each one is used. A simple note.

Continue Reading
Aug23

Raising a Database Compatibility Level Safely

Pinal Dave
SQL Performance
Compatibility Level, Query Store, SQL Performance, SQL Server
1 Comment

Raise a compatibility level safely by capturing a Query Store baseline, changing one database, comparing plans, and keeping a tested reversal.

Continue Reading
Aug22

sys.objects, sys.all_objects and sys.system_objects

Pinal Dave
SQL Tips and Tricks
DBA, SQL Server, SQL System Table, System Object
1 Comment

Compare sys.objects, sys.all_objects and sys.system_objects to find SQL Server user objects, system objects, and metadata visibility gaps.

Continue Reading
Aug21

SQL SERVER – Get Query Plan Along with Query Text and Execution Count

Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL System Table
22 Comments

A handy script that shows each query’s text, its execution count and its query plan, so you can see what runs most often on your server.

Continue Reading
Aug20

SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server Security
225 Comments

Getting Cannot open database requested by the login for NT AUTHORITY\NETWORK SERVICE? Map that login to your database under User Mapping.

Continue Reading
Previous 1 … 691 692 693 694 695 696 697 … 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