Forum Replies Created

Viewing 15 posts - 9,541 through 9,555 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (7/1/2011)


    Gus, you own me a new keyboard!

    GSquared (7/1/2011)


    I must be misunderstanding you. I've never before seen someone recommend hypocrisy before without it being essentially sarcastic.

    You should go for...

    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

  • RE: Unnecessary Index?

    croberts 36762 (7/1/2011)


    GilaMonster (7/1/2011)


    In this particular case there are very few advantages to having that exact index, seeing as the table is so small. Swapping the columns around (col4, col1)...

    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

  • RE: Transaction Log

    My 2 bits

    Admins most certainly need to be familiar with the catalog views and the DMVs. The new DMVs that were designed to replace sysprocesses are many times better....

    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

  • RE: Are the posted questions getting worse?

    Our soup friend has struck again.

    http://www.sqlservercentral.com/Forums/Topic1135058-360-1.aspx#bm1135196

    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

  • RE: Unnecessary Index?

    Syed Jahanzaib Bin hassan (7/1/2011)


    Dont use Clustered index column in the NonClustered index this is overhead and leaf level of this nonclustered index will be same as your index when...

    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

  • RE: SQL Account Loses Mapping

    There wasn't a database restore done was there?

    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

  • RE: Raw Materials - Harmonious Connections

    FUNNY

    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

  • RE: First Normal Form

    Thanks Tom. This is a topic that needs to be covered time and again. Good work.

    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

  • RE: Can't access my SQL Express 2008 database

    Have you verified that the service for that instance is running?

    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

  • RE: Unnecessary Index?

    Agreed with Lutz. It depends. He gave good reasons. I would look at execution plans involving the table and indexes in 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

  • RE: Sql Server 2008 DBA certification

    If you would like, I posted what I did to study.

    http://jasonbrimhall.info/2011/06/30/70-450-study-guide/

    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

  • RE: Are the posted questions getting worse?

    mtillman-921105 (7/1/2011)


    Bruce W Cassidy (6/30/2011)


    Somehow, I am unsurprised that this thread is still going...

    Yes, but it seems to be on life support this morning.

    I hope I was wrong,...

    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

  • RE: protocals

    This sounds like a question related either to an exam or an interview.

    Are you looking just for the communications protocols or do you have something specific about one 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

  • RE: Passed My Exam

    trevelvis (7/1/2011)


    Congrats!

    Can I ask - how many questions are there in the exam?

    50 questions

    2 hrs to take the exam

    If you work out some solutions based on the Skills Measured (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

  • RE: Passed My Exam

    mikes84 (6/30/2011)


    I'm not sure anyone really cares, but I earned my

    MCTS: SQL Server 2008, Database Development

    certification today. It took a lot of studying as many of you know, but...

    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

Viewing 15 posts - 9,541 through 9,555 (of 19,560 total)