Join us March 28, 2024, as we discuss some of the most promising emerging cybersecurity technologies and how you can adopt them into your organizations.
You might wonder why I didn't consider transactional replication for distributing just the changes within a large snapshot to target servers. Let's look at a real-world example that illustrates the reason for my choice. Although using transaction...
I have a flat-file system and a SQL Server database that need to reflect changes to each other's systems. Completing the initial data upload is easy, but replicating the changes in each data store is difficult, especially changes in the flat files...
If you need to recover a database because a drive failure made your database unusable, you'll probably want to restore as many transactions as possible that finished before the failure. SQL Server Books Online (BOL) says that if the log file is s...
In June 2001, you mentioned that to avoid recompilations, thereby improving performance, you can "try coding the object owner for referenced tables, views, and procedures inside your stored procedures" when submitting a query (e.g., select col1...
Each page in a database has a file number and a page number that uniquely identifies its location in the database. When you restore a database, the pages keep their original file numbers and page numbers. Consequently, you must replace the restor...