Forum Replies Created

Viewing 15 posts - 42,406 through 42,420 (of 49,552 total)

  • RE: Upgrade-MCITP Certification

    I don't think there are any books specifically for that. The 447 exam covers all the material that 443 and 444 together do. It's just in 1 upgrade exam instead...

    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

    December 11, 2008 at 11:09 am

    #911239

  • RE: Backups and Transactions Log relationships

    Bristolred (12/11/2008)

    The data pages changed in memory will be written to disk (datafile - MDF) at a later time either by the lazy writer process or by the checkpoint process....

    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

    December 11, 2008 at 11:00 am

    #911233

  • RE: HTML Connection to SQL 2005 Question

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic618052-1291-1.aspx

    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

    December 11, 2008 at 10:52 am

    #911225

  • RE: I restarted sql and now my database is "(in recovery)"

    I can't see the full question, so I'm guessing a bit. If you're seeing the database marked 'in recovery' it's either a long restart-recovery, or a problem.

    Can you get 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

    December 11, 2008 at 10:32 am

    #911215

  • RE: Select statement that gets only the rows with the highest date without using subqueries

    Continued here: http://www.sqlservercentral.com/Forums/Topic617982-8-1.aspx

    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

    December 11, 2008 at 10:23 am

    #911211

  • RE: Select query that only returns the rows with the highest date

    Josh Turley (12/11/2008)

    I posted this in the noob forum too but I figured you might have better answers in here.

    Please don't cross post. It just wastes peoples time and...

    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

    December 11, 2008 at 10:22 am

    #911210

  • RE: pls help me

    Seggerman (12/11/2008)

    some of us are (sadly) monolingual and that language is American English

    And even those who are not monolingual (British English and Afrikaans) may not understand the terms.

    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

    December 11, 2008 at 9:39 am

    #911192

  • RE: WHERE when using Table Alias

    Philip Horan (12/11/2008)

    However I am unable to use the WHERE clause when using a table alias i.e.

    WHERE ParentProductId LIKE 'DME_%'

    That's a column alias, not a table alias. The select clause,...

    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

    December 11, 2008 at 6:09 am

    #911006

  • RE: Performance Tuning

    Can you post the table schemas, and the index definitions please?

    How many rows is a lakh?

    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

    December 11, 2008 at 5:54 am

    #910994

  • RE: Performance optimization of UNIOn

    Back to the original problem.

    There are two things causing the slowness.

    First, the use of union. If you change all to union all, you'll get the same result (the resultsets can't...

    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

    December 11, 2008 at 5:51 am

    #910992

  • RE: Performance optimization of UNIOn

    I don't have your users table, and hence cannot reproduce your test. I tried one using similar queries and the temp table that I specified for an earlier test.

    I ran...

    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

    December 11, 2008 at 5:21 am

    #910973

  • RE: Transaction in sql server 2000

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic617605-5-1.aspx

    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

    December 11, 2008 at 5:08 am

    #910966

  • RE: trigger problem

    mzakwans (12/11/2008)

    hi

    thanks

    but I have tried it without delete and every time I do change on exist record it adds all record to the tb2 again

    Have you referenced 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

    December 11, 2008 at 5:03 am

    #910965

  • RE: Last Transaaction sql server 2000

    I'm still not understanding what you want.

    The most recent query?

    The most recent data change?

    Something else?

    Best bet to get any of that is to have a profiler trace running for any...

    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

    December 11, 2008 at 4:39 am

    #910958

  • RE: Performance optimization of UNIOn

    arup_kc (12/11/2008)

    It's showing that it takes 17 ms while using "SELECT *" but only 1 ms while using "SELECT 1"

    Well, yes. For the first one, the data has to be...

    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

    December 11, 2008 at 4:39 am

    #910956

Viewing 15 posts - 42,406 through 42,420 (of 49,552 total)