Forum Replies Created

Viewing 15 posts - 31,456 through 31,470 (of 49,552 total)

  • RE: Separating Index from Data

    Have you checked and confirmed that the slow performance is due to an IO bottleneck? If not, splitting the indexes out may do nothing for performance.

    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

    August 4, 2010 at 6:22 am

    #1202022

  • RE: Separating Index from Data

    Patricia Johnson (8/4/2010)

    I need to separate the indexes from the data in the database MDF file.

    Why?

    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

    August 4, 2010 at 6:09 am

    #1202008

  • RE: Recovery Mode

    Changing recovery model has little to do with what features you are using.

    Do you need point-in-time recovery with this database? If the DB failed middle of the working day, would...

    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

    August 4, 2010 at 5:59 am

    #1202004

  • RE: what are credentials in sql server 2005

    Assuming you mean the actual object called a Credential

    http://msdn.microsoft.com/en-us/library/ms189522%28SQL.90%29.aspx

    http://msdn.microsoft.com/en-us/library/ms190703%28SQL.90%29.aspx

    If you mean something else, please give more detail

    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

    August 4, 2010 at 5:57 am

    #1202003

  • RE: Index defrag

    Brandie Tarvin (8/4/2010)

    "Blocking" isn't a simple issue to assist with on the forums. Once you track down what's being blocked, you can start troubleshooting to find out what it's been...

    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

    August 4, 2010 at 5:24 am

    #1201986

  • RE: Index defrag

    Mani-584606 (8/3/2010)

    Because we are facing blocking problem for the content database and assuming it's due to index fragmentation?

    Unlikely.

    The only thing fragmentation affects is the IO performance of large range...

    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

    August 4, 2010 at 5:03 am

    #1201979

  • RE: sp_msforeachdb DBCC SHRINKFILE Query Problems

    My first question is why are you shrinking at all? You should not be shrinking database files on a regular basis. Only after some unusual operation (that's grown the log...

    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

    August 4, 2010 at 4:35 am

    #1201967

  • RE: Indexcols

    harry79 (8/4/2010)

    What is the use of WITH indexcols?

    Is there anyone can explain with the example?

    Can you give some context please? I'm not sure what you're asking.

    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

    August 4, 2010 at 4:25 am

    #1201963

  • RE: Create DB Maintenance Plan Error

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic963233-1550-1.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

    August 3, 2010 at 11:32 pm

    #1201889

  • RE: Are the posted questions getting worse?

    WayneS (8/3/2010)

    What do you'll think about this[/url]? Is there a valid point? Are the people screaming about it being racist? Something else?

    Not touching with 10-foot barge pole. I live in...

    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

    August 3, 2010 at 11:49 am

    #1201712

  • RE: Restore transaction log after disk failure

    Steve Jones - Editor (8/3/2010)

    If the disk with the t-log crashed, but the data mdf/ndf files are intact, you ought to be able to detach and attach the MDF, rebuild...

    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

    August 3, 2010 at 8:27 am

    #1201577

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/3/2010)

    I've been contracting for 15 years and I've never had this happen. Not to say your experience isn't valid, just offering another perspective. The contract might not 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

    August 3, 2010 at 8:25 am

    #1201574

  • RE: The backup data at the end of "path\backup" is incorrectly formatted

    Please note: 2 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

    August 3, 2010 at 7:46 am

    #1201529

  • RE: move files to different file group

    sivaprasad (8/3/2010)

    2. Detach the files to be moved to different filegroup

    ...

    4. Attach the files to the Filegroups created.

    How? Detach detaches an entire database, not a file. Same with attach.

    Did...

    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

    August 3, 2010 at 7:42 am

    #1201522

  • RE: Restore transaction log after disk failure

    mchofman (8/3/2010)

    Example:

    - My last transaction backup is made at 2:00 PM

    - My transaction log disk crashes at 3:00 PM

    Is their a method to recover the database until 3:00 PM, or...

    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

    August 3, 2010 at 7:39 am

    #1201515

Viewing 15 posts - 31,456 through 31,470 (of 49,552 total)