Hi

I have a table as below, with example data in it

ID           Name 2346       M Smith 2346       M Smith 2346     ...

Network?  Busy-ness of the machine it's on?

I'm not good with time management.  No matter what I am doing I feel I should be doing something else.  This means that I am easily distracted.  The...

I really hope this isn't a dumb question. Is there a reason other then style or preference as to why you'd do this:

IF @Var1 = @VarA...

My goal was to demonstrate you don't need two cross apply.

SELECT          SUBSTRING(CONVERT(CHAR(9), DATEADD(MONTH, DATEDIFF(MONTH, 0, t.thedate), 0),...

This will sound strange but I'm actually really happy to...

I'm actually quite a bit surprised at you using an incremental recursive CTE for this, Peter.  Your code runs in < 1ms like the other two do but your code...

Using Steve's good test data, here's a slightly different method, which also provides the MMM DD format requested in the original post.  It's also the very first time that I...

Just my 2 cents...

 SELECT parent.*
        ,NewCol = CASE WHEN oa.Cnt > 0 THEN 'Mixed' ELSE 'Real' END
  ...

Ah, but it appears that may be operating under a really bad premise.  Changing a VARCHAR(200) to a VARCHAR(100) will, by itself, DO NOTHING to save on space. ...

Ah, but it appears that may be operating under a really bad premise.  Changing a VARCHAR(200) to a VARCHAR(100) will, by itself, DO NOTHING to save on space.  The only...

You, sir, are preaching to the choir.  I wish your DBA understood the actual value of those system generated column stats.

Thank you but the question above is basically...

I hate blanket statements like what you say your DBA said.  If he said that, he's wrong.  Building enough indexes to negate the need for ANY such column statistics would...

Please see the following link...

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-ver15

... and then search on that page for the words "doesn't reclaim" to answer your questions on why some of your actions made no difference.