The passwords for SQL logins are stored hashed. SHA_512 in 2012, no idea if that's changed since then
http://sqlity.net/en/2460/sql-password-hash/

syslogins is a deprecated view, included only for...

headdesk

Tune your queries, that's often a far better return than adding memory.

And with 34GB memory, I would probably not go above 28GB on max server memory, and that's...

A seek operation requires that there is a value being searched for, and the column that is being searched is the left-most column of the index. That's the absolute minimum...

Why do you want the session_id?

The point of that report is to identify queries that need tuning to reduce their CPU usage.

Most likely some HDD failure that's corrupted the data file. That kind of thing is typically not repairable as you can't even open the database.

Restore from your last...

Please post new questions in a new thread, and give as much detail as possible.

Begin Tran ... Commit is about atomic operations and isolation, it's a transaction block. If you need the inserts, deletes and other things to be atomic, you need a transaction...

Crystal ball, please, someone.
https://www.sqlservercentral.com/Forums/1878960/Find-user-connections-to-SQL-server-tables

I'd love to help you, but I don't understand what exactly you want.

Does the client know that users don't connect to tables? If so, then what specifically are...

Connections aren't made to tables though. Users connect to databases, and run queries against tables.
Given that, what exactly are you trying to determine?

Both are valid options, go with whatever you enjoy more.

What exactly are you looking for?