Oct 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

The Intricacies of T-SQL String Comparison: LIKE VS ‘=’

October 4, 2023
Pinal Dave
SQL Performance
Query Rewrite, SQL Index, SQL Performance

Let us learn The Intricacies of T-SQL String Comparison. In SQL, the way you compare strings can greatly impact the results of your queries.

Read More
temptable

SQL SERVER – Performance: Optimizing High Volume OR Conditions through TempTable

October 2, 2023
Pinal Dave
SQL Performance
Query Rewrite, SQL Operator, Temp Table

We explore an alternative approach when dealing with high volumes of ‘OR’ conditions in our SQL queries: the use of a TempTable.

Read More

SQL SERVER – Manage Database Size with DBCC SHRINKDATABASE and WAIT_AT_LOW_PRIORITY

September 29, 2023
Pinal Dave
SQL Performance
Shrinking Database, SQL Server DBCC

In this blog post, we will explore the DBCC SHRINKDATABASE command and its options, focusing on the WAIT_AT_LOW_PRIORITY feature.

Read More
CHARINDEX

SQL SERVER – A Comparison of CHARINDEX vs LIKE

September 26, 2023
Pinal Dave
SQL Performance
Query Rewrite, SQL Function, SQL String

In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.

Read More
Incremental Statistics

SQL SERVER – Understanding Incremental Statistics

September 19, 2023
Pinal Dave
SQL Performance
SQL Index, SQL Statistics

Statistics are updated automatically or manually rebuilt using full scans, can resource-intensive for large tables. Incremental Statistics.

Read More
WHERE clause

SQL SERVER – Avoid Functions in the WHERE Clause for Performance

September 13, 2023
Pinal Dave
SQL Performance
Query Rewrite, SQL Function

Using SQL Server functions in the WHERE clause of your queries can significantly impact performance. Let us explore that in this blog post.

Read More
brent pinal

SQL SERVER – Performance: OR vs IN – A Summary and Further Reading

September 12, 2023
Pinal Dave
SQL Performance
Clustered Index, Computed Column, SQL Index, SQL Server

The varied responses led me to write a detailed blog post to clarify the correct answer. If you missed it, you can read it here. Let us see A Summary and Further Reading.

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

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

Go to mobile version