Performance and Tuning

This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.38 (76)

You rated this post out of 5. Change rating

2016-08-05 (first published: 2015-06-09)

19,467 reads

Query Performance Tuning – A Methodical Approach

Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.56 (50)

You rated this post out of 5. Change rating

2017-02-10 (first published: 2015-06-08)

16,703 reads

Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...

How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...

Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...

Hello! SQL Clustered resource used to come online during manual or automatic failover in...

Code that can be used in order to create dashboard or SSRS report on...

So, I have an interesting situation that I need a double-check on. One of...

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 '\'