What are you trying to determine?  Is there an issue you are trying to solve?  Or is this simply a learning exercise?

Your query only shows the last wait type for...

Oh, great.  So you found someone else's work to turn in as your own for a school assignment.

It appears that everything you need is outlined in the assignment sheet.

What have you tried?

I would start here

https://www.sqlskills.com/help/waits/memory_allocation_ext/

In your query, you are taking the MAX of IDMEASURE, not the MAX of IDMEASURE where the IDRESOURCE = 27.

Using your sample data, the MAX of IDMEASURE will be 21,...

This dev server is woefully inadequate for this job.  The shrink file in SQL server is also not the most efficiently written code. - DBCC ShrinkFile  is pretty...

I think the row_number it generate as long as gurantee each address row is only used once , address it is unique, it is OK. there is no specific...

You are in the process of removing the files currently stored as an image to a file storage location.  Until you finish this, I think you are probably wasting your...

I think of way that may do it. I can add a column named row_number in the query for each table, and join with the row_number to update  other...

How much memory is allocated to SQL on this server?  And how much activity is occurring when you are attempting this?

Take a look at this post.

https://sqljana.wordpress.com/2020/05/08/sql-server-fix-msg-1204-level-19-state-4-the-instance-of-the-sql-server-database-engine-cannot-obtain-a-lock-resource-at-this-time/

This is SQL 2005?

These errors are typically related to VMWare, and with the older versions of Windows as well as VMWare, Windows clustering is not supported.  This error is caused...

Why wouldn't you simply update one of the existing records?

UPDATE addMasterAddress

SET column = value...

WHERE AddressID = <whatever id you want to keep>

When you shrink in 1024 chunks, it should be sized at each chunk.  It does not "rollback" at the 98% failure.

What messages appear in the window when you execute a...

To add to what Michael is saying, if you DO get results BUT the results are "NULL" (the literal NULL, not a string), then your variable will also come...