Which are not being used/used rarely ?

The system view sys.dm_db_index_usage_stats will give you some useful information about index use, keep in mind this is since SQL Server was last restarted.

Which...

I guess it's not reporting the file name back in the error when you use a variable, you'll have to add that explicitly.

Ah right it's sending the errors to error output not standard out so it's not getting caught.  You can add this at the end of the entire script or after...

The issue is that Out-File overwrites the file so you're only seeing the last result.  You can either use -Append or Add-Content instead of Out-File.

Good lord... the things MS spends money on.  This seems a bit ridiculous to me especially when there's still so much in the product that needs to be...

I would think if your table is large enough for a column store index it's probably not a good candidate for memory optimized?

What do they mean by access to their data?  Do they want full access to the entire database?  Are there specific datasets they want to analyze?  Depending on what they...

We went back to our normal schedule last week which is 1 day at home 4 days in office last week.  And while I miss having a dress code of...

Well your for each loop should have a variable with the current file it's processing.  You'll need to do script foo on that to get the date out of it. ...

If these are validations that can't be done inline on your original query you could just make a cursor on that original query and loop through that.  Do the validation...

Hmm... you can insert records directly from a select statement, there's no need to insert them one at a time in a loop.

Why are you using the while loop at all?

Would just this work for the entire thing if you just want a list of records with a row num?

 

            
April 14, 2021 at 3:48 pm
            
#3871115

            
            
                                                
        

What is returned by your original query?

 

select dostamp,dilno,
ROW_NUMBER() OVER ( Order by datepart(yy,do.data), dostamp) row_num
FROM DO
where datepart(yy,do.data) = 2020 
group by datepart(yy,do.data), dostamp,dilno
having sum((edebfin+edebana ) - (ecrefin...

What is the primary key of the DO table if you script out the full key?

Not all bugs are created equal nor are the root causes of all bugs nor are all development teams.  Some bugs are trivials, which is why they weren't...