Christopher Petrich

Update Statistics for databases where you have access

Run this stored procudure to update statistics for those SQL Server databases where you have permission

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

1.67 (3)

You rated this post out of 5. Change rating

2015-01-27 (first published: 2015-01-08)

1,242 reads

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

The more I work with the Data API Builder (DAB), the more I lean...

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

Vehicle loan ads are a powerful tool for increasing loan application rates by attracting...

Comments posted to this topic are about the item Vector DB implementation using FAISS

Comments posted to this topic are about the item The Types of Changes

I have this data in a SQL Server 2022 table:

PlayerIDPlayerNamePlayerStatus
1The \%ChampActive
2The ChampActive
3The_ChampionActive
4The__ChampionActive
5The\_ChampActive

How many rows are returned by this code in SQL Server 2022?

select PlayerName from player
where playername like 'The\_C%' escape '\'