SQL Server Performance

Recent Content by muko67

  1. muko67

    TOP 100 PERCENT Performance

    Post by: muko67, Sep 5, 2008 in forum: T-SQL Performance Tuning for Developers
    This is not original query. It's more complicated than this. But in a subquery I use TOP 100 PERCENT. How can I copy the execution plan here. I...
  2. muko67

    TOP 100 PERCENT Performance

    Thread by: muko67, Sep 5, 2008, 4 replies, in forum: T-SQL Performance Tuning for Developers
    Hi, I have a query like the following statement. My Problem with TOP 100 PERCENT takes this query 12 Seconds time, but if I remove TOP 100 PERCENT I...
  3. muko67

    Difference between INDEX and CONSTRAINT

    Post by: muko67, Sep 1, 2008 in forum: T-SQL Performance Tuning for Developers
    Thanks a lot for the information.
  4. muko67

    Difference between INDEX and CONSTRAINT

    Thread by: muko67, Sep 1, 2008, 5 replies, in forum: T-SQL Performance Tuning for Developers
    Hello, Suppose I have a huge table with 10 Columns. I create a unique constraint on the columns (col1, col2 col3) If I use theese columns in a...
  5. muko67

    Object_name function

    Post by: muko67, Jul 6, 2007 in forum: General Developer Questions
    Hi Adrian,<br /><br />I'am trying to run following Procedure, but I am getting the message below.<br />I'am working within master database. For...
  6. muko67

    Object_name function

    Thread by: muko67, Jul 6, 2007, 4 replies, in forum: General Developer Questions
    Hi, I'am looking for an alternative function of object_name(objid) with a second parameter database_id, because I'am working in master database and...
  7. muko67

    syslockinfo rsc_objid

    Thread by: muko67, Jul 3, 2007, 2 replies, in forum: Performance Tuning for DBAs
    Hi, How can I get the right object_name of rsj_objid column in SELECT statement using master database. Is there any another function like...
  8. muko67

    SQL Profiler Procedure-Subqueries

    Post by: muko67, Jun 18, 2007 in forum: Performance Tuning for DBAs
    Hi Satya,<br /><br />Thanks for your reply. When I trace SP<img src='/community/emoticons/emotion-7.gif' alt=':S' />tmtStarting or SP<img...
  9. muko67

    SQL Profiler Procedure-Subqueries

    Thread by: muko67, Jun 18, 2007, 3 replies, in forum: Performance Tuning for DBAs
    Hi, Is there any possibility to measure start/endtime of a subquery in the procedure like in the following example. I can see start/endtime, if a...