I want to explain the importance of manual experiments.

I would like to explain the importance of manual experiments. Sometimes a person may have a lot of ideas, or you may have an idea when you see others' articles, or, if you want to verify others' opinions, you need to manually perform experiments to verify them. The idea is everywhere. For example, if I delete a piece of data, can I use the transaction log [fn_dblog] ()? restore him

I would like to explain the importance of manual experiments. Sometimes a person may have a lot of ideas, or you may have an idea when you see others' articles, or, if you want to verify others' opinions, you need to manually perform experiments to verify them. The idea is everywhere. For example, if I delete a piece of data, can I use the transaction log [fn_dblog] ()? restore him

I want to explain the importance of manual experiments.

Preface

Sometimes a person may have a lot of ideas, or you may have an idea when you see others' articles, or you may want to verify others' opinions.

At this time, we need to manually do experiments to verify that the idea is everywhere.

For example, if I delete a piece of data, can I restore it through the transaction log [fn_dblog? Can I write

Database restoration tool to restore Deleted Data ???

You need to constantly think about how to design experiments and prove your ideas with the knowledge you have learned.

For example, I see an article titled using a computed column with a Persisted value in SQL Server.

Article address:

Idea: will the computed column data with the Persisted value be stored on the disk ???

With this question in mind, we will conduct the following experiment:

Hands-on Lab

Use the following SQL code to create a test environment

. (, ()-(1) PERSISTED 9) CCTest (empNumb, DOBirth), dbo. CCTest28 GO