Forum Replies Created

Viewing 15 posts - 11,071 through 11,085 (of 19,560 total)

  • RE: Clearning the transaction log

    Great fundamental question.

    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

    February 8, 2011 at 12:07 pm

    #1283956

  • RE: Connection Problems

    Thanks for the question

    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

    February 8, 2011 at 12:06 pm

    #1283955

  • RE: Does It Count?

    Scheduled maint should not be counted against your sla. In fact, scheduled maint should be one of the items listed and negotiated when coming to terms on an SLA.

    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

    February 8, 2011 at 12:04 pm

    #1283952

  • RE: SQL CMD

    Great question and I learned something today.

    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

    February 8, 2011 at 12:02 pm

    #1283950

  • RE: How To Get Table Row Counts Quickly And Painlessly

    homebrew01 (2/2/2011)

    No one has mentioned this method:

    select * from tableA

    then scroll down to the bottom to see how many rows there are

    :Whistling::w00t::hehe::-D

    Evil :-D:w00t::hehe:

    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

    February 8, 2011 at 11:59 am

    #1283943

  • RE: Toys V. Tools

    Bob Abernethy (2/4/2011)

    This reminds me of the saying "The difference between men and boys is the price of their toys."

    😀

    I totally agree.

    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

    February 6, 2011 at 9:49 am

    #1282887

  • RE: Doesn't security cascade down?

    SQLDCH (1/27/2011)

    I can only find the SQL Server 2000 page also, but I think what you want to do here is instead of:

    GRANT SELECT

    you should

    REVOKE SELECT

    If I'm reading correctly,...

    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

    January 27, 2011 at 2:38 pm

    #1279401

  • RE: Are the posted questions getting worse?

    WayneS (1/27/2011)

    Hey gang... I've got a small security question here - things are running differently than I thought they did.

    I hope that my response helps.

    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

    January 27, 2011 at 2:37 pm

    #1279400

  • RE: Doesn't security cascade down?

    If permissions are denied at the schema level then the permission check algorithm will fail and access not granted.

    http://msdn.microsoft.com/en-us/library/ms191291.aspx

    Specifically:

    Fail the permission check if the required permission is directly or implicitly...

    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

    January 27, 2011 at 2:37 pm

    #1279399

  • RE: Master Training

    Good luck with that. I think that the opportunity to take training from these people is not one to miss.

    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

    January 27, 2011 at 12:12 pm

    #1279290

  • RE: Data Driven Subscription

    Thanks for the question. Nice to see questions about the different technologies in SQL.

    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

    January 27, 2011 at 10:41 am

    #1279228

  • RE: Are the posted questions getting worse?

    Steve, Roy, Trey, Brandie, Gianluca - thanks

    I am checking finances and options to attend.

    It's cool to be a runner-up. Even better if I can work it out to 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

    January 27, 2011 at 10:27 am

    #1279212

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/26/2011)

    CirquedeSQLeil (1/26/2011)

    Have you guys seen the news?

    Close, very close. Nicely done.

    Thanks

    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

    January 26, 2011 at 4:58 pm

    #1278876

  • RE: Are the posted questions getting worse?

    Have you guys seen the news?

    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

    January 26, 2011 at 4:35 pm

    #1278863

  • RE: Are the posted questions getting worse?

    GilaMonster (1/26/2011)

    Since you seem intent on pulling the whole story out bit by bit, line by line...

    I'm just not seeing a future here at the moment. The IT industry is...

    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

    January 26, 2011 at 2:31 pm

    #1278803

Viewing 15 posts - 11,071 through 11,085 (of 19,560 total)