Forum Replies Created

Viewing 15 posts - 38,521 through 38,535 (of 49,552 total)

  • RE: Performance tuning a procedure

    The percentages and costs are estimates. They may not be accurate.

    If the new query has fewer reads and a lower exec time then I'd go with that and ignore the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 10:16 am

    #1007527

  • RE: problem creating index on view

    Naveen Kumar (6/10/2009)

    I have performance issue in my application. This view contains more than 5 lakh records.

    Please help me how to create unique clustered index on this view. So that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 10:13 am

    #1007525

  • RE: Logship from SQL Server to MYSQL

    You say you want to replace the 3 SQL Server boxes with MySQL for cost reasons. What cost is there in keeping the SQL Server boxes? Your licences for SQL...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 10:09 am

    #1007523

  • RE: Are the posted questions getting worse?

    mazzz (6/10/2009)

    How do South Africans feel about hosting the World Cup?

    While it's not quite at Olympics level, it's got to be a very costly enterprise - I remember a lot...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 9:38 am

    #1007502

  • RE: Index question for the guru's out there...

    chadowens777 (6/10/2009)

    Right now we're just doing low hanging fruit (using the info from dm_db_missing_index* to identify key tables that need indexes) to remove as much latency where (simply and easily)...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 9:29 am

    #1007491

  • RE: Are the posted questions getting worse?

    Alvin Ramard (6/10/2009)

    I was going to make a comment to you Gail about crystal balls but then I remembered you're not in the US.

    A reminder for crystal ball users in...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 8:43 am

    #1007456

  • RE: Are the posted questions getting worse?

    Grant Fritchey (6/10/2009)

    I've never been over there. It doesn't sound... appealing? Good? Like it's any fun at all.

    If you have the temerity to question people, what happens?

    It's OK. I...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 8:34 am

    #1007447

  • RE: Index drop & recreate statements

    T2000 (6/10/2009)

    With a long uptime, I checked the index use and would like to drop the indexes which have zero user_seeks/scans & lookups. Such indexes are not used and are...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 8:31 am

    #1007444

  • RE: Index? Table Scan? Performance? Billion Records?

    Please post full table definitions, index definitions and the execution plan. To get the exec plan on SQL 2000 add the following before the query and run it.

    SET STATISTICS PROFILE...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 8:23 am

    #1007439

  • RE: Are the posted questions getting worse?

    MarkusB (6/10/2009)

    Any psychics around who can help this one

    http://www.sqlservercentral.com/Forums/Topic732091-266-1.aspx

    Sorry, crystal ball's on the fritz again.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 8:14 am

    #1007430

  • RE: application hangs

    Hmmm. Could be literally anything from the app to the client machine' hardware to the network to the database and beyond. Really, there's absolutly no way of telling what's wrong...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 8:11 am

    #1007428

  • RE: sp_executesql : Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

    mayank.and.friends (6/10/2009)

    Sql string should be always either ntext/nvarchar/nchar.

    Only necessary when using sp_executesql (which takes nvarchar parameters). Not important when using EXEC. Also, you cannot define a variable of type ntext.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 8:06 am

    #1007426

  • RE: Forums on your Resume/CV

    Jeff Moden (6/9/2009)

    GilaMonster (6/9/2009)

    He turned it down, because his current company had offered him a raise if he would stay.

    Yowch! I have some pretty strong feelings about that....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 1:48 am

    #1007220

  • RE: Syntax for FOR LOOP

    There is no for loop in SQL. There's only the While loop.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 1:33 am

    #1007215

  • RE: query with joins and functions , how to optimize , it is taking 58 min.. to retrive the 998 records . query with joins ,functions

    Still need to see the table definitions, index definitions, function definitions and the execution plan.

    Also, can you please edit your post and wrap your query in the code tags to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 10, 2009 at 1:09 am

    #1007209

Viewing 15 posts - 38,521 through 38,535 (of 49,552 total)