I agree that this would delete all records where the CLF_LogReceivedTime is EARLIER than 30 days ago. It would have to be WHERE CLF_LogReceivedTime > DATEADD(DAY,-30,GETDATE()) to delete the records...

So I chuckled when i read that. The problem is that I need the column headings as part of a pivot task. Sorry I wasn't clear.

Jeff, thanks for the reply. So this data mart holds tables that store records of visits to healthcare facilities for all of Ohio. The Ohio Health Association sends out these...

I noticed in the article you linked to, SSC Guru, that SQL 2017 will not allow you to set ANSI NULLs off. If that is the case, how are we...

ok, so just to give anyone else with this problem the answer (yes I figured it out myself!!) all I had to do was to include the column_id in the...

Thank you! It did turn out to be an authority issue. Once I was given db_owner rights I could see the filters. It is strange and misleading information because someone...

Interestingly enough, I created the suggested non-clustered index on my columnstore table and ran the same query as before. While the suggestion of the index is gone, the index did...

Fortunately both databases are on the same server so that keeps other variables out of the mix. The only variable should be the difference in number of records. I like...

Don, I understand your need but unfortunately I cannot share my code. The table structures are proprietary to our EMR and the process is too complex to share in any...

Thanks for the info. Yeah, before I did the MERGE replacement, I did a lot of research on the difference and I saw the disadvantages and bugs. I did...

You know that is an interesting comment because I recently changed the code to use MERGE instead of separate INSERT and UPDATE processes. Removing and rebuilding the indexes was pretty...

I am dropping and recreating the indexes each time. I am using MERGE to update and insert records. Hope that helps.

Your article link goes to an article on how to post about performance problems. It does not talk about why the engine might choose to suggest an index that it...

When you do a SELECT...INTO statement, SQL wants to create the table you are selecting into. It's one of the most common ways to create a table in the first...

I see what you're saying. I actually do stage the data first and the staging table does have the same PK as the target table. Performance isn't terrible at all...