Forum Replies Created

Viewing 15 posts - 40,366 through 40,380 (of 49,552 total)

  • RE: Database Shrink

    kwilthew (3/13/2009)

    My question is, if there is so much free space available within the database, is this not a good candidate for shrinking the database file to make it more...

    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 13, 2009 at 8:39 am

    #959154

  • RE: Indexes Won't Defrag

    Stamey (3/13/2009)

    I understand, but it just seems like it would be so simple, with small indexes, to just rewrite the index in the correct order so that there would 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

    March 13, 2009 at 8:35 am

    #959150

  • RE: Please clarify

    prvreddy (3/12/2009)

    Yesterday, I attended one interview for DBA.I got following questions.But i didn't answers these questions.

    I assume a junior DBA position.

    1)if log file fills 100% then how...

    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 13, 2009 at 3:49 am

    #958962

  • RE: SQL 2005 Missing Indexes

    Tody (3/13/2009)

    if i set indexes on the sql table

    should i add per index only 1 column

    or is there to set an index with multpli columns?

    Not sure I understand you.

    Indexes should...

    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 13, 2009 at 3:41 am

    #958959

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/12/2009)

    I've never heard anyone refer to SQL 2005 as SQL 9 before and it makes me wonder how much he really knows.

    I haven't. The only versions that I've...

    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 13, 2009 at 3:38 am

    #958958

  • RE: Just had an interview for a DBA in CT

    Ellis (3/12/2009)

    when you restore from a file or filegroup but you don't retore the full database backup don't you need to apply transactions logs too...to make the database consistent?

    Indeed...

    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 13, 2009 at 3:35 am

    #958956

  • RE: Just had an interview for a DBA in CT

    frankivey (3/12/2009)

    You even qouted yourself that you can restore a database from a filegroup.

    No I did not. I said (and I quote)

    It (a full database backup) allows you...

    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 12, 2009 at 3:40 pm

    #958796

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (3/12/2009)

    [font="Verdana"]Congratulations Kimberly (or was it Kalen?) 😛 [/font]

    http://sqlinthewild.co.za/index.php/2009/01/22/bad-advice/#comment-2997

    Jack Corbett (3/12/2009)

    Yeah, congrats. I'm looking forward to (hope I haven't missed) the Simple-Talk article on Profiler...

    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 12, 2009 at 3:18 pm

    #958773

  • RE: Just had an interview for a DBA in CT

    frankivey (3/12/2009)

    The dumbass immediately told me this interview was over!!!! I was like you have to be kidding me?

    I have worked as a DBA for the past 6 years...

    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 12, 2009 at 3:11 pm

    #958768

  • RE: Just had an interview for a DBA in CT

    frankivey (3/12/2009)

    sorry guy but you are wrong, you back ndf file extension with a full backup.

    Or a filegroup backup of the filegroup that contains that ndf or a file backup...

    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 12, 2009 at 3:07 pm

    #958765

  • RE: Just had an interview for a DBA in CT

    frankivey (3/12/2009)

    Yes it is, I explained in detail that both backups include the system tables and objects, sorry I did not go into detail here but yes, I did explain...

    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 12, 2009 at 3:01 pm

    #958758

  • RE: Are the posted questions getting worse?

    RBarryYoung (3/12/2009)

    Hey! I just realized, you passed 10K sometime in the past few days, Gail! Congratulations! :w00t:

    Thanks. That was Saturday.

    Posting too much this week, but haven't got...

    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 12, 2009 at 2:21 pm

    #958725

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/12/2009)

    I have to agree as well. I'd love to get Babylon 5 on DVD.

    http://www.amazon.com/Babylon-5-Complete-Television-5-Pack/dp/B0001M3MXY/

    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 12, 2009 at 2:17 pm

    #958721

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/12/2009)

    Did you notice that was the OP's first post?

    Yup. It factored into my decision to 'challenge' him. I'm curious how he's going to reply.

    Rule 1 of...

    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 12, 2009 at 2:13 pm

    #958720

  • RE: Problem with query result

    JMSM (3/12/2009)

    Q2: select @@servername as 'instance name', count(*) as 'Nº of DBs by Instance', sum(a.size) as 'espaço alocado (mb)', sum(a.used) as 'espaço utilizado (mb)', sum(a.size)-sum(a.used) as 'espaço livre (mb)'

    from db_name..tbl_name...

    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 12, 2009 at 2:02 pm

    #958708

Viewing 15 posts - 40,366 through 40,380 (of 49,552 total)