Not sure why you are focusing on logical reads.  You do realize that those are reads from memory, and depending on how much data you are accessing, that number could...

I was trying to keep people from posting on the other threads as well, which is why two of them referenced back to the thread I actually replied on.

SELECT ABC, COUNT(ABC) FROM dbo.YourTableNameHere GROUP BY ABC;

Please see this thread: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15

Please see this thread: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15

If you read the documentation about LIKE (https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15) you will see that it does not support regex the way you are trying to use it.

For the OP.  I spent some time looking at the execution plans and the code you posted.  I have come to the conclusion that there just isn't enough here for...

edit:  Wrong post.

• This reply was modified 6 years, 3 months ago by Lynn Pettis.

There are proprietary temporal functions for formatting dates and working with them. Your code will never port to another SQL product. For example, the ANSI/ISO standard SQL uses the...

May I be honest?  Comparing the two plans, the original view is better that the your rewrite.  Your rewrite, looking at the plan in SentryOne Plan Explorer timed out trying...

Not exactly what you mean by reset/delete,  reset can have a different meaning than delete.  If you are talking about deleting all the data from the table once a week...

• This reply was modified 6 years, 3 months ago by Lynn Pettis.

Look up the date function date_part.

That is a simple question to answer.  The reason it doesn't throw an error in the second query is because of how SQL Server works with subqueries.  Since you are...

That was going to be my exact question.......

Still curious as to WHY you were using CTEs to accomplish your task.  It was just as easily done using the tables themselves.  Compare the code below.

IF...