Welcome to Sign in | Help

Re: tabele temporare

  •  07-07-2009, 2:28 PM

    Re: tabele temporare

    Diana:

    *****
    PRINT 'Duration with table variable: ' + CAST(DATEDIFF(ms, @StartTime, getdate()) as varchar(10)) + ' ms'
    *****
    PRINT 'Duration with temp table: ' + CAST(DATEDIFF(ms, @StartTime, getdate()) as varchar(10)) + ' ms'



    Din cate stiu performanta nu are nici o legatura cu timpul de executie.
    Timpul de executie depinde de pc pe care ruleaza.

    Performanta depinde de sec CPU si Reads pe care le vezi intr-un SQL profiler :D

    Nu ?

    Multumesc,
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems