SQL Server Performance

Search Results

Search Again
  1. Hillside

    Stroed proc:Slow on SSMS and fast from application

    Post by: Hillside, Sep 22, 2009 in forum: SQL Server 2008 T-SQL Performance Tuning
    Hi, The database is on different server which has SQL Server 2005 developer edition with SP2 The java application and SSMS we running from Client PC...
  2. Hillside

    Stroed proc:Slow on SSMS and fast from application

    Thread by: Hillside, Sep 21, 2009, 4 replies, in forum: SQL Server 2008 T-SQL Performance Tuning
    Hi, Stored procedure takes 50 mints if we run from SSMS(SQL Server 2005 Developer edition) and same store proc takes 2 mints from Java applcation...
  3. Hillside

    automatic compression of a backup within a job

    Post by: Hillside, Sep 4, 2008 in forum: SQL Server 2005 General DBA Questions
    I do same job using command prompt calling from sp. Look into 7zip or rar exe to run from command prompt then use is same in your stored procedure....
  4. Hillside

    I need resultset in View and dont want to use function because of performance issue

    Thread by: Hillside, Aug 4, 2007, 5 replies, in forum: SQL Server 2005 General Developer Questions
    Hi all I have 2 tables as follows: TABLE 1TABLE 2 IDSmallDateDecimalValueIDSmallDate 5921/12/2005 00:003.6600121/12/2005 00:00 5928/12/2005...
Showing results 1 to 4 of 4
Search Again