Forum Replies Created

Viewing 15 posts - 24,706 through 24,720 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    mtillman-921105 (7/25/2011)

    Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic SQL Master"...

    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

    July 25, 2011 at 11:17 am

    #1357998

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/25/2011)

    mtillman-921105 (7/25/2011)

    Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic...

    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

    July 25, 2011 at 10:40 am

    #1357962

  • RE: How to increase dynamically SQL server log file size

    Imran Nadeem (7/25/2011)

    You are advising here;

    1. The BACKUP LOG WITH TRUNCATE_ONLY will break the log chain leaving you unable to do point in time restores until a full or diff...

    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

    July 25, 2011 at 10:31 am

    #1357942

  • RE: Are the posted questions getting worse?

    GSquared (7/25/2011)

    Reminds me of a thread a while back where someone was arguing with Paul Randall over what DBCC CHECKDB would do in SQL 2000.

    Yeah, that's just plain stupid. It's...

    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

    July 25, 2011 at 9:57 am

    #1357915

  • RE: Suspect mode database

    GilaMonster (7/21/2011)

    Check the SQL error log, there will be messages in there saying why SQL marked the database suspect.

    Without those error messages, no way to say anything.

    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

    July 25, 2011 at 9:56 am

    #1357913

  • RE: Getting "The header for file '....modellog.ldf' is not a valid" starting the server

    TRaceflag 3608

    Start the SQL Server from the command line in single user, restricted more and with that traceflag

    SQLServr.exe -m -f -T3608

    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

    July 25, 2011 at 9:54 am

    #1357909

  • RE: How to increase dynamically SQL server log file size

    Imran Nadeem (7/25/2011)

    GilaMonster (7/25/2011)

    Imran Nadeem (7/25/2011)

    Don't do that. Very, very, very bad log mismanagement. That's going to cause the log to grow again, it's going to cause log fragmentation (unless...

    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

    July 25, 2011 at 9:50 am

    #1357902

  • RE: Are the posted questions getting worse?

    I just had a fun one. Told someone that they shouldn't run Backup log with truncate only as it breaks the log chain. So they reference an article that they...

    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

    July 25, 2011 at 9:47 am

    #1357896

  • RE: Getting "The header for file '....modellog.ldf' is not a valid" starting the server

    Your model database has become corrupt. You'll need to start SQL with a traceflag (can't recall offhand which one, I'll look it up for you) so that SQL only brings...

    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

    July 25, 2011 at 8:04 am

    #1357793

  • RE: Locked Tables

    May I suggest you read up on the snapshot isolation levels first. There's a lot of info in Books Online.

    You can't just change the query, snapshot isolation 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

    July 25, 2011 at 7:42 am

    #1357770

  • RE: rrebuilding indexes by one connection and select or update statements by other connection on the same database work?

    Yes. It's mostly online, not fully online, but it will mostly keep the index available.

    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

    July 25, 2011 at 7:40 am

    #1357768

  • RE: How to increase dynamically SQL server log file size

    Imran Nadeem (7/25/2011)

    DBCC SHRINKFILE('Database_log', 1)

    BACKUP LOG DatabaseName WITH TRUNCATE_ONLY

    DBCC SHRINKFILE('Database_log', 1)

    Don't do that. Very, very, very bad log mismanagement. That's going to cause the log to grow again, it's going...

    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

    July 25, 2011 at 7:40 am

    #1357767

  • RE: SQL Server Service restarting throuh Job

    Well, you can shut SQL down from a SQL Agent job, but you won't be able to restart it. Stopping SQL Server stops SQL Agent.

    You can use Windows Scheduler 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

    July 25, 2011 at 4:57 am

    #1357681

  • RE: Locked Tables

    jez.lisle (7/25/2011)

    I have asked IT to look at the Indexing as I dont have access to that side of things. The DBA is all done by an external contractor.

    Oh dear.......

    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

    July 25, 2011 at 4:54 am

    #1357679

  • RE: Leave Developers Alone

    Back at the bank, constant interruptions (developers, change control, management, etc) got so bad at one point that I ended up putting a sign up next to my desk saying...

    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

    July 25, 2011 at 4:40 am

    #1357673

Viewing 15 posts - 24,706 through 24,720 (of 49,552 total)