Forum Replies Created

Viewing 15 posts - 39,226 through 39,240 (of 49,552 total)

  • RE: sql server2005 +How to move data from one drive to another drive

    Create a new filegroup

    Create a new file in that filegroup and put it on the D drive

    You can move entire tables to the new filegroup by rebuilding the clustered index...

    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 8, 2009 at 9:07 am

    #991185

  • RE: SQLRAP

    BU69 (5/8/2009)

    I was more asking if anyone has used Microsofts service for SQLRAP or knew anything about it.

    I've had a couple done. I used to work for a Premier client,...

    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 8, 2009 at 9:05 am

    #991183

  • RE: sql server2005 +move data from one drive to another drive

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic712854-9-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

    May 8, 2009 at 9:01 am

    #991177

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/8/2009)

    I'd have to do some searching, might be in that thread he started when he mentioned he wanted to get his PhD, that the M.C.A. is a 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

    May 8, 2009 at 8:53 am

    #991170

  • RE: Are the posted questions getting worse?

    GSquared (5/8/2009)

    GilaMonster (5/8/2009)

    From everything I've heard, I'm guessing that his Master's degree was done by coursework, not by dissertation. Odd thing is, I can't find any reference to a degree...

    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 8, 2009 at 8:32 am

    #991135

  • RE: Backup and transaction log

    sumanta.roy52 (5/8/2009)

    While taking differential backup, do we need to append it every time or we can overwrite everytime?

    Again, what happens if you have only one backup, you go to restore...

    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 8, 2009 at 8:27 am

    #991129

  • RE: Backup and transaction log

    sumanta.roy52 (5/8/2009)

    Hi,

    I am taking full backup everyday 23:00 and overwriting it with the existing one. Transaction log every one hour and appending it every hour to get to get all...

    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 8, 2009 at 4:18 am

    #990967

  • RE: Backup and transaction log

    sumanta.roy52 (5/8/2009)

    Hi,

    What does differential backup capture? I mean does it take the changes from last full backup/last differential backup.

    Last full backup. So if you have a full on Sunday,...

    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 8, 2009 at 4:12 am

    #990963

  • RE: Checking Up on Developers

    Phil Factor (5/8/2009)

    Denormalisation (you'll live to regret it when the application expands)

    Agreed.

    All too often I find that when people say that they 'denormalised for performance' they actually mean 'didn't...

    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 8, 2009 at 2:39 am

    #990922

  • RE: What is the best way to dynamically define columns in the WHERE clause and avoid dynamic SQL

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    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 8, 2009 at 2:04 am

    #990910

  • RE: Backup and transaction log

    Gianluca Sartori (5/8/2009)

    Exactly: the transaction log backup is taken from the last backup, either full or tlog.

    Log backups contain the log records since the previous log backup. Full and 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

    May 8, 2009 at 2:04 am

    #990909

  • RE: Are the posted questions getting worse?

    RBarryYoung (5/7/2009)

    As for how he keeps his job, there are two obvious possibilities: 1) Civil Service, and 2) Nepotism. These two work pretty much the same, to one degree 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

    May 8, 2009 at 1:59 am

    #990905

  • RE: Performance implications of writing to tempdb all the time

    Dean Jones (5/7/2009)

    true talk here

    but sometimes, the Query can look long winded and kind of long, and hence the reason why its been put into a temp table.

    Long winded 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 8, 2009 at 1:54 am

    #990899

  • RE: Help me in writing the Query

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    On SQL 2005, take a look at 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 7, 2009 at 1:19 pm

    #990646

  • RE: Trace file is 14 GB! (21 hours data collected)

    Busy database? If you get a lot of transactions/sec, that's easily doable. I've had one that generated 500MB in half an hour, and that was a datawarehouse-type DB. If that'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

    May 7, 2009 at 1:04 pm

    #990639

Viewing 15 posts - 39,226 through 39,240 (of 49,552 total)