Forum Replies Created

Viewing 15 posts - 16,081 through 16,095 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/22/2010)

    Lynn Pettis (3/22/2010)

    Okay, does this mean I should break down and get sertified as well?? I mean, it's looking like more of the denizens of The Thread...

    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

    March 22, 2010 at 3:39 pm

    #1137892

  • RE: Object tampering within SQL Server 2008??

    GSquared (3/22/2010)

    So far as I know, SQL 2008 blocks modification of system procedures.

    But you can usually get their definitions and create your own versions of them. Wouldn't that allow...

    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

    March 22, 2010 at 3:37 pm

    #1137890

  • RE: Object tampering within SQL Server 2008

    Interesting Duplicate Post. This post was created several hours after the initial post in Lowell's link.

    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

    March 22, 2010 at 3:35 pm

    #1137887

  • RE: Alert when Sqlserver Instances stops.

    We have NetIQ and another in-house built app to perform those duties.

    I have also tested What's Up Gold and Diagnostic Manager. Both seem fine as well.

    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

    March 22, 2010 at 3:32 pm

    #1137886

  • RE: Need Table(s) Associated with Syslogins

    JC-3113 (3/22/2010)

    Here is one quick way:

    sqlcmd -Q "exec spAuditUsersPermissions" -o c:\temp\SecurityReport.html

    Jim

    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

    March 22, 2010 at 3:31 pm

    #1137885

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (3/22/2010)

    Any comments on this link? Too close to advertising?

    http://www.sqlservercentral.com/Forums/FindPost887102.aspx

    I think it is advertising.

    I do however think that it could be worth an ad spot in the...

    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

    March 22, 2010 at 3:28 pm

    #1137884

  • RE: deny select on all views and deny execute on all SPs

    Jeffrey Williams-493691 (3/22/2010)

    Instead of using db_datareader, and then trying to remove all other access - it would be better to create your own role and add the specific rights you...

    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

    March 22, 2010 at 3:26 pm

    #1137881

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/22/2010)

    Okay, does this mean I should break down and get sertified as well?? I mean, it's looking like more of the denizens of The Thread are making...

    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

    March 22, 2010 at 3:25 pm

    #1137879

  • RE: Need Table(s) Associated with Syslogins

    You're welcome.

    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

    March 22, 2010 at 3:23 pm

    #1137876

  • RE: Datetime conversion

    Lynn Pettis (3/22/2010)

    I'm lost, even google isn't my friend on this one.

    Agreed. No idea what marel is. No idea how to convert it to datetime. It 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

    March 22, 2010 at 3:22 pm

    #1137875

  • RE: Drop Clustered index

    You're welcome.

    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

    March 22, 2010 at 1:55 pm

    #1137827

  • RE: Help With SQL DBA Interview

    I would expect things security related since it is the security manager.

    As for what kinds of questions, that will depend on the interviewer, interviewee, environment, and what is on your...

    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

    March 22, 2010 at 1:31 pm

    #1137817

  • RE: T-SQL Oddities

    Yes. Nice tidbit though to point out.

    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

    March 22, 2010 at 1:26 pm

    #1137816

  • RE: Detailed information on transactions

    I demonstrated a method to capture that kind of information in order to find out what was causing log files to grow. The same principles can be applied to...

    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

    March 22, 2010 at 1:24 pm

    #1137815

  • RE: Challenged by selecting Top 1 in a Group

    HowardW (3/22/2010)

    Lookup Row_Number() in BOL:

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

    Combining this with a CTE should get you what you need.

    Agreed

    If you post some sample data and the expected result, I'm sure someone can post...

    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

    March 22, 2010 at 1:21 pm

    #1137813

Viewing 15 posts - 16,081 through 16,095 (of 19,560 total)