Forum Replies Created

Viewing 15 posts - 241 through 255 (of 342 total)

  • RE: Update Statistics..

    GilaMonster - Thursday, August 31, 2017 1:19 PM

    Threshold for triggering auto update != sampling rate.
    The threshold is 20%. Jeff's talking about the...

    September 1, 2017 at 5:40 am

    #1957803

  • RE: PLE

    Jeff Moden - Thursday, August 31, 2017 2:19 PM

    While I certain appreciate the attention to detail on all the hardware tricks of...

    September 1, 2017 at 3:41 am

    #1957793

  • RE: PLE

    Spot on Jeff! Have taken care to put that specifically. Proposed two different SAN groups with RAID 1,0 and RAID 5 for temp DB and the other DB files accordingly..Thank...

    August 31, 2017 at 11:50 am

    #1957710

  • RE: PLE

    Spot on Jeff! Have taken are to put that specifically. Proposed two different SAN groups with RAID 1,0 and RAID 5 for temp DB and the other DB...

    August 31, 2017 at 11:48 am

    #1957708

  • RE: Update Statistics..

    Thanks Jeff. Isn't that the auto-update stats uses 20% as threshold?

    August 31, 2017 at 11:36 am

    #1957706

  • RE: Update Statistics..

    Jeff Moden - Thursday, August 31, 2017 7:43 AM

    Arsh - Thursday, August 31, 2017...

    August 31, 2017 at 9:19 am

    #1957683

  • RE: CPU usage overhead after setting Max DOP

    Grant Fritchey - Wednesday, August 30, 2017 8:54 AM

    In addition to MAXDOP, it's a good idea to set the Cost Threshold for...

    August 31, 2017 at 7:48 am

    #1957653

  • RE: Can I restore a single file .mdf to multiple files spread across disks

    GilaMonster - Wednesday, August 16, 2017 11:09 PM

    Arsh - Wednesday, August 16, 2017 1:56 PM

    August 31, 2017 at 7:35 am

    #1957647

  • RE: Query cancelled but completed is 0...

    Grant Fritchey - Thursday, August 31, 2017 6:43 AM

    Please, listen to what Lowell said. Don't shut off the server. I see that...

    August 31, 2017 at 6:54 am

    #1957636

  • RE: Update Statistics..

    GilaMonster - Thursday, August 31, 2017 4:30 AM

    Arsh - Thursday, August 31, 2017 4:20 AM

    August 31, 2017 at 4:37 am

    #1957612

  • RE: Update Statistics..

    GilaMonster - Thursday, August 31, 2017 2:15 AM

    Look at the slow query. Is there a large difference between estimated and actual row...

    August 31, 2017 at 4:20 am

    #1957609

  • RE: Compare database structure

    WhiteLotus - Wednesday, August 30, 2017 11:49 PM

    Hi All

    August 31, 2017 at 1:38 am

    #1957593

  • RE: PLE

    Jeff Moden - Wednesday, August 30, 2017 4:54 PM

    Arsh - Wednesday, August 30, 2017 8:11 AM

    August 31, 2017 at 1:30 am

    #1957592

  • RE: AVG Disk Transfer goes out of scale randomly

    agustingarzon - Monday, August 28, 2017 8:27 AM

    Hi there guys.

    I bring to you this strange situation where a Disk D would...

    August 30, 2017 at 9:11 am

    #1957481

  • RE: RESTORE VERIFY ONLY

    ReamerXXVI - Tuesday, August 29, 2017 10:15 PM

    I have a backup regime that creates a backup on a remote server and then...

    August 30, 2017 at 9:02 am

    #1957471

Viewing 15 posts - 241 through 255 (of 342 total)