Forum Replies Created

Viewing 15 posts - 39,286 through 39,300 (of 49,552 total)

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    Jeremy Brown (5/5/2009)

    This isn't to insinuate that a degree isn't useful, rather to make the point that any degree is a big comittment to your career in general. 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

    May 5, 2009 at 1:09 pm

    #989125

  • RE: Lost model.bak from system database

    Any errors related to model in the SQL error log?

    Is your login sysadmin?

    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

    May 5, 2009 at 1:04 pm

    #989124

  • RE: Transaction Log Truncate Problem

    Create a transactional replication publication with one table in it (totally irrelevance what table)

    Drop the publication

    Right click Replication (in management studio's object explorer)

    Select Disable Publishing and distribution (providing no other...

    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

    May 5, 2009 at 1:02 pm

    #989123

  • RE: One help please

    Searches are faster on indexed columns because SQL can quickly find the matching records rather than having to read through the entire table.

    Imagine the telephone directory. Because it's in order...

    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

    May 5, 2009 at 11:07 am

    #989053

  • RE: Are the posted questions getting worse?

    Why would I ever trace a gorgeous African summer for that damp, slightly warm couple months that they call summer in the UK?

    (before anyone gets offended, I'm originally from 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

    May 5, 2009 at 10:31 am

    #989024

  • RE: One help please

    There's some stuff here that may help, but it assumes you know the basics.

    http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

    http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

    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

    May 5, 2009 at 10:26 am

    #989020

  • RE: Disaster recovery and High Availability

    I very much liked James Luetkehoelter's Pro SQL Server Disaster Recovery.

    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

    May 5, 2009 at 10:25 am

    #989019

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    Looks like I'm the boring one.

    B.Sc in Physics and Computer Science.

    I wanted to go into physics, but I struggled a bit with the maths for it in 3rd year 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

    May 5, 2009 at 10:15 am

    #989008

  • RE: Advice on Fragmentation and Indexes

    Probably because the tables are small. Small tables tend not to defrag, and there's very little point anyway. Fragmentation's only a real issue on large tables when queries are doing...

    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

    May 5, 2009 at 9:42 am

    #988969

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (5/5/2009)

    GilaMonster (5/5/2009)

    Better idea, come down here in early Dec. You get a vacation...

    on a plane. Isn't it like 42 hours to fly down there?

    I'm not 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

    May 5, 2009 at 9:39 am

    #988967

  • RE: Transaction Log Truncate Problem

    How full is the transaction log? If there's 90GB of log data in there, it won't shrink below that.

    Use DBCC SQLPERF(LogSpace) to see what percentage of the log is full....

    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

    May 5, 2009 at 9:31 am

    #988950

  • RE: Are the posted questions getting worse?

    RBarryYoung (5/5/2009)

    Jan Van der Eecken (5/5/2009)

    Sure, just gimme a shout when you are at the airport.

    Heh. I so wish I could afford to follow through on this... 🙂

    Exchange rate...

    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

    May 5, 2009 at 9:22 am

    #988941

  • RE: Transaction Log grows to much / Recovery Model Simple

    tobe_ha (5/5/2009)

    My biggest problem still is the one Statement which is one implicit transaction. I wonder, if the size of the log is reasonable (see above)

    There is a clustered...

    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

    May 5, 2009 at 6:33 am

    #988712

  • RE: Transaction Log grows to much / Recovery Model Simple

    GilaMonster (5/5/2009)

    tobe_ha (5/5/2009)

    Is there a History where I can see, what recovery models were set in the past?

    It doesn't appear to be stored in the default trace (I just checked),...

    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

    May 5, 2009 at 6:29 am

    #988706

  • RE: Transaction Log grows to much / Recovery Model Simple

    Paul White (5/5/2009)

    I'm pretty sure it is the case that a portion of the log will still be active if the database is switched from FULL to SIMPLE, if 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

    May 5, 2009 at 6:08 am

    #988688

Viewing 15 posts - 39,286 through 39,300 (of 49,552 total)