2024-11-08
337 reads
Administration
2024-11-01
332 reads
Uncover SQL Server Missing Indexes
In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.
2024-10-18
How to Delete Large Amounts of Data in Microsoft SQL Server
A short look at some of the options for deleting lots of data from a SQL Server table.
2024-10-07
5,537 reads
Cleaning Up Your Database
How many of us clean up our databases and is it worth it? Steve has a few thoughts.
2024-10-02
230 reads
SQL Index Rebuild vs Reorganize Comparison
This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.
2024-09-30
2024-09-27
398 reads
Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes
This article explores how raising the Cost Threshold for Parallelism (CTFP) affects missing index recommendations in SQL Server along with examples.
2024-09-25
2024-09-20
421 reads
Auditing SQL Server – Part 4 – Database Configuration Audit
This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits. This section examines database configuration audits.
2024-09-18
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Removing the REST Endpoint in the Data API Builder
By Steve Jones
The more I work with the Data API Builder (DAB), the more I lean...
T-SQL Tuesday #182: Personal Integrity
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
Forums
Vector DB implementation using FAISS
Comments posted to this topic are about the item Vector DB implementation using FAISS
The Types of Changes
Comments posted to this topic are about the item The Types of Changes
Escaping Like I
Comments posted to this topic are about the item Escaping Like I
Question of the Day
Escaping Like I
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers