Today's question (by Steve Jones - SSC Editor):

Can I create this view?

CREATE VIEW MyView
AS
WITH cteData (lowerbound, upperbound, letter, pwd)
AS (   SELECT
            SUBSTRING(datavalue, 1, CHARINDEX('-', datavalue) - 1) AS lowerbound
          , SUBSTRING(datavalue, CHARINDEX('-', datavalue) + 1, CHARINDEX(' ', datavalue) - CHARINDEX('-', datavalue) - 1) AS upperbound
          , SUBSTRING(datavalue, CHARINDEX(' ', datavalue) + 1, 1)
          , SUBSTRING(datavalue, CHARINDEX(':', datavalue) + 2, 50)
       FROM dbo.Day2 AS d
   )
   , cteSolution (occ, valid)
AS (   SELECT
            LEN(d.pwd) - LEN(REPLACE(pwd, d.letter, '')) AS occ
          , CASE
                WHEN LEN(d.pwd) - LEN(REPLACE(pwd, d.letter, '')) >= d.lowerbound
                     AND LEN(d.pwd) - LEN(REPLACE(pwd, d.letter, '')) <= d.upperbound THEN
                    1
                ELSE
                    0
            END AS valid
       FROM cteData AS d)
SELECT COUNT(*) totalcount FROM cteSolution WHERE valid = 1;
GO

Think you know the answer? Click here, and find out if you are right.

Reset Query Plan Stats

If I want to only reset the query plan stats for a specific plan, which stored procedure would I use?

Answer: sp_query_store_reset_exec_stats

Explanation: To reset query stats, sp_query_store_reset_exec_stats is used. Flushing the db and removing the plan do more than just reset stats. Ref: sp_query_store_reset_exec_stats - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-query-store-reset-exec-stats-transact-sql?view=sql-server-ver15

Discuss this question and answer on the forums

Here's a few of the new posts today on the forums. To see more, visit the forums.