Forum Replies Created

Viewing 15 posts - 33,646 through 33,660 (of 49,552 total)

  • RE: Query on optimization

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    March 7, 2010 at 7:07 am

    #1129750

  • RE: Unable to start SQL 2000 SP4

    Restore master from a backup. Error 823 is an IO error so there's damage to the database file somewhere. Probably from that array problem.

    Once you have SQL running, please run...

    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

    March 7, 2010 at 3:55 am

    #1129742

  • RE: 2000 -> 2005 select into schema error

    There were no schemas in SQL 2000. One of the things that SQL 2005 did was separate out users and schemas.

    In SQL 2000, if you say

    SELECT * FROM SomeUser.sometable

    you're asking...

    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

    March 7, 2010 at 3:53 am

    #1129741

  • RE: always use incorrect index to run the query by sql server

    RBarryYoung (3/6/2010)

    My own point is that anyone who gets significantly different performance results for JOINs vs Subqueries on SQL Server 2005 or later, does so because either:

    _1. They were not...

    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

    March 7, 2010 at 3:43 am

    #1129739

  • RE: SSMS first time sql query MUCH slower than subsequent times - why ?

    ashish.kuriyal (3/7/2010)

    like all said and further to add....in case you want query to use same time then run DBCC FreeProcCache and execute your query again.

    Not on a production server.

    If...

    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

    March 7, 2010 at 3:41 am

    #1129738

  • RE: Complex T-SQL query

    clive-421796 (3/6/2010)

    Would like to hear from the likes of Jeff Moden, Lynn Pettis, etc. if they have a solution for this.

    http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/01/19/how-to-ask-a-forums-question.aspx

    I quote from Jonathan's post:

    While answering posts on the MSDN...

    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

    March 6, 2010 at 2:56 pm

    #1129684

  • RE: sql

    Maybe. What's the problem?

    The more details you give (within reason), the more likely someone is to help.

    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

    March 6, 2010 at 12:00 pm

    #1129659

  • RE: always use incorrect index to run the query by sql server

    RBarryYoung (3/6/2010)

    Joins are not "better" than sub-queries. They are not even "in general" better than subqueries. They are "in general" about the same thing, but it always depends.

    This...

    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

    March 6, 2010 at 11:58 am

    #1129657

  • RE: always use incorrect index to run the query by sql server

    Sorry, don't understand what you're asking there. Clarify please.

    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

    March 6, 2010 at 6:17 am

    #1129616

  • RE: Passed 70-448!

    VALEK (3/5/2010)

    I don't think speaking about the areas the exam covers and pointing people to the right place to emphasize their knowledge is violation.

    Repeating or paraphrasing what's on 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

    March 6, 2010 at 1:23 am

    #1129589

  • RE: always use incorrect index to run the query by sql server

    arun.sas (3/5/2010)

    It’s better to use the Joins instead of the sub queries/Exists.

    Sure about that?

    http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/

    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

    March 6, 2010 at 1:22 am

    #1129588

  • RE: How many of you have done Certification for SQL Server?

    CirquedeSQLeil (3/5/2010)

    Maybe they know them, but don't know that they know them.

    No. Don't know them and don't care. The "I just want to do my job, I don't need 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

    March 5, 2010 at 1:54 pm

    #1129451

  • RE: How many of you have done Certification for SQL Server?

    Jack Corbett (3/5/2010)

    Good point. I guess my point was that if you can put on your resume/CV that you are the author of books A and B and then...

    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

    March 5, 2010 at 1:50 pm

    #1129450

  • RE: Reporting Services Question from Exam 70-445

    That's one of the problems with brain dumps (other than that they are cheating), because they're actual questions taken from the exams, the people who post them up don't actually...

    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

    March 5, 2010 at 1:49 pm

    #1129449

  • RE: What will be good/accepted threshold values for Average Disk Seconds/Read, Average Disk Seconds/write

    gmamata7 (3/5/2010)

    Is this applicable to Avg. Disk sec/Read & Avg. Disk sec/Write counters too. i.e near impossible to interpret correct values from SAN?

    If it was, do you think I would...

    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

    March 5, 2010 at 1:46 pm

    #1129448

Viewing 15 posts - 33,646 through 33,660 (of 49,552 total)