There is not any changes made in database.

and storage on network drive does was not issue because other servers database back up was also stored at network place.

Can you give...

Is it a local or remote backup? What kind of storage?

Ans: we store back up on network drive.

How long is your full backup take?

Ans: Full back up takes 4...

Every Monday, Wednesday & Friday Full Back Up Process Run.

Every Sunday Index Rebuild and statistics Update Process Run.

Differential back run every 3 hours.

It is best practice to add zipcode in Inner Join Instead of where clause.

Because when you use In Operator It consume more memory rather than other.

You can use BIGINT Or varchar(Max) Or NVARCHAR(max) for this.

please Use below example for ref:

DECLARE @temptbl TABLE (ID [nvarchar](max))

INSERT INTO @temptbl (ID)

VALUES (N'9999999999999999999999999999999999999999')

SELECT * FROM @temptbl t

Go with your example:

1 Aaron ...... 1 db_reader

1 Aaron ...... 2 db_writer

2 Ben ....... 1 db_reader

The second row_number also doesn't work first they assign "1" Number for db_reader and "2"...

Row_Number With Partition Returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. And Dense Rank...

Food.