I have a suspicion that the same behavior would have been seen in SQL2016, but no proof and no reason to personally research it at the moment. BTW...we are...

Hi,

I am doing STUFF in my query which is concatenating the blank data too and data looks like below. Sometimes there is space+comma and sometimes only comma in the...

Thanks for the detailed followup.  Just to be sure, though... the problem/observations that I posted appear to be the same problem and it's with 2016, not 2017.  Did I "get...

Not heaps. They do have clustered indexes as primary keys.

Most are BULK inserted to.

Rebuilding the indexes does help to recapture the space, but it only starts building again, which...

Thanks for the feedback, Paul.  The articles of yours that I provided a link to are awesome.  I'm still testing a bunch of things based on your excellent documentation.  Thank...

No.  Not quite right.  I hope you've recently taken a full backup.  If so, then you can take your log file backup and then immediately do a shrink if you...

Ok... first of all, you didn't say anywhere else that this was a "UAT" box.  I thought it was a prod box because you were talking about licensing costs, etc. ...

This is a duplicate post and it's actually incomplete.  Please, no replies here.  See the following post instead.  It's also been answered but don't let that stop you if you...

And now I see that you've posted while I was constructing a response.  You can't actually insert into a TIMESTAMP datatype in SQL Server.  With that in mind, which RDBMS...

Here's one simple method provided those are actual NULLs and not just a word of '[NULL]':

 SELECT  ProcessID
        ,IsCompleted...

Oh... almost forget... your question was...

The answer is, the system knows. ...

• This reply was modified 6 years, 7 months ago by Jeff Moden.

I'd worry about memory but not in the way you distributed it.  You have a fair number of fairly large databases.  Adding memory is generally the single best hardware improvement...

My first observation is that there is no index to support this query even if the "table" was in good shape.  You could try the following indexes to see if...

To answer your question, there will be no difference in performance or resource usage.  The only difference is that the first rendition could be created as a stored procedure and...

p.s.  You might want to check out the OBJECT_NAME(object_id [, database_id]) and OBJECT_SCHEMA_NAME(object_id [, database_id]) functions.  They can greatly reduce the number of joins you have to do for things...