Forum Replies Created

Viewing 15 posts - 26,851 through 26,865 (of 49,552 total)

  • RE: Database log file full, Mirroring , please help

    How often are you doing log backups?

    Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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 6, 2011 at 2:19 am

    #1307853

  • RE: SQL Server 2005 not using all CPU in multiprocessor (peak on 1 cpu alternatively)

    Please post new questions in a new thread. Thank 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

    April 6, 2011 at 2:16 am

    #1307851

  • RE: help me solve this

    Please note: 3 year old thread.

    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 6, 2011 at 2:16 am

    #1307850

  • RE: Shrinking a TLog while Mirroring

    vmssanthosh (4/6/2011)

    hi

    our log file sizes are becoming huge, And our databases are configured for mirroring. what else way, we can truncate the log files?

    Back up the log regularly. 15 minutes,...

    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 6, 2011 at 2:15 am

    #1307848

  • RE: query using results of another query.

    The IN clause perhaps? (SQL doesn't have arrays)

    Post the two queries and we may be able to help you better.

    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 5, 2011 at 11:51 pm

    #1307817

  • RE: Query Performance Tuning

    Jeff Moden (4/5/2011)

    Ordinarily I'd still insist on an MS URL because most people don't actually prove what they say but Gail sure did. I love demonstrable code! 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

    April 5, 2011 at 11:36 pm

    #1307816

  • RE: Shrinking a TLog while Mirroring

    I'm trying to understand why you would think that you want to use such a command. There's no practical use for backing up a log to the NUL device (equivalent...

    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 5, 2011 at 11:35 pm

    #1307815

  • RE: Downgrading backup log buffers from 1024K to 64K

    Find out what's using MemToLeave, increase the size of that reserved mem (and reduce the buffer pool by a like amount), restart SQL regularly. Not much really.

    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 5, 2011 at 11:33 pm

    #1307813

  • RE: Can I make two or more LDF files...

    Pretty much same as when there's only one log file.

    It uses one, then uses the other, then goes back to the first, etc.

    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 5, 2011 at 11:32 pm

    #1307812

  • RE: Table Input Parameter Question

    parthi-1705 (4/5/2011)

    First off all Why? you need to avoid the user defined data type.

    Why?

    Table-Valued Parameters : is defined as

    Table-valued parameters are a new parameter type in SQL Server 2008....

    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 5, 2011 at 4:50 pm

    #1307762

  • RE: How do I rebuild or defrag the index that is auto created for tables containing image columns

    It's not actually an index in the sense of the other indexes.

    Does DBCC IndexDefrag have a compactLOB option? (can't recall)

    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 5, 2011 at 4:08 pm

    #1307755

  • RE: Are the posted questions getting worse?

    Craig Farrell (4/5/2011)

    I swear I went through msdn three times and didn't find that.

    I kept finding this:

    http://msdn.microsoft.com/en-us/library/ms190476.aspx

    EDIT: Sorry, thank you for the links. My google-fu has failed me now....

    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 5, 2011 at 4:02 pm

    #1307753

  • RE: Downgrading backup log buffers from 1024K to 64K

    What does Exchange have to do with 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

    April 5, 2011 at 4:00 pm

    #1307752

  • RE: Are the posted questions getting worse?

    Craig Farrell (4/5/2011)

    On another topic. Anyone out there know of a site or something that will help me compute what the storage length is for different numeric/decimal combinations? ...

    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 5, 2011 at 2:56 pm

    #1307732

  • RE: Are the posted questions getting worse?

    Craig Farrell (4/5/2011)

    GilaMonster (4/5/2011)

    I'm not sure I really want to get involved in this one (old friend), let's see if he does the prereq reading.

    Heh, I'm sure I don't want...

    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 5, 2011 at 2:54 pm

    #1307730

Viewing 15 posts - 26,851 through 26,865 (of 49,552 total)