SQL Server Performance

Search Results

Search Again
  1. anilsaritha

    TempTable Vs Derived Tables

    Thread by: anilsaritha, Nov 8, 2006, 3 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    Dear Gurus Temp tables increases the performance or derived tables increases the performance? Here below i am posting a query which i had created...
  2. anilsaritha

    Which one is faster

    Thread by: anilsaritha, Oct 31, 2006, 3 replies, in forum: General Developer Questions
    Gurus Of the following two queries which one will execute faster Query 1 SELECT NoOfShr,ShrAmt from CUS_tShrInstLdgrHdr WHEREBrID =...
  3. anilsaritha

    Row_Number()

    Thread by: anilsaritha, Sep 19, 2006, 7 replies, in forum: General Developer Questions
    Dear guru's Is it possible to bring in the functionality of Row_Number function in Sql2000?. Some hotfixes available? Deep regards Anil...
  4. anilsaritha

    exec sp_reset_connection

    Thread by: anilsaritha, Sep 15, 2006, 3 replies, in forum: T-SQL Performance Tuning for Developers
    Dear Gurus Below is the trace capture of a save action of one of my forms This save action takes 11 seconds at our office and it takes 20 seconds at...
  5. anilsaritha

    Query that returns table name,index name

    Thread by: anilsaritha, Sep 12, 2006, 5 replies, in forum: General Developer Questions
    Dear gurus Kindly help me in getting the query that returns the Tablename,IndexName and fieldname for the entire database Deep Regards Anil Never...
  6. anilsaritha

    Lock request time out period exceeded

    Thread by: anilsaritha, Aug 9, 2006, 1 replies, in forum: T-SQL Performance Tuning for Developers
    Friends<br /><br />Below is the exception information from my production server's event log file<br />1) Exception Information<br...
  7. anilsaritha

    SP to Identify SP's That are causing locks?

    Thread by: anilsaritha, Aug 7, 2006, 4 replies, in forum: T-SQL Performance Tuning for Developers
    Friends I have got lots of tips and helps from This forum. Hope you gurus can throw some light into my following issue also Is there a tool or an...
  8. anilsaritha

    SP Execution Time Difference

    Thread by: anilsaritha, Jul 16, 2006, 4 replies, in forum: T-SQL Performance Tuning for Developers
    Dear Friends I am having a typical problem I am working in project that deals with a bank that has got 40 branches.Intially the bank has given us a...
  9. anilsaritha

    Analyzing a Execution Plan

    Thread by: anilsaritha, Jul 13, 2006, 1 replies, in forum: T-SQL Performance Tuning for Developers
    Dear Friends<br /><br />On Executing a particular Sp I am getting several queries of which i am mentioning the execution plan of the query that costs...
  10. anilsaritha

    Interpretation of Query Execution Plan

    Thread by: anilsaritha, Jul 4, 2006, 3 replies, in forum: General Developer Questions
    Friends<br /><br />Can somebody guide me in interperting a query execution plan<br /><br />Here is a scenario<br />Somebody kindly interpert this<br...
  11. anilsaritha

    Results in a single Row Seperated By Commas

    Thread by: anilsaritha, Jul 3, 2006, 7 replies, in forum: General Developer Questions
    Friends Execution of The Following Query gives me a result as shown below Select IsNull(CMst.MemFName,'') + ' ' +...
  12. anilsaritha

    Time Difference in Execution Of Sp

    Thread by: anilsaritha, Jun 22, 2006, 10 replies, in forum: T-SQL Performance Tuning for Developers
    Friends<br /><br />I am facing a Problem that's bit worrying[|)]<br /><br />I am having an Sp by the name IRC_SPrdIntCalc<br />Execution Time Of This...
  13. anilsaritha

    Cumulative Insert Query

    Thread by: anilsaritha, Jun 13, 2006, 3 replies, in forum: General Developer Questions
    Folks I am having a Scenario which is as follows. Consider That there is a table with the name DEP_tAcctBalnHisthdr with the following data...
  14. anilsaritha

    Difference Between Row Lock And UpdLock

    Thread by: anilsaritha, Jun 8, 2006, 4 replies, in forum: General Developer Questions
    Folks Kindly Tell me the Differences between RowLock And UpdLock? Deep Regards Anil Never Give Up
  15. anilsaritha

    Changing The Connection String

    Thread by: anilsaritha, Jun 6, 2006, 1 replies, in forum: SQL Server Reporting Services
    Friends Is there a way to change the connection string in Reporting Services Through Sql Scripts Deep Regards Anil Never Give Up
  16. anilsaritha

    Dead Lock Issue

    Thread by: anilsaritha, May 11, 2006, 30 replies, in forum: T-SQL Performance Tuning for Developers
    My Dear Folks<br /><br />I am facing a problem of dead locks.<br />Obviously dead locks can be handled by well formed queries.<br />To be very frank...
Showing results 1 to 16 of 16
Search Again