I just got an email containing this:

Luis,
Do you have any update on adding the indexes on production.

•   Task # 1

• Add more...

Or you could use LIKE.


SELECT *
FROM YourTable
WHERE YourColumn NOT LIKE '%[^a-zA-Z ]%';

There's a double negative there. It mentions to get the...

You can propose them to use ROT-5 encoding and even using it twice for improved security.
Then, you can let them know that they shouldn't be taking shortcuts on data...

Here's an option on how to do it. I'm not sure if it's the optimal way.

--Using SELECT
SELECT *
FROM #ACT o
OUTER APPLY (SELECT...

Or you could remove the REPLACE altogether with a different format code.
SELECT CONVERT (char(10), GETDATE(), 101) AS DOB

But I agree with leaving the formatting in...

I'll repeat it.
You're querying too many rows. The estimates show about 12M rows.
That said, I wonder what would happen if you add a JOIN hint. Try adding the...

The issue is that you're selecting all the rows. To be able to take full advantage of an index, you need to limit the results.
You're obfuscating the query by...