5 votes

Upgrading out of support Microsoft SQL instance multiple questions?

The bitness of the backup does not affect anything. What does affect things is the version of the backup. Backups before 2005 cannot be restored without an intermediate step, but 2005 is fine to ...
Charlieface's user avatar
  • 12.7k
2 votes
Accepted

Is it possible to create fast (ram only) temporary table for inter software communication purposes in MS SQL Server?

It does seem, based on the question, you have an XY problem. Taking the spirit of the question, though, you'll really only have a few options. SQL Server 2005 (wayyyy out of support) to SQL Server ...
Sean Gallardy's user avatar
2 votes
Accepted

Understanding table locking in MS SQL TSQL Transactions

Is my understanding correct that the table lock acquired during SELECT MAX() operation (and possibly others in the same transaction) holds until the entire transaction is finished with the COMMIT ...
Charlieface's user avatar
  • 12.7k
2 votes

Understanding table locking in MS SQL TSQL Transactions

Is my understanding correct that the table lock acquired during SELECT MAX() operation (and possibly others in the same transaction) holds until the entire transaction is finished with the COMMIT ...
David Browne - Microsoft's user avatar
1 vote

Find transactions that are filling up the version store

As Aaron Bertrand's answer to this question is one of the most useful ones I found regarding this topic, I want to share my experience: For me dm_tran_top_version_generators generates arithmetic ...
Andre Schmitz's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible