Forum Replies Created

Viewing 15 posts - 976 through 990 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/7/2015)

    SQLRNNR (8/7/2015)

    jasona.work (8/7/2015)

    Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we...

    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

    August 7, 2015 at 3:26 pm

    #1818303

  • RE: operand type clash. Text is incompatible with int when attempting to archive table

    Sean Lange (8/7/2015)

    For what it is worth, the text datatype has been deprecated since sql server 2005 in favor of varchar(max). If at all possible you should update your tables...

    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

    August 7, 2015 at 3:13 pm

    #1818300

  • RE: operand type clash. Text is incompatible with int when attempting to archive table

    I'd have to agree, we need a bit more information. Maybe something that helps repro your exact issue.

    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

    August 7, 2015 at 2:02 pm

    #1818279

  • RE: Today's Random Word!

    Luis Cazares (8/7/2015)

    Revenant (8/7/2015)

    whereisSQL? (8/7/2015)

    SQLRNNR (8/7/2015)

    Bonasera

    Corleone

    Boss

    Hugo

    Victor

    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

    August 7, 2015 at 12:18 pm

    #1818242

  • RE: Are the posted questions getting worse?

    jasona.work (8/7/2015)

    Another day, another "how do we prevent sysadmins from doing something" post. Which almost always boils down to essentially "we don't trust anyone, and we think this will...

    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

    August 7, 2015 at 12:16 pm

    #1818241

  • RE: Restricting Sysadmins from adding new sysadmins

    You can't prevent an sa from doing anything in sql server.

    Implementing Big Brother wreaks of a lack of trust for your DBAs. Do your Domain Admins have to access AD...

    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

    August 7, 2015 at 10:38 am

    #1818210

  • RE: Restricting Sysadmins from adding new sysadmins

    It's been said but just to be sure:

    One shared ID is an extremely bad idea. Administration doesn't become any easier and compliance to audits only becomes more of a bear.

    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

    August 7, 2015 at 9:32 am

    #1818175

  • RE: Fragmented Indexes

    Sean Lange (8/7/2015)

    ShorePatrol (8/7/2015)

    Hi Folks,

    I have some indexes over 30% fragmented. Some are much more...

    I have a job maintenance plan to "re-organize" indexes every Sunday on all databases. I didn't...

    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

    August 7, 2015 at 9:21 am

    #1818169

  • RE: Today's Random Word!

    Bonasera

    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

    August 7, 2015 at 9:00 am

    #1818152

  • RE: User-defined function

    fnndala2 (8/6/2015)

    @jeff Moden that might be true....SQL-Server training takes the whole day and I might missed some of the query I should reference from .

    Thank you:-)

    I wrote the test again...

    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

    August 7, 2015 at 8:53 am

    #1818149

  • RE: A script to find a value in all databases

    Sean Lange (8/7/2015)

    WhiteLotus (8/6/2015)

    Thanks for the reply . I wonder how to combine that statements into my current script . I want to rewrite the current script but have no...

    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

    August 7, 2015 at 8:45 am

    #1818143

  • RE: Today's Random Word!

    Ed Wagner (8/6/2015)

    Eirikur Eiriksson (8/6/2015)

    whereisSQL? (8/6/2015)

    eccentricDBA (8/6/2015)

    Revenant (8/6/2015)

    Ed Wagner (8/6/2015)

    SQLRNNR (8/6/2015)

    undo

    Rollback

    happens

    TARDIS

    Dr Who

    sp_who2

    Whoville

    Danville

    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

    August 6, 2015 at 5:35 pm

    #1818001

  • RE: Deny user from running Alter Server Role

    YW.

    I'd have to agree, membership <> grantor permission.

    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

    August 6, 2015 at 2:16 pm

    #1817979

  • RE: Deny user from running Alter Server Role

    egori (8/6/2015)

    I simply used the GUI.

    Interesting. I just tested it and am seeing the same thing. I just checked the documentation and it is confirmed that server roles are supposed...

    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

    August 6, 2015 at 1:55 pm

    #1817974

  • RE: Deny user from running Alter Server Role

    What was the means used to grant these users access to that role in the first place (the users that are now able to grant that role access to a...

    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

    August 6, 2015 at 1:29 pm

    #1817967

Viewing 15 posts - 976 through 990 (of 19,560 total)