Home Forums SQL Server 2008 SQL Server 2008 - General Which is the faster ? RE: Which is the faster ?

  • January 21, 2014 at 8:53 am

    #1681995

    Jeff Moden (1/20/2014)

    devu (1/20/2014)

    Hi all,

    I want to know which is the faster group of select statement or stored procedure with same select statements ?

    Thanks.

    My question would be, why don't you just try it and find out for yourself?

    +1

    Start with Profiler, watching the CPU, Read, Write, and Dur columns, for the SQL:BatchCompleted and RPC:Completed events, filtered on your SPID (session_id) if you're using SSMS, and on your host name and application name and perhaps even some of the text of the query if you're using an app/website/etc.