Forum Replies Created

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

  • 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...

  • RE: Core T-SQL

    andrew.jones 69458 - Friday, November 3, 2017 8:00 AM

    So for us wannabes, what is the best way to learn these basic level...

  • RE: Read-only schema

    sgmunson - Monday, September 25, 2017 8:38 AM

    SQL injection generally occurs because parameters are capable of holding a lot of data.   So...

  • RE: Read-only schema

    ZZartin - Monday, September 25, 2017 8:31 AM

    Hmm... there aren't read only schemas, do you mean read only permissions for a login/role?

    But...

  • RE: Using OVER() to Remove Duplicate Rows

    There may be any number of 'better' ways to accomplish this particular task, but the post was intended as a tutorial about how OVER() works, and an example of where...

  • RE: Using OVER() to Remove Duplicate Rows

    I've used OVER() a few times when I copied something from a forum to solve a problem, and hacked it until it gave me the results I needed. I used...

  • RE: PowerShell error text in table

    Okay, here's what I ended up doing. I don't suppose it's 100% reliable, since the pattern -could- occur in a legit path, but it's unlikely enough in my case that...

  • RE: Bingle is my Senior DBA

    Another thing that might help is to go back to the articles and add more keywords. I have occasionally had trouble finding something on this site because I didn't know...

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