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 ...
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 ...
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 ...
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 ...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
sql-server-2005 × 1325sql-server × 819
sql-server-2008 × 148
performance × 110
backup × 56
t-sql × 55
sql-server-2008-r2 × 52
replication × 48
index × 48
sql-server-2012 × 42
stored-procedures × 35
restore × 32
transaction-log × 25
query-performance × 24
database-design × 23
security × 23
migration × 23
permissions × 20
linked-server × 19
mirroring × 19
tempdb × 19
deadlock × 17
sql-server-2000 × 17
maintenance × 17
ssis × 16