I have taken space SQL Server 2008 database from a vendor. I have created 7 tables, 8 stored procedures and 3 tables. The number of lines of code in UDF and stored procedure is not more than 15-20 lines. And the average number of records in the table is 15.
I have asked my vendor regarding the space usage and he said 3MB. I am confused how so much space is used. What is the memory space tables, proc and functions take.