yes - but by giving them those pages on a file...

you can - but it would be completely useless for any intents and purposes. small c# program open file binary, read first 25 pages (25*8k bytes) and do same for...

not wishing to minimize the article itself which I consider well written I wonder why would posting this on a SQL Server forum be a good idea.

No issues from a compatibility point of view for having both running on same box - obviously resource sharing is where one may impact the other but if both are...

not sure if it was just a typo but the example supplied is only adding a single quote to the item on the middle - so clarification on the requirements...

lots of things can cause that - but without table definitions (including indexes and FK's), row counts for each table, view definition as well as any function used within those...

LastName INCLUDE (ProductID, FirstName) and LastName INCLUDE (FirstName) are the same in this case as ProductID is the clustered index "key".

regarding your indexes I misread your original post.

LastName, DateDeleted INCLUDE(FirstName)WHERE...

was apply available on sql 2005?

your issue is not the ProductID but the DateDeleted. This last field is what is causing the key lookups as it is not part of the second index (ProductID is...

might be worth checking filenames of attachments - could also happen that someone adds a filename with special characters just in case it does not go through same code

try and change the keywords to match the EXACT casing for install as per documentation.

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver15

there were other users reporting errors where this sorted the issues they had.

setup.exe /UpdateSource="E:\SQL_2019\patches" /ACTION=Patch /AllInstances...

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...