Forum Replies Created

Viewing 15 posts - 526 through 540 (of 19,560 total)

  • RE: Security - View is not able to select from base table

    arbra.strong (4/12/2016)

    Greg Edwards-268690 (4/12/2016)

    Since the test user was given only access to 1 object, maybe it is a bug.

    Under his own ID, does he have access to more than just...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 12, 2016 at 11:44 am

    #1871482

  • RE: Security - View is not able to select from base table

    Chad Crawford (4/12/2016)

    I feel like I'm grasping at straws, but we are about to that point.

    If you check the user info right before the SELECT, do the results look...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 12, 2016 at 10:33 am

    #1871458

  • RE: Security - View is not able to select from base table

    arbra.strong (4/11/2016)

    SQLRNNR (4/11/2016)

    I am testing this on SQL Server 2014 and am not able to reproduce your findings. I get the expected query results with or without the GO or...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 12, 2016 at 10:30 am

    #1871457

  • RE: Security - View is not able to select from base table

    I am testing this on SQL Server 2014 and am not able to reproduce your findings. I get the expected query results with or without the GO or database context...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 11, 2016 at 1:28 pm

    #1871244

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/8/2016)

    BL0B_EATER (4/8/2016)

    Would anyone find an article on Azure's SQL elastic pools worth reading? More on the basic setup and screen navigation? Just to understand where you would...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 8, 2016 at 12:01 pm

    #1870898

  • RE: Are the posted questions getting worse?

    GilaMonster (4/8/2016)

    Jack Corbett (4/7/2016)

    SQLRNNR (4/6/2016)

    Brandie Tarvin (4/6/2016)

    Folks, we have someone who is deliberately trying to force a deadlock to test some stuff. Can anyone give him advice on...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 8, 2016 at 8:55 am

    #1870829

  • RE: Are the posted questions getting worse?

    Jack Corbett (4/7/2016)

    SQLRNNR (4/6/2016)

    Brandie Tarvin (4/6/2016)

    Folks, we have someone who is deliberately trying to force a deadlock to test some stuff. Can anyone give him advice on how...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 7, 2016 at 11:24 am

    #1870606

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/7/2016)

    SQLRNNR (4/7/2016)

    Grant Fritchey (4/7/2016)

    I'm wrestling with an Octopus.

    How are you faring against all of those arms?

    Winning!

    Woot

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 7, 2016 at 10:16 am

    #1870576

  • RE: Are the posted questions getting worse?

    jasona.work (4/7/2016)

    SQLRNNR (4/7/2016)

    Brandie Tarvin (4/7/2016)

    Brandie Tarvin (4/7/2016)

    SSIS is freaking out on me all of a sudden. I would appreciate help on this.

    NEVERMIND.

    Stupid power users changing table definitions... grumble mumble...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 7, 2016 at 9:04 am

    #1870533

  • RE: Are the posted questions getting worse?

    GilaMonster (4/7/2016)

    Anyone want to hep tune a really nasty looking query?

    http://www.sqlservercentral.com/Forums/Topic1774589-3412-1.aspx

    oy vey

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 7, 2016 at 9:01 am

    #1870532

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/7/2016)

    I'm wrestling with an Octopus.

    How are you faring against all of those arms?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 7, 2016 at 8:40 am

    #1870524

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/7/2016)

    Brandie Tarvin (4/7/2016)

    SSIS is freaking out on me all of a sudden. I would appreciate help on this.

    NEVERMIND.

    Stupid power users changing table definitions... grumble mumble curse.

    I'd be...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 7, 2016 at 8:33 am

    #1870520

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/6/2016)

    Folks, we have someone who is deliberately trying to force a deadlock to test some stuff. Can anyone give him advice on how he might do that?

    Dang it...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 6, 2016 at 2:37 pm

    #1870318

  • RE: Are the posted questions getting worse?

    jasona.work (4/6/2016)

    SQLBill (4/6/2016)

    Sean Lange (4/5/2016)

    Luis Cazares (4/5/2016)

    Phil Parkin (4/5/2016)

    Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.

    I constantly avoid that...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 6, 2016 at 2:32 pm

    #1870314

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/6/2016)

    When you someone points you to an excellent solution, why would you reinvent the wheel using a much more inefficient method and then try to defend it?

    Because it...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    April 6, 2016 at 2:28 pm

    #1870311

Viewing 15 posts - 526 through 540 (of 19,560 total)