Post reply

Memory for Decimal data type

  • November 21, 2011 at 3:43 pm

    #260457

    I just wanted to know how much memory is used when I declare a variable @test-2 with decimal (18,2)? Does this data type behave like a varchar value.

    Thevariable @test-2 can also hold large values or even small values like 58.14. So in my stored procedure i wanted to declare this variable as decimal(18,2).Will this cause any performance issues?How much space is used when the value is null.

  • November 21, 2011 at 4:04 pm

    #1411095

    You can use this to determine the memory required

    http://msdn.microsoft.com/en-us/library/ms187746.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply