Calculate length of the text field

use DATALENGTH(fieldName)

CTE (Common Table Expression)

WITH MyNewTableName (Field1, Field2, Field3) AS
(
   SELECT
      x.Field1,
      x.Field2,
      x.Field3
   FROM Customers x
   WHERE x.Name like '%smith%'
)

SELECT *
FROM MyNewTableName
ORDER BY Field1

Create unique index on table

CREATE UNIQUE CLUSTERED INDEX idx_Books_id_title
ON Books (id, title)

Truncate time element from date range parameters