its more than that - and it can be done with set based instead of a cursor assuming doing it in T-SQL alone.

but take in consideration this aspect you have...

because your node names is not reports/report but RECORDS/RECORD

cross apply c.nodes('/RECORDS/RECORD') as A(REPORT)

thats fine -

what I have, which is what I told you to get, is a I7, 6 core, 32GB ram , ssd disks.

I do heavy processing on it (db is...

and be careful with inserting data onto remote server through a linked server . it is EXTREMELLY slow as it does it a record at the time.

if there is any...

if you already have a good spec (you didn't tell us what you have) then you might be better off supplying us with some of your "bad behaved" queries and...

sorry but I did not say that is should be 10-20% max.

What I said is that in one of my servers (and we have over 800 SQL servers) we have...

get an I7/I9 with 6 cores+ and 32GB+ ram and some SSD disks.

you may also need to tweek max DOP and CTFP so your queries to not overload the machine....

• This reply was modified 5 years, 3 months ago by frederico_fonseca.

what may have left you bad was mixing cpu with log file growth.

although for SQL to grow a file it requires a small amount of cpu that is not enough...

can you supply a ACTUAL plan instead of estimated of a query with problems - a 1 row estimated is not an issue

on the plan you supplied your big issues...

not much you can do on this except remove the sort.

plan here https://www.brentozar.com/pastetheplan/?id=BJrAKS0RD

SELECT [DocumentCategory].[CategoryID] AS [CategoryID]
     , [DocumentCategory].[ProcessEvents] AS [ProcessEvents]
  ...

• This reply was modified 5 years, 3 months ago by frederico_fonseca.

stop mixing questions - you asked for something that was answered - thats it.

your last post is a completely different question - so raise a new thread for it.

But before...

if there is a FK column on that column and the column is not null(not sure if this one required) then if no column is retrieved from the other table...

regarding using "PKWare SecureZip" - this is a commercial software - I suggest you also look at 7zip - quite good and free.

all remaining comments above apply.

kind of you can.

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-server-permissions-transact-sql?view=sql-server-ver15

• View any database
• connect any database
• view any definition
• select all user securables

you can do it - but not easy.

option 1 - Sharepoint Excel Services - https://docs.microsoft.com/en-us/sharepoint/dev/general-development/excel-services-overview 

option 2 - use OpenXML https://github.com/OfficeDev/Open-XML-SDK - C# code - better as an independent...