Forum Replies Created

Viewing 15 posts - 14,446 through 14,460 (of 59,063 total)

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

    Arsh - Thursday, August 31, 2017 7:35 AM

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

    August 31, 2017 at 2:22 pm

    #1957743

  • RE: PLE

    While I certain appreciate the attention to detail on all the hardware tricks of the trade, I'd really be surprised if much happened in the area of performance.  If you...

    August 31, 2017 at 2:19 pm

    #1957741

  • RE: PLE

    Arsh - Thursday, August 31, 2017 11:48 AM

    Spot on Jeff! Have taken are to put that specifically. Proposed two different ...

    August 31, 2017 at 2:16 pm

    #1957740

  • RE: Update Statistics..

    For the experiment, I'd use UPDATE STATISTICS schemaname.tablename WITH FULLSCAN; during a relatively quiet time.  The reason for the WITH FULLSCAN is because auto-updates of statistics can be done with...

    August 31, 2017 at 9:49 am

    #1957688

  • RE: Database Development Made Easy?

    ZZartin - Wednesday, August 30, 2017 12:11 PM

    jasona.work - Wednesday, August 30, 2017 6:31 AM

    August 31, 2017 at 7:50 am

    #1957657

  • RE: Update Statistics..

    Arsh - Thursday, August 31, 2017 2:00 AM

    Hi Experts,
    Trying to figure out if it might help in solving any performance issues by...

    August 31, 2017 at 7:43 am

    #1957652

  • RE: PLE

    Just a quick note... if the system is on a SAN and unless the SAN admin is very careful with how the logical drives are setup to guarantee the logical...

    August 31, 2017 at 7:11 am

    #1957640

  • RE: PLE

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

    Jeff Moden - Tuesday, August 29, 2017 8:24 AM

    August 30, 2017 at 4:54 pm

    #1957568

  • RE: Script out permissions - Azure SQL database

    SQL!$@w$0ME - Wednesday, August 30, 2017 12:00 PM

    SQL!$@w$0ME - Thursday, January 26, 2017 11:20 AM

    August 30, 2017 at 4:01 pm

    #1957563

  • RE: Calendar Table Function

    michael-l-johnson - Tuesday, August 29, 2017 10:09 PM

    I have not received a reply.

    Then I'd use ScottPletcher's technique to build a real Calendar...

    August 30, 2017 at 8:46 am

    #1957456

  • RE: Are the posted questions getting worse?

    Sean Lange - Wednesday, August 30, 2017 7:40 AM

    The quote from the top decision maker is "we will never be fully...

    August 30, 2017 at 8:12 am

    #1957441

  • RE: Right Size for LDF physical disk

    I could certainly be wrong but from what I'm seeing, you don't actually have a problem with your log file drive.  There's no % growth (it's set to grow by...

    August 30, 2017 at 8:01 am

    #1957439

  • RE: Calendar Table Function

    michael-l-johnson - Tuesday, August 2, 2016 7:28 AM

    How would you use this approach to get the next Business Day (Excluding Holidays)? Example...

    August 29, 2017 at 9:49 pm

    #1957349

  • RE: Columns to rows and rows to column conversion without pivot/unpivot

    anand08sharma - Monday, August 28, 2017 11:55 AM

    arihantjain121189 - Saturday, August 26, 2017 10:19 AM

    August 29, 2017 at 9:21 pm

    #1957348

  • RE: do you have a StripNonNumeric ITVF function?

    Ah... scratch my previous...  Even though it will likely never be needed, I add ORDER BY to physical Tally table implementations because, as Paul White said over on SE, the ORDER...

    August 29, 2017 at 5:36 pm

    #1957340

Viewing 15 posts - 14,446 through 14,460 (of 59,063 total)