Common SQL Server commands

Dbccshowfilestats displays database space usage sp_spaceusedtb_Test displays table usage. If a non-dbo Scheme is contained, special processing is required. For example, if the scheme used by our table tb_Test is Dx, write as follows: sp_spaceused [Dx. tb_Test] When you write a query statement in the new query window

Dbcc showfilestats displays database space usage sp_spaceused tb_Test displays table usage. If a non-dbo Scheme is included, special processing is required. For example, if the scheme used in our table tb_Test is Dx, write as follows: sp_spaceused [Dx. tb_Test] When you write a query statement in the new query window

• Dbcc showfilestats

Show database space usage

• Sp_spaceused tb_Test

Displays the table usage

If a non-dbo Scheme is included, special processing is required. For example, if the scheme used in our table tb_Test is Dx, write as follows:

Sp_spaceused [Dx. tb_Test]

• When you write a query statement in the new query window, you want to know the execution status.

Select * from sys. dm_exec_requests where session_id = 58;

-- 58 indicates the session_id of the current window. The number is displayed in the window status bar.