Knowledge Base

GetDBSize.sql

Script providing information about the space used by the data vs the space allocated.
Result:

GetNbRosw.sql

Script returning the Rows number according for a table. In the script example the table name is TB_TREND.
Result:

Note that you can get the same information by right clicking on the table / Properties / Storage.

Checking the time taken for SQL Server to execute one request

Use the following script:

SET STATISTICS TIME ON;
GO
…Here write your request as usual
GO
SET STATISTICS TIME OFF;
GO

After execution SSMS displays the time to execute your request.

Download attachments:

• GetDBSize.sql
• GetNbRows.sql