WHERE column_name LIKE '1[67]-Nov-2017%' /* or '%1[67]-Nov-2017%' if the column doesn't start with the day */

Edit: Sorry about the formatting.  The site automatically "adjusts" (corrupts!) multiple spaces into fewer spaces.

SELECT start_date, end_date,
  CASE WHEN start_date >= '20140101' OR...

It's wasteful to store monthly, quarterly and yearly data in a daily table (actually, it's wasteful to store days in a year anywhere, since your year is a calendar year). ...

That's an Itzik Ben-Gap "Gaps and Islands" query.  Sorry, I don't have time now to fully flesh it out, but someone should come along shortly who can.

What is the underlying table clustered on?  If it's clus on identity, you should seriously consider clustering instead by date first, esp. if you (almost) always look up by date,...

I don't get any syntax errors.  That error must be because of some text/code before or after the main code.

But you will likely get exec errors, since the...

Btw, you might want to seriously consider using "UNION ALL" there rather than UNION.  I think you are going to force a massive sort of all the rows by using...

You're welcome!  I'm very glad it helped.

SELECT DATEADD(DAY, -DATEDIFF(DAY, 0, [Order Date]) % 7, [Order Date]) AS [Week of],
  COUNT(*) AS Count
FROM dbo.your_table_name
GROUP BY DATEADD(DAY, -DATEDIFF(DAY, 0, [Order Date]) %...

You should pre-allocate enough log space to handle the request.  The alter should be much faster if the log does not have to dynamically expand.  You should do the expansion in...

You should only rebuild a 60GB index if and when you have a really, really compelling reason.

I'd suggest specifying "SORT_IN_TEMPDB = ON" for large rebuilds, unless you have...