May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • 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
UDF Inlining

SQL SERVER 2019 – Disabling Scalar UDF Inlining

August 1, 2020
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL Server 2019

Working on the Comprehensive Database Performance Health Check, we will learn how I helped a client by Disabling Scalar UDF Inlining in SQL Server 2019. 

Read More
percentage completed

SQL SERVER – View Percentage Completed for A Long Executing Query

July 13, 2020
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server 2019

During the consultation, we needed to check the status (View Percentage) of the few queries and for that, I quickly wrote a query which we will see today.

Read More
2019

Where to Download SQL Server 2019 for FREE? – Interview Question of the Week #276

May 10, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Download, SQL Sample Database, SQL Server, SQL Server 2019, SQL Server Management Studio, SSMS

Question: Where to Download SQL Server 2019 for FREE?

Answer: This is one of the most popular questions, I keep on receiving from blog readers.

Read More
contention

SQL SERVER – Resolving Last Page Insert PAGELATCH_EX Contention with OPTIMIZE_FOR_SEQUENTIAL_KEY

May 6, 2020
Pinal Dave
SQL Tips and Tricks
oStress, Primary Key, SQL Constraint and Keys, SQL Identity, SQL Scripts, SQL Server, SQL Server 2019, SQL Wait Stats, SSMS, Stress Testing

I have personally implemented the solution suggested of resolving contention about creating an index with OPTIMIZE_FOR_SEQUENTIAL_KEY at my client’s place.

Read More
product key

SQL SERVER – Product Key for Developer Edition, Enterprise Evaluation Edition and Express Edition

April 14, 2020
Pinal Dave
SQL Tips and Tricks
Product Key, SQL Server, SQL Server 2019

In this blog, I would share my findings and Product Key for Developer Edition, Enterprise Evaluation Edition, and Express Edition.

Read More
administrator rights

SQL SERVER – Install Error – The Account Running SQL Server Setup Does Not Have Administrator Rights On the Computer. To Continue, Use an Account With Administrator Rights

March 4, 2020
Pinal Dave
SQL
SQL Error Messages, SQL Server, SQL Server 2019, SQL Server Installation, SQL Server Security, Starting SQL

In this blog, I would share the steps to identify and fix error – The account running SQL Server Setup does not have administrator rights on the computer.

Read More
Truncating Data

SQL SERVER – Truncating Data and ANSI_WARNINGS

March 3, 2020
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server 2019, Temp Table

Today’s blog subject of Truncating Data and ANSI_WARNINGS was accidentally discovered while working on the Comprehensive Health Check.

Read More
1 2 3 4 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version