Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Usage of Temprory Table in Stored Procedure RE: Usage of Temprory Table in Stored Procedure

  • February 6, 2014 at 6:41 am

    #1686577

    wrote:

    Any additonal line of code (excluding comments) degrades the performance less or more...

    There is nothing wrong with using temp tables.

    Using static (permanent) tables, global temp tables and/or table variables will not avoide using tempdb, which whould be properly managed by DBA's (yes queries using just and only permanent tables also might use tempdb).

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]