you have already been advised in your other threads around this process to review how its done and scrap it - you are keeping a wrong approach to a problem...

Product name is not required. - however if it is supplied through the UI as "SQL Server" the other fields (@provider, @datasrc, @location, @provstr, and @catalog ) don't need to...

you mean which one of these?

• using xp_cmdshell from a stored proc
• or use a SQL Job with a sqlcmd step
• or just use sqlcmd on the command line

and when...

thats an invalid format file for what you need.

see  https://jahaines.blogspot.com/2009/10/exporting-binary-files-to-file-system.html for a full example of what you can do - and you should likely reconsider using bcp for...

yes tempdb has been subject to significant changes. majority were done with 2016 - see https://learn.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database?view=sql-server-ver16

you will likely need the CU+GDR version - https://support.microsoft.com/en-us/topic/kb5029376-description-of-the-security-update-for-sql-server-2017-cu31-october-10-2023-ce23ddf7-b79e-4ba7-ba9d-2679f23a1ad8

Thank you,  I ran blitz and also installed sp_whoisactive (nifty tool).

I have GDR 14.0.2052.1 - do I need a CU as well?  Does the Query Store affect performance -...

SSRS (And power bi report server is a superset of this) is a licensed feature - as such it requires the server it is installed on to have a valid...

Thank you for your excellent directions - I should have read it more closely:-)  I've run them on the 2017 box.  Should I run it on the 2008 box...

did you run the cmd file that I supplied with the 3 commands on it? your reply does not indicate you did it as I asked.

or maybe you did run...

• This reply was modified 6 months, 1 week ago by  frederico_fonseca.

the issue with trying this at a DB level is that you are not proving anything - if the OS/VM/Storage is badly configured then ALL the IO is going to...

Jeff will no doubt add something here - do heed his advise.

but as mentioned (and as you yourself raised as an issue) partitioning should only be used when most of...

one one of your other posts you mentioned that your VM's were Vmware - AWS and AZURE are a totally different kettle of fish and settings for those are way...

see the other threads from the OP - using a sql...

this is a waste of time in my opinion - see history behind this request at https://www.sqlservercentral.com/forums/topic/degraded-performance-in-2017-vs-2008-r2-with-inserts

I can run this code in multiple servers, with different specs and...