Forum Replies Created

Viewing 15 posts - 10,861 through 10,875 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (3/15/2011)

    WayneS (3/15/2011)

    Does anyone know if we'll be able to download them later on?

    Streaming, not download. Something an issue with but PASS doesn't seem to be willing to change

    Quite 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

    March 15, 2011 at 11:52 am

    #1299035

  • RE: SQL Script to check SQL Server cluster Nodes.

    Steve Jones - SSC Editor (3/15/2011)

    Points have been awarded back and the question corrected to ask which one should be used, and then to note the DMV is the correct...

    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 15, 2011 at 10:08 am

    #1298956

  • RE: SQL Script to check SQL Server cluster Nodes.

    Koen Verbeeck (3/15/2011)

    Chris Houghton (3/15/2011)

    Tested select * from ::fn_virtualservernodes() on both 2005 and 2008 clusters and it returned correct results for both.

    So apparently all the three answers are correct?

    Everybody wins!...

    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 15, 2011 at 10:06 am

    #1298953

  • RE: SQL Script to check SQL Server cluster Nodes.

    stewartc-708166 (3/15/2011)

    Given a choice between a function marked for deprecation and a fully functional DMV, I believe most of us would rather choose the DMV, as it would prevent re-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

    March 15, 2011 at 10:06 am

    #1298952

  • RE: SQL Script to check SQL Server cluster Nodes.

    bitbucket-25253 (3/14/2011)

    Here we go again -- the specified as correct answer is an item to be depreciated in a future release of SQL Server and one possible answer, and 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 14, 2011 at 11:04 pm

    #1298674

  • RE: SQL Server 2008 R2 Features

    Nice question indeed. Many of us could use more of those "enterprise" features in the standard edition.

    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 14, 2011 at 10:59 pm

    #1298672

  • RE: Are the posted questions getting worse?

    Craig - if you need more eyes, I can look over an article or two.

    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 14, 2011 at 12:26 pm

    #1298522

  • RE: Today's Random Word!

    Pecan (pi)

    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 14, 2011 at 12:23 pm

    #1298520

  • RE: Displaying Sorted Hierarchies (SQL Spackle)

    Jeff Moden (3/14/2011)

    CirquedeSQLeil (3/14/2011)

    Jeff Moden (3/10/2011)

    CirquedeSQLeil (3/10/2011)

    Nice article Jeff. I have used a very similar method to this for very large hierarchies. Nice examples and well explained and...

    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 14, 2011 at 11:13 am

    #1298466

  • RE: Displaying Sorted Hierarchies (SQL Spackle)

    Jeff Moden (3/10/2011)

    CirquedeSQLeil (3/10/2011)

    Nice article Jeff. I have used a very similar method to this for very large hierarchies. Nice examples and well explained and illustrated.

    Thank you, Jason....

    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 14, 2011 at 9:47 am

    #1298413

  • RE: LOB Data

    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

    March 12, 2011 at 12:03 pm

    #1298026

  • RE: DBA Concerns

    I would hope that the poll would show differently for SQL Server DBAs. DBAs should have a handle and some knowledge of the security surrounding the data for which...

    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 10, 2011 at 12:53 pm

    #1297328

  • RE: Today's Random Word!

    Daniel Bowlin (3/10/2011)

    crookj (3/10/2011)

    WOTD - Hoya

    Joe

    Hoyer

    Holla

    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 10, 2011 at 10:21 am

    #1297225

  • RE: Displaying Sorted Hierarchies (SQL Spackle)

    Nice article Jeff. I have used a very similar method to this for very large hierarchies. Nice examples and well explained and illustrated.

    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 10, 2011 at 10:16 am

    #1297218

  • RE: Visual Studio Tools

    Nice 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

    March 10, 2011 at 10:11 am

    #1297213

Viewing 15 posts - 10,861 through 10,875 (of 19,560 total)