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
Jan15

Grid vs Text Output in SSMS: Why Line Breaks Disappear

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio, SQL String
1 Comment

Grid vs text output is a Management Studio setting that decides whether the line breaks in your data stay visible. This post builds a value with a line break, proves with T-SQL that the data holds it, and shows how to keep the break in each mode.

Continue Reading
Jan14

SQL SERVER – Move a Table From One Schema to Another Schema

Pinal Dave
SQL Tips and Tricks
Schema, SQL Scripts, SQL Server
3 Comments

ALTER SCHEMA can Move a Table between schemas within one database. A customer had imported under the wrong schema.

Continue Reading
Jan13

Generate a Date Range: List All Dates Between Two Dates

Pinal Dave
SQL Tips and Tricks
CTE, SQL DateTime, SQL Scripts, SQL Server
16 Comments

To generate a date range in SQL Server, number the days between a start date and an end date and add each number to the start. This post shows a recursive CTE, its limit of 100 recursions, GENERATE_SERIES, a version for older servers, and how to handle times and missing days.

Continue Reading
Jan12

Count Table in Cache – SQL in Sixty Seconds #149

Pinal Dave
SQL Video
Execution Plan, SQL Cache, SQL in Sixty Seconds, SQL Scripts, SQL Server
No Comments

Earlier I wrote how to find the count of tables used in queries from cache. Here is the Count Table in Cache video in SQL in Sixty Seconds.

Continue Reading
Jan11

COMPRESSION_DELAY Option for Columnstore Indexes: Test It

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

The COMPRESSION_DELAY option keeps a closed delta rowgroup uncompressed for a number of minutes, so rows that change soon after they arrive are cheaper to modify. This post loads two demo tables, updates fresh rows in each, and shows the deleted rows that early compression leaves behind.

Continue Reading
Jan8

SQL SERVER – MARK_IN_USE_FOR_REMOVAL Cache Scope and Costs

Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL Memory, SQL Scripts, SQL Server
1 Comment

To Remove Unused cache entries, I first inspect cache and workload evidence. My original intervention followed other customer tuning work.

Continue Reading
Jan7

Fragmentation in Columnstore Indexes: Find and Fix It

Pinal Dave
SQL Performance
ColumnStore Index, SQL Index, SQL Scripts, SQL Server
1 Comment

Fragmentation in columnstore indexes means deleted rows that stay inside compressed row groups, and row groups that are too small. This post builds a demo table, measures the deleted rows with the row group view, and compares REORGANIZE with REBUILD.

Continue Reading
Previous 1 … 81 82 83 84 85 86 87 … 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