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

SQL SERVER – Counter Temp Tables For Destruction Not Working

July 25, 2020
Pinal Dave
SQL Tips and Tricks
SQL Counter, SQL Performance, SQL Scripts, SQL Server, SQL TempDB

They realized their counter Counter Temp Tables For Destruction Not Working and wanted me to help them. Let us learn about it today. 

Read More
different methods

What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261

January 26, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Counter, SQL DMV, SQL Scripts, SQL Server, SQL System Table, SSMS

Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.

Read More

SQL SERVER – APPROX_COUNT_DISTINCT – Not Always Efficient

December 11, 2019
Pinal Dave
SQL Performance
SQL Counter, SQL Function, SQL Scripts, SQL Server, SQL Server 2019

After a lot of testing, I figured out that the newly introduced function is not always efficient. A newly-introduced function APPROX_COUNT_DISTINCT.

Read More
workload

SQL SERVER – Identify Read Heavy Workload or Write Heavy Workload Type by Counters

August 24, 2019
Pinal Dave
SQL Performance
SQL Counter, SQL DMV, SQL Scripts, SQL Server

Let us understand how we can quickly identify the workload type of read-heavy or write-heavy by counters. Comprehensive Database Performance Health Check

Read More

SQL SERVER – WARNING – SQL Server Has Encountered N Occurrence(s) of I/O Requests Taking Longer Than 15 Seconds

May 15, 2015
Pinal Dave
SQL Tips and Tricks
SQL Counter, SQL DMV, SQL Error Messages, SQL Log, SQL Server

This is one of the most commonly asked questions via blog comments and emails sent across to me. Here is the sample error message which has been reported in SQL Server ERRORLOG. Let us learn about how to fix occurrences of I/O Requests taking longer. 

Read More
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version