Forum Replies Created

Viewing 15 posts - 37,546 through 37,560 (of 49,552 total)

  • RE: PASS or Class?

    Who's teaching the class?

    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
  • RE: Certification High School

    Gift Peddie (7/20/2009)


    How many blacks are in your South African developers group? and please I need to know how many are black women.

    Blacks aren't a minority group in South...

    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
  • RE: Unexpected index scan - what causes this?

    I can't see anything that's forcing the scan. Makes no sense...

    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
  • RE: how much exams I have to give and which.

    Have a look here - http://learning.microsoft.com/manager/Catalog.aspx?clang=en-US&dtype=Table&Sort=PublicationDateDescending&page=1&cats={2932d34c-1b25-4dfd-84c8-a47aab13b5a6}%3a{1ba8b41f-c9fb-4e07-87e7-3d3943a51600}%3a{261ba873-f3ab-420e-96d6-e3004596a551}%3a{9f07f9cc-c308-4ebf-a4e9-2b8530ab1ea8}

    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
  • RE: Are the posted questions getting worse?

    Gianluca Sartori (7/20/2009)


    I received all email notifications during the weekend, but there's been very few posts.

    I don't think this means something like "Are the posted questions getting BETTER?"

    Should I start...

    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
  • RE: Unexpected index scan - what causes this?

    Edit: Nevermind....

    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
  • RE: Deadlocks occuring during insert

    Can you post the table and index definitions for the two tables please? I'm guessing it has something to do with the checks for matching foreign key records.

    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
  • RE: Certification High School

    Mark Horninger (7/20/2009)


    I found that studying and working toward an exam - researching - forced me to learn stuff I wouldn't have learned otherwise.

    Agreed. That's why...

    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
  • RE: Certification High School

    Bob Matthews (7/20/2009)


    The problem with most vendor certifications is that they seem to be written more by the marketing department than the technical staff. You have to know one...

    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
  • RE: Certification High School

    Gift Peddie (7/19/2009)


    I am saying even open book most minorities and women may not pass these exams.

    Are you implying that woman and minorities are stupid in that they 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
  • RE: Shrink File made File Bigger ?!?!

    Did the data file grow or did the log file grow? Shrink is a logged operation and it's not unexpected if the log file grows while the data file shrinks.

    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
  • RE: Deadlocks occuring during insert

    Can you post the full definition of the tables and the entire deadlock graph 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
  • RE: Issue with reorganizing and rebuilding indexes

    rvje (7/20/2009)


    The query runs successfully, but a check on the properties page of the index shows that nothing happend, they are still fragmented. I tried using the GUI for both...

    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
  • RE: sys.configutions in sql server 2005

    MADHAN_PERS (7/20/2009)


    SYS.CONFIGURATIONS Derive information from mssqlsystemresourcedatabase which is a hidden system databaase.

    The definition of the sys.configurations view is in the resource DB, but the info that it retrieves is 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
  • RE: Server Database Backup

    ps (7/20/2009)


    2. backup database using a shared path pointing to your client(of course, you need a shared folder on client's machine)

    backup database mydb to disk='\\myMachine\myBackupFolder\myDB.bak'

    That will only work if 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

Viewing 15 posts - 37,546 through 37,560 (of 49,552 total)