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 1 year, 5 months 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 results will...

and the views used? user_Type_mgmt is a view as well - but in this case I don't think it won't matter its content

if you can replace this query and stop...

and corresponding info for old server?

once I have time I'll dig a few scripts to extract a different set of info - but nothing special on the above (other than...

I'm more interested on the server info -  did you run it with the flag I mentioned? it should not have returned any specific database information.

CU you should definitely upgrade...

can you also download and install sp_blitz (https://www.brentozar.com/blitz/) - you only need to install sp_Blitz.sql - this will add a few SP's to the database you run it on

and then...

or define variable outside cursor and delete it in each loop - only feasible if the table variable does not have a identity column which needs reseed - see https://www.grapefruitmoon.net/table-variables-identity-columns-and-reseeding/

but...