SQL Server Performance

Search Results

Search Again
Page 1 of 10
  1. Roji. P. Thomas

    Query

    Post by: Roji. P. Thomas, Apr 30, 2007 in forum: T-SQL Performance Tuning for Developers
    The query should be SELECT S.*, A.* FROM ServiceRequest S INNER JOIN (SELECT srID, MIN(Created) AS created FROM Activity A GROUP BY srID) A ON...
  2. Roji. P. Thomas

    Query

    Post by: Roji. P. Thomas, Apr 29, 2007 in forum: T-SQL Performance Tuning for Developers
    SELECT S.*, A.* FROM ServiceRequest S INNER JOIN (SELECT srID, MIN(Created) FROM Activity GROUP BY srID) A ON A.srID = S.rowId Roji. P. Thomas...
  3. Roji. P. Thomas

    4K to Adriaan

    Post by: Roji. P. Thomas, Apr 24, 2007 in forum: Forum Statistics
    Good work buddy... Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com
  4. Roji. P. Thomas

    varchar(max) vs varchar(2000)

    Post by: Roji. P. Thomas, Apr 23, 2007 in forum: SQL Server 2005 General DBA Questions
    My suggestion is, always use a fixed size when 1. Its not more than 8000 2. You don't see a need to readjust the size in the near future. Roji....
  5. Roji. P. Thomas

    why am I getting logged off?

    Post by: Roji. P. Thomas, Apr 23, 2007 in forum: Please Tell Us What You Think
    Well, I am also experiencing the same prob. Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com
  6. Roji. P. Thomas

    See whether your habit falls under this list!

    Post by: Roji. P. Thomas, Apr 23, 2007 in forum: The Lighter Side of Being a DBA
    11. You dial zero before you dial any number. 12. You swipe your access card before you unlock the door of your apartment. Roji. P. Thomas SQL...
  7. Roji. P. Thomas

    Insert Multiple Rows within a Single Round Trip

    Post by: Roji. P. Thomas, Apr 18, 2007 in forum: Performance Tuning for DBAs
    yep. XML is an option Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com
  8. Roji. P. Thomas

    GROUP_CONCAT OF MySQL

    Post by: Roji. P. Thomas, Apr 18, 2007 in forum: SQL Server 2005 General Developer Questions
    quote:Originally posted by sachinonnet 1. can i create CURSORS inside Views if yes please give me more information on it. 2. the function will...
  9. Roji. P. Thomas

    How to use OPTION (FAST n) ?

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: Performance Tuning for DBAs
    With the OPTION Fast N, The query is optimized to return the first n records immediately. But this depends on the plan SQL server chooses for the...
  10. Roji. P. Thomas

    Welcome to the Getting Started Forum

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: Getting Started
    I'll concentrate here [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Roji. P. Thomas<br />SQL Server MVP<br /<a...
  11. Roji. P. Thomas

    15K to Satya

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: Forum Statistics
    We were just kidding, as always, that you use a robot to answer questions in the forum very fast and accurately [<img...
  12. Roji. P. Thomas

    Add description at table level

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: SQL Server 2005 General Developer Questions
    You can add Description in the properties box, when the design table window is open. Or you can sue sp_addextendedproperty Roji. P. Thomas SQL...
  13. Roji. P. Thomas

    Storing text and image

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: SQL Server 2005 General DBA Questions
    Ah that brings the memories of Jim Gray http://en.wikipedia.org/wiki/James_N._Gray Roji. P. Thomas SQL Server MVP...
  14. Roji. P. Thomas

    15K to Satya

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: Forum Statistics
    But do you care to share the bot that crawls through the SSP forums and post useful answeres ? Roji. P. Thomas SQL Server MVP...
  15. Roji. P. Thomas

    Please help me

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: General DBA Questions
    It will be helpful if you can post the table structure, indexes on the table and the query Roji. P. Thomas SQL Server MVP...
  16. Roji. P. Thomas

    Microsoft SQL Server Login Error : help needed

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: General DBA Questions
    What version/SP you are using? Do you see any error in the Error Log? Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com
  17. Roji. P. Thomas

    case statement with or

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: SQL Server 2005 General Developer Questions
    Thanks for the acknowledgement. Roji. P. Thomas SQL Server MVP http://toponewithties.blogspot.com
  18. Roji. P. Thomas

    Cannot Connect Sql Server 2005

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: SQL Server 2005 General DBA Questions
    quote:Originally posted by Roji. P. Thomas Are you able to ping the server? Sorry, I thought you were trying to connect to a different machine....
  19. Roji. P. Thomas

    Query never ends execution

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: SQL Server 2005 General DBA Questions
    Synonyms are most handy when linked servers are involved, and since its just a runtime replacing mechanism, it should work flawlessly, regardless...
  20. Roji. P. Thomas

    How to find the sqlstate of a query

    Post by: Roji. P. Thomas, Apr 17, 2007 in forum: SQL Server 2005 General Developer Questions
    I gues it has the same meaning in other DB products also....
Showing results 1 to 20 of 197 Next >
Search Again
Page 1 of 10