Gaurav

Better to start a new topic for a new question.  But I don't advise you to constantly change the job once it's set up.  You should alter your...

Then use your favourite scripting language to search the CSV file for "0,00" and replace it with "0".  Better still, explain to the user that he's wrong to want his...

I often wish that SELECT INTO didn't exist, because I find it's often abused.  You've nailed it, though - create the table once and then it's always there for you,...

Please don't do this.  If your 0 is accurate to two decimal places, you should show 0.00 instead of 0.  Otherwise, how do you know it's not 0.04 or 0.3...

INSERT INTO @FillistOnlyTable 
RESTORE FILELISTONLY 
FROM DISK = 'D:\BBBACKUP_2017\RC\FEBRUAR\easyplan-drift-170216-after.bak'

John

Have you tried renaming the old database before you do the restore?  Then you don't need to rename the new database, and if this problem is being caused by the...

OK, so your rowmodctr isn't anywhere near the threshold at which it updated last time.  How many rows are there in your table?

Leaving all that aside, you'll still...

Having sa own all databases isn't a good security practice.  Have a look at this article.  We go with number 5 in the Possibilities section here.  Adi is...

Depending on things like fragmentation and fill factor, having a clustered index doesn't use any more disk space than not having one.  This is because a clustered index is nothing...

Take a look at this article.  There are several reasons why your statistics may not have updated.  May be auto update stats isn't turned on.  Maybe your table...

If you aren't using the while loop any more, what method are you using to delete in batches?  Is the whole thing running in an explicit transaction, by any chance?

This is a SQL Server forum and you're asking for a Powershell solution; allow me to propose a SQL solution instead.  Why not import each CSV file (using bcp, BULK...