USE TreinamentoDBA

--Datatype numeric
--https://msdn.microsoft.com/en-us/library/ms187746.aspx?f=255&MSPPError=-2147217396

IF OBJECT_ID('Teste_Numeric_9') IS NOT NULL 
	DROP TABLE Teste_Numeric_9

IF OBJECT_ID('Teste_Numeric_15') IS NOT NULL 
	DROP TABLE Teste_Numeric_15
		
CREATE TABLE Teste_Numeric_9(
	Campo NUMERIC(9,2))

CREATE TABLE Teste_Numeric_15(
	Campo NUMERIC(15,2))

INSERT INTO Teste_Numeric_9(Campo)
SELECT 100
GO 10000

INSERT INTO Teste_Numeric_9
SELECT Campo FROM Teste_Numeric_9
GO 10

INSERT INTO Teste_Numeric_15(Campo)
SELECT 100
GO 10000

INSERT INTO Teste_Numeric_15
SELECT Campo FROM Teste_Numeric_15
GO 10

EXEC sp_spaceused Teste_Numeric_9
EXEC sp_spaceused Teste_Numeric_15

SELECT 142.2/182.5 --22% menos