those "mad" numbers show up frequently in certain plans - they should be ignored.

most of the times if you get a ACTUAL explain plan those numbers will be correct -...

regarding the temp folder you missed the point.

Assume a account named "SQLAccount" - your SQL instance runs under this account

this account will have a folder

c:\users\SQLACOUNT\AppData\Local\Temp

the account itself will obviously have...

• This reply was modified 1 year, 11 months ago by frederico_fonseca. Reason: add registry property name

Thanks for this response.  I'm only looking at it because it opens fine on my older server and not on the new one I am building.

I also have a...

you never answered the questions of how you loaded from their system onto SQL Server - neither on how you are extracting it and trying to save to a file...

smells like SPAM - but if not then you can look at this thread https://www.sqlservercentral.com/forums/topic/help-decoding-a-wait-resource-from-sysprocesses

and same questions asked there you can answer as well.

can you post the FULL entry of sysprocesses - all columns

@Grant Fritchey - pretty sure it is a cross database query (use db2, select from db1), so it should be using the same set of data and data structure,...

you should not be using that sysprocesses anymore and should instead be using one of the system views/functions. see https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/mapping-system-tables-to-system-views-transact-sql?view=sql-server-2017

the format can vary depending on resourcetype - one of the...

ZIP files are binary files so will not save correctly as a string. Binary can be encoded as a string although the size will obviously be increased. One way...

where is the current data used by the Delphi system?

and how did you copy it into your new table (and as I said it should be varbinary(max))

and can you ask...

whoever stored those in next likely caused them to be corrupted without repair.

zip files should have been stored as image or varbinary(max)

assuming they were stored correctly, e.g. no bytes have...

SSRS also uses outside SQL memory - but for many things (when executing queries and the likes) it fall under SQL memory.

on this I don't have details of how to...

If all of your code has NOLOCK - then enabling RCSI and not removing NOLOCK is just adding overhead for now useful purpose.  SQL Server will be maintaining...

only you can know what to allocate to each one based on the load each instance/process needs.

for info SSAS has 3 memory settings you will need to change - there...

SSIS and SSAS memory usage are totally separated from that of SQL Server - and the min/max memory settings on SQL do not affect those.

SSIS does not have a "max...