Forum Replies Created

Viewing 15 posts - 23,716 through 23,730 (of 49,552 total)

  • RE: Backup taking more time than usual

    Index fragmentation won't have anything to do with backup time. Backup is an IO-bound operation, extents read from the data file written directly to the backup file. Check IO throughput...

    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

    September 4, 2011 at 12:51 pm

    #1376895

  • RE: 70-433 certfications information

    Braindumps are cheating. They are actual questions taken from the exams in violation of the NDA that all exam takers must accept. Using or distributing braindumps can result in your...

    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

    September 4, 2011 at 12:37 pm

    #1376894

  • RE: dbcc checkdb Error

    The SQL Service isn't running. Start it.

    No backup? You are going to lose data by repairing.

    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

    September 4, 2011 at 11:15 am

    #1376888

  • RE: dbcc checkdb Error

    Got a clean backup? (a backup without the corruption)

    If not, take the database into single user mode and run the following:

    DBCC CheckDB('My_data', REPAIR_ALLOW_DATA_LOSS)

    You will lose quite a lot of data...

    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

    September 4, 2011 at 11:04 am

    #1376886

  • RE: Row versioning

    Or do you mean one of the optimistic concurrency models based on row versions? If so, they most definitely do work on deletes.

    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

    September 4, 2011 at 6:10 am

    #1376857

  • RE: Clustered or non Clustered index??

    Grant Fritchey (9/4/2011)

    The only deviation I would make on the clustered index over what Gail says is to look for the most frequently accessed path to the data. Usually, 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

    September 4, 2011 at 6:08 am

    #1376855

  • RE: Where Do You Park?

    bill.saunders1 (9/3/2011)

    Asking where I park is like asking me where they whip me when I get to work. One hopes that the rising price of gas will make people...

    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

    September 4, 2011 at 3:40 am

    #1376843

  • RE: Clustered or non Clustered index??

    Welsh Corgi (9/3/2011)

    If Microsoft is putting out information that is questionable then perhaps they should be notified.

    LoL, like it's so unusual for them to do that </sarcasm>

    http://sqlskills.com/BLOGS/PAUL/post/Do-yourself-a-favor-Trust-No-One.aspx

    There's a reason I...

    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

    September 4, 2011 at 3:36 am

    #1376842

  • RE: Question about forums and individual statuses

    Tom.Thomson (9/3/2011)

    Call this the Cadbury's thread, if you like.

    I really detest fruit and nut chocolate. The only place raisins belong is in bobotie (and even that depends whose recipe you're...

    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

    September 3, 2011 at 3:44 pm

    #1376809

  • RE: Clustered or non Clustered index??

    Welsh Corgi (9/3/2011)

    The clustered index should be based on a column that you query on a range.

    I would tend not to agree with that, nonclustered indexes are better for 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

    September 3, 2011 at 9:00 am

    #1376774

  • RE: Which type of index to use??

    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/Topic1169597-361-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

    September 3, 2011 at 8:59 am

    #1376773

  • RE: Are the posted questions getting worse?

    Tom.Thomson (9/3/2011)

    GilaMonster (9/2/2011)

    GSquared (9/2/2011)

    So, I've probably had wildlife closer than Gail has, despite the fact that she lives in a grass hut and hasn't ever even heard of electricity 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

    September 3, 2011 at 8:57 am

    #1376772

  • RE: Shrinking Log files

    magasvs (9/2/2011)

    Shrinking the log file will improve log file performance when you have large number of virtual logs (shrink it to the minimal size, then resize it to the size...

    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

    September 3, 2011 at 3:52 am

    #1376750

  • RE: Index over multiuple columns question

    I can't see any reason why that index wouldn't be used there. Doesn't make sense...

    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

    September 3, 2011 at 3:49 am

    #1376749

  • RE: SQL Job pointing to a package on filesystem on 2008

    The SSIS service is installed and running on that machine?

    Cluster or standalone?

    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

    September 2, 2011 at 4:42 pm

    #1376719

Viewing 15 posts - 23,716 through 23,730 (of 49,552 total)