Forum Replies Created

Viewing 15 posts - 151 through 165 (of 465 total)

  • RE: Rebuilding Indexes very often is good?

    I'm also looking forward to reading the article, but from the graph, it looks like simply using a 70% fill factor almost eliminates index problems. Am I interpreting that correctly?

  • RE: Read-only schema allows write

    I do not routinely use sysadmin, due to security concerns. I do have an account that has dbo access, which is what I connected with. Sysadmin I use only when...

  • RE: With Schemabinding

    ScottPletcher - Thursday, January 25, 2018 6:56 AM

    pdanes - Wednesday, January 24, 2018 5:15 PM

  • RE: With Schemabinding

    MMartin1 - Wednesday, January 24, 2018 9:55 PM

    pdanes - Wednesday, January 24, 2018 5:15 PM

  • RE: With Schemabinding

    MMartin1 - Wednesday, January 24, 2018 9:45 PM

    pdanes - Wednesday, January 24, 2018 5:20 PM

  • RE: With Schemabinding

    MMartin1 - Wednesday, January 24, 2018 1:38 PM

    And just to add a quick note : If you employ these dependency functions ......

  • RE: With Schemabinding

    ScottPletcher - Wednesday, January 24, 2018 12:46 PM

    pdanes - Wednesday, January 24, 2018 12:03 PM

  • RE: With Schemabinding

    ScottPletcher - Wednesday, January 24, 2018 7:11 AM

    pdanes - Wednesday, January 24, 2018 2:51 AM

  • RE: With Schemabinding

    ScottPletcher - Wednesday, January 24, 2018 7:10 AM

    pdanes - Wednesday, January 24, 2018 2:24 AM

  • RE: With Schemabinding

    MMartin1 - Tuesday, January 23, 2018 10:20 PM

    Not sure how much this would help, as I've not done this, but when dealing...

  • RE: With Schemabinding

    ScottPletcher - Tuesday, January 23, 2018 9:27 AM

    Have you considered instead of binding them just running a:
    sp_refreshview 
    across all the views when a...

  • RE: With Schemabinding

    A collection of scripts that would unbind and rebind every view was one of my thoughts, but when you chain views, order is important - you can't bind a view...

  • RE: With Schemabinding

    Everything is a trade-off. For the most part, I like the way I'm doing it, and I generally add schemabinding late in the game, when the design is relatively stable....

  • RE: With Schemabinding

    No, you're right - I do have chained views. Not a lot and not too deep, but they do exist. They're very useful in preventing multiple duplicates of the same...

  • RE: Core T-SQL

    Eric M Russell - Monday, November 6, 2017 8:24 AM

    If you don't know T-SQL; meaning if you can't write your own T-SQL...

Viewing 15 posts - 151 through 165 (of 465 total)