Forum Replies Created

Viewing 15 posts - 39,391 through 39,405 (of 49,552 total)

  • RE: Question for DBAs

    You may find this useful

    http://www.brentozar.com/archive/2009/04/how-to-get-a-junior-dba-job-part-1/

    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

    April 29, 2009 at 9:52 am

    #986068

  • RE: Autoshrink ON for ASPNET database

    I think this blog post pretty much says it all.

    http://www.sqlskills.com/BLOGS/PAUL/post/Auto-shrink-e28093-turn-it-OFF!.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

    April 29, 2009 at 9:46 am

    #986056

  • RE: Are the posted questions getting worse?

    tosscrosby (4/29/2009)

    Lynn Pettis (4/28/2009)

    You know, I can think of some one else that, IMHO, ranks right there with our favorite White House window washer, and here is his latest post.

    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

    April 29, 2009 at 7:48 am

    #985919

  • RE: DeadLock

    What indexes are there on the STB table?

    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

    April 29, 2009 at 7:47 am

    #985913

  • RE: Integrity checking

    Integrity check shouldn't grow a DB, it just reads data. Index rebuilds will grow the DB

    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

    April 29, 2009 at 7:28 am

    #985899

  • RE: Logical Scan fragmentation increasing

    Are you shrinking the database? Manual or autoshrink?

    I usually only worry about fragmentation if it's above about 25-30%.

    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

    April 29, 2009 at 7:25 am

    #985894

  • RE: TIMEOUT error (client thinks it's SQL Server)

    Take a look at the two article I posted earlier in the thread. They're a series that shows an example of finding and fixing perf problems (though in the case...

    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

    April 29, 2009 at 7:13 am

    #985880

  • RE: Script to Rename the indexes, Foreing Key Constraints using SQL Server 2005

    Look up sp_rename in Books Online

    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

    April 29, 2009 at 7:11 am

    #985879

  • RE: Indexing Options question

    WayneS (4/28/2009)

    I'm trying to set up a deadlock event as outlined in BOL. The job gets created. When I run the supplied code, I do end up getting the deadlock....

    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

    April 29, 2009 at 7:07 am

    #985873

  • RE: Multiple daily log backups required in a clustered and mirrored environment

    Schadenfreude-Mei (4/29/2009)

    As you may recall we have had many chats about this sort of thing in the past and while this is not something i would do in a production...

    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

    April 29, 2009 at 7:05 am

    #985870

  • RE: Managing Transaction Logs

    I think that's a topic for a different thread. If you're interested, there's a good description in Itzik's book Inside SQL Server 2005: T-SQL Querying.

    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

    April 29, 2009 at 1:09 am

    #985673

  • RE: Backup Chain Question

    Full backups do not truncate the transaction log. Only log backups do that. The only things that break a log chain are backup ... with truncate only and a switch...

    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

    April 29, 2009 at 12:44 am

    #985667

  • RE: sqlserver!!! sybase!!!

    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

    April 29, 2009 at 12:41 am

    #985666

  • RE: update all rows in table with data come from temporary table

    UPDATE TABLE1

    SET statutSpecifique = dpStatut

    FROM Table1 JOIN @tempTableStatutDp t

    ON Table1.id = t.dpid

    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

    April 29, 2009 at 12:39 am

    #985663

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/28/2009)

    You know, I can think of some one else that, IMHO, ranks right there with our favorite White House window washer, and here is his latest post.

    Ah, yes....

    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

    April 29, 2009 at 12:30 am

    #985660

Viewing 15 posts - 39,391 through 39,405 (of 49,552 total)