Forum Replies Created

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

  • RE: Please help!! Going to SQL Bootcamp.

    GilaMonster (7/1/2011)

    SQLRNNR (7/1/2011)

    I'd also recommend checking out the MCM Videos.

    http://sqlskills.com/T_MCMVideos.asp

    Those might be a little (ok a lot) advanced for someone doing a ITP bootcamp

    I figure if you start with those,...

    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

    July 1, 2011 at 2:20 pm

    #1347334

  • RE: Are the posted questions getting worse?

    Craig Farrell (7/1/2011)

    GilaMonster (7/1/2011)

    Thanks everyone. Wasn't actually planning on announcing it here.

    Fine then, one billboard coming up to announce it elsewhere.

    EDIT: Sorry, that was too big.

    Hmm - maybe we should...

    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

    July 1, 2011 at 2:13 pm

    #1347328

  • RE: Can I make my database to work only for particular web site and not any other

    If you are storing your connection details in clear text - you are somewhat limited.

    You could try to implement a logon trigger that denies any traffic from outside of 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

    July 1, 2011 at 12:41 pm

    #1347272

  • RE: Runaway Transaction Log Growth

    TheSQLGuru (7/1/2011)

    That's a nice collection of VLFs you have there! I recommend you find and read Kimberly Tripps blog post on optimizing transaction logs.

    That can actually be found in...

    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

    July 1, 2011 at 12:38 pm

    #1347268

  • RE: Please help!! Going to SQL Bootcamp.

    I'd also recommend checking out the MCM Videos.

    http://sqlskills.com/T_MCMVideos.asp

    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

    July 1, 2011 at 12:37 pm

    #1347266

  • RE: Good books for DMVs

    Here are a few more. Tim Ford and Louis Davidson have great books on the topic.

    http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=sql+dmv&x=0&y=0

    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

    July 1, 2011 at 12:34 pm

    #1347265

  • RE: Passed My Exam

    Kenneth Fisher-475792 (7/1/2011)

    mtassin (7/1/2011)

    Congrats!

    How difficult did it seem to you? My biggest concern having never sat a cert test is a self-criticism that tells me I don't know enough.......

    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

    July 1, 2011 at 11:45 am

    #1347239

  • RE: SQL Account Loses Mapping

    You could start here.

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

    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

    July 1, 2011 at 11:42 am

    #1347238

  • RE: SQL Account Loses Mapping

    Welsh Corgi (7/1/2011)

    Someone or something removed the permission to the database for these Loins.

    You had access too? 😉

    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

    July 1, 2011 at 11:24 am

    #1347227

  • RE: Unnecessary 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

    July 1, 2011 at 11:20 am

    #1347225

  • RE: SQL Account Loses Mapping

    tmkruse (7/1/2011)

    There was no database restore. When I say mapping, under user mapping on the Login properties the map field was unchecked. This is alos a MS NAV...

    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

    July 1, 2011 at 11:19 am

    #1347223

  • RE: Are the posted questions getting worse?

    GSquared (7/1/2011)

    SQLRNNR (7/1/2011)

    GSquared (7/1/2011)

    Jim Murphy (7/1/2011)

    Oh, in case everyone didn't hear: Congratulations Gail for making MVP again!

    In other breaking news, the sun rose in the east, and there's a chance...

    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

    July 1, 2011 at 11:18 am

    #1347220

  • RE: Are the posted questions getting worse?

    GSquared (7/1/2011)

    Jim Murphy (7/1/2011)

    Oh, in case everyone didn't hear: Congratulations Gail for making MVP again!

    In other breaking news, the sun rose in the east, and there's a chance of rain...

    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

    July 1, 2011 at 11:07 am

    #1347209

  • RE: Are the posted questions getting worse?

    Jim Murphy (7/1/2011)

    Oh, in case everyone didn't hear: Congratulations Gail for making MVP again!

    d'oh missed that announcement. Seriously though, was there ever any doubt?

    Congrats Gail

    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

    July 1, 2011 at 11:04 am

    #1347205

  • RE: Unnecessary Index?

    GilaMonster (7/1/2011)

    No. Not with a table this narrow. If I was doing indexing work, that one would be on my list to drop without serious concern.

    Just do a check (query...

    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

    July 1, 2011 at 11:01 am

    #1347199

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