March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
Collection of Articles

SQL SERVER – COUNT(*) Collection of Articles

June 24, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Server

Today we are building a Collection of Articles that have recently generated interest on the blog as well as on the YouTube channel –  SQL in Sixty Seconds. 

Read More
COUNT

SQL SERVER – COUNT(*) and Index Used

June 15, 2021
Pinal Dave
SQL Performance
Clustered Index, Execution Plan, SQL Index, SQL Scripts, SQL Server

DBA suspects those operations are using lots of clustered index scans. Let us discuss today COUNT(*) and Index Used. Let’s learn.

Read More
index scan

SQL SERVER – Index Scans are Not Always Bad

June 11, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Scripts, SQL Server

Are Index Scans Bad? The answer No. Index Scans are Not Always Bad. This was in-depth discussed with my client during the Health Check.

Read More
parallel queries

SQL SERVER – Table Variables, Temp Tables and Parallel Queries

June 7, 2021
Pinal Dave
SQL Performance
Parallel, SQL CPU, SQL Scripts, SQL Server, SQL Variable, Temp Table

I heard an interesting comment from a client and that made me write a blog post. Their point was about table variables, temp tables, and parallel queries.

Read More
One Query

SQL SERVER – 3 Questions Answered on One Query Many Plans

June 4, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL Performance, SQL Server

Yesterday I published a video One Query Many Plans – SQL in Sixty Seconds #171 and I received lots of questions on the topic.

Read More
different entry

SQL SERVER – Same Result Same Query Plan – Different Entry in Cache

June 2, 2021
Pinal Dave
SQL Performance
Ad Hoc Query, SQL Cache, SQL Scripts, SQL Server

The question I was asked was about a query that had the same result same query plan but the different entry in the cache, is that possible.

Read More
Replace Rowstore

SQL SERVER – Replace Rowstore Clustered Index with Columnstore Clustered Index

May 28, 2021
Pinal Dave
SQL Performance
ColumnStore Index, SQL Column, SQL Scripts, SQL Server

Let us learn in this blog post how to Replace Rowstore Clustered Index with Columnstore Clustered Index. Comprehensive Database Performance Health Check

Read More
Previous 1 2 3 4 5 6 7 … 93 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version